Excel 2003 Advanced

Ratings :
( 18 )
140 pages
Language:
 English
Excel 2003 Advanced 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

Excel 2003 Advanced 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. Introduction
    1. Using advanced Worksheet functions
    2. Names
    3. USING NAMES
    4. Conditional & Logical Functions
    5. Value if True / False
    6. SOLVER
  2. Views, Scenarios & Reports
    1. Views & Scenarios
  3. Using Excel to Manage Lists
    1. Excel Lists
    2. Sorting Data
    3. Adding subtotals to a list
    4. Filtering a List
    5. Advanced Filtering
    6. Copying filtered data
    7. List Statistics
    8. Pivot Tables
  4. Charts
    1. Introduction to Charting
    2. ChartWizard
    3. Data Layout
    4. Chart Toolbar
    5. Chart Types
    6. Font
    7. Manipulating Chart Data
  5. Templates
    1. Introduction to templates
  6. Auditing
    1. Auditing features
    2. Precendents and Dependants
    3. Comments