Categories Pricing Corporate
home.libro.professionale_ebook

Excel 2010 Advanced

0 Recensioni
8 Recensioni
256
Lingua:  English
This Excel 2010 eBook should be used as a point of reference after following attendance of the advanced level Excel 2010 training course.
Abbonamento Professional Plus gratuito per i primi 30 giorni poi $8.99 /mese
Non ci sono pubblicità nel libro
Descrizione
Contenuto
Recensioni

This Excel 2010 eBook should be used as a point of reference after following attendance of the advanced level Excel 2010 training course. It covers all the topics taught and aims to act as a support aid for any tasks carried out by the user after the course.

The manual is divided into sections, each section covering an aspect of the advanced course. The table of contents lists the page numbers of each section and the table of figures indicates the pages containing tables and diagrams.

  1. Advanced worksheet functions
    1. Conditional & Logical Functions
    2. Counting And Totalling Cells Conditionally
    3. And, Or, Not
    4. Lookup Functions
  2. Views, scenarios, goal seek, solver
    1. Goal Seeking And Solving
    2. Advanced Solver Features
    3. Scenarios
    4. Views
  3. Using excel to manage lists
    1. Excel Lists,List Terminology
    2. Sorting Data
    3. Subtotals
    4. Filtering A List
    5. Advanced Filtering
    6. Criteria Tips
    7. Multiple Criteria
    8. Calculated Criteria
    9. Data Consolidation
    10. Pivottables
    11. Modifying A Pivottable
    12. Managing Pivottables
    13. Formatting A Pivottable
    14. Banding
    15. Slicers
  4. Charts
    1. Introduction To Charting 143 Creating Charts 145 Formatting Charts 157 Changing The Chart Layout 163 Sparklines
  5. Templates
    1. Introduction To Templates
    2. Create Custom Templates
  6. Drawing and formatting
    1. Inserting, Formatting And Deleting Objects
    2. More Formatting
  7. Excel tools
    1. Reviewing
    2. Auditing
    3. Proofing Tools
Ce livre est excellent, vous trouverez tout ce dont vous avez besoin.
My productivity levels have never been boosted this massively. The book is a must have for every individual and office.
Great resource, a true treasure for those who want to handle Excel 2010 with ease.
This is useful for students, thank you for publishing this book.
It is a good book to get an advanced look into Excel
I like it, I have used it a lot. I can highly recommend it!
Fantastic book
Excellent
More reviews
home.libro.su_autore

Stephen Moffat, The Mouse Training Company

Stephen Moffat has been a teacher in one form or another most of his life.

In 1998 Steve completed his studies and qualified with many training qualifications and started IT training for a little known company in the north of England. Restricted by company politics he quickly went freelance and never looked back. Training Microsoft Applications in the Public and private sector He moved to London and worked for many prestigious firms in the square mile and further afield. Training not only in England but working for international companies based in Europe saw him in several European countries training there.

Writing manuals since the early office versions found him basing his manuals on his classroom and mentoring experience shaping the structure of the manuals he wrote adding many topic hints not found in standard how to manuals.

Fully experienced with all Microsoft Applications Saw his manual writing, expand from the standard Word, Excel and PowerPoint to applications like Project and Visio.