Microsoft Excel Course

Working with Advanced Functions

• Working with Functions
• Using the IF Function
• Nesting Functions
• Using Multiple Conditions with the IF Function
• Using Table Lookup Functions
• Using Text Functions
• Using One-Input Data Tables
• Using Two-Input Data Tables

Analyzing Data

• Using Automatic
• Outlining Consolidating Information by Position or Category
• Inserting Subtotals
• Creating an Advanced Filter
• Using Database Functions

Using PivotTables

• Understanding PivotTables
• Using the PivotTable and PivotChart Wizard
• Laying out a PivotTable on a Worksheet
• Modifying PivotTable Fields
• Working with Page Fields
• Refreshing a PivotTable

Enhancing PivotTables

• Formatting a PivotTable
• Working with Summary Functions
• Sorting Items in a PivotTable
• Grouping Data
• Using AutoShow in a PivotTable
• Creating a Calculated Field
• Creating a Calculated Item
• Creating Charts from PivotTables

Working with Data Analysis Tools

• Creating Scenarios
• Working with Scenarios
• Using Goal Seek
• Understanding Solver
• Defining a Problem
• Solving a Problem
• Generating a Report of Results and Alternate Solutions

Working with Macros

• Recording a Macro
• Executing a Macro
• Creating a Macro Button
• Working with Macro Buttons

Using Special Features

• Importing and Exporting Data
• Working with Hypertext Links

Prerequisites:

• A solid understanding of Windows’ file management, the concepts of right-clicking and selecting object properties
• Successful completion of Excel Intermediate class or equivalent experience providing a basic understanding of worksheets, cell formatting, and formulas.