Excel 2007 Advanced: Part I

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.

Content

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

Lees de volledige beschrijving