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.

Introduction

Section 1 Advanced worksheet Functions
1.1 Names
1.2 Using Names
1.3 Conditional & Logical Functions
1.4 AND, OR, NOT
1.5 Lookup Functions
1.6 Other Useful Functions
1.7 Data consolidation

Section 2 Views, Scenarios, goal seek and solver
2.1 Goal Seeking and Solving
2.2 Views & Scenarios

Section 3 Using Excel to Manage Lists
3.1 Excel Lists, List Terminology
3.2 Sorting Data
3.3 Adding Subtotals to a List
3.4 Filtering a List
3.5 List Statistics
3.6 Pivottables
3.7 Managing Pivottables