1/2 Day Class

This fast paced course has been designed to accommodate the time constrained individual who needs to understand and use some of the more advanced features that Excel offers.

Topics Include:

Sorting and Filtering Data

• Sort Data
• Add Subtotals to a Worksheet
• Filter Lists
• Create and Apply Custom Filters
• Advanced Filter

Working with Advanced Formulas & Auditing

• Share Data Among Worksheets
• Create a Name for a Range of Cells
• Use Functions to Create Advanced Formulas
•           =IF( ), =VLOOKUP( ), =ISERROR( ), =NOW( )
•           =PMT( )
• Trace Cell Precedents
• Trace Cell Dependents

Analyzing Data

• Create Scenarios
• Use Solver
• Use Goal Seek