Using Advanced Functions and Summarizing Data

Using Microsoft Excel

3 Hours
Versions 2003 or 2007

Writing More Advanced Formulas

Absolute vs. Relative Cell References

Using =IF Functions

Using More Advanced Functions

Using Subtotals

Using the VLOOKUP Function

Creating Named Ranges

Using the ISERROR Function

Summarizing and Analyzing Data

Using PivotTables to Summarize Data

Creating Scenarios

Grouping and Outlining Worksheets

Working with Custom Views