Excel 2007 Advanced: Part I

Ratings :
( 84 )
131 pages
Language:
 English
Excel 2007 Advanced: Part I is one of the great eBooks available to download from our website.
This is a Business eBook
Free 30-day trial
Business subscription free for the first 30 days, then $5.99/mo
 
Buy the eBook :
Access this book on our eReader, no adverts inside the book
Latest eBooks
About the author

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...

Description
Content
Reviews

Excel 2007 Advanced: Part I is one of the great eBooks available to download from our website.

There are more than 500 textbooks, Business Books & Travel Guides in our book collection.

  1. Advanced worksheet Functions
    1. Names
    2. Using Names
    3. Conditional & Logical Functions
    4. AND, OR, NOT
    5. Lookup Functions
    6. Other Useful Functions
    7. Data consolidation
  2. SViews, Scenarios, goal seek and solver
    1. Goal Seeking and Solving
    2. Views & Scenarios
  3. Using Excel to Manage Lists
    1. Excel Lists, List Terminology
    2. Sorting Data
    3. Adding Subtotals to a List
    4. Filtering a List
    5. List Statistics
    6. Pivottables
    7. Managing Pivottables
If you think you had finished all of Excel 2007 without this book, you are definitely lying to yourself!
March 26, 2015 at 10:30 PM
More reviews