In our Excel Advanced class you will learn importing and exporting, use data forms and named ranges, format numbers, use the solver, sort and filter lists, create macros, learn spreadsheet protection and validation, master data validation, merge and link workbooks, and use advanced data analysis tools.

Chapter One: Automating Tasks with Macros

• Recording a Macro
• Playing a Macro and Assigning a Macro a Shortcut Key
• Adding a Macro to a Toolbar
• Editing a Macro’s Visual Basic Code
• Inserting Code in an Existing Macro
• Declaring Variables and Adding Remarks to VBA Code
• Prompting for User Input
• Using the If…Then…Else Statement

Chapter Two: Using Excel with the Internet

• Adding and Working with Hyperlinks
• Browsing Hyperlinks and using the Web Toolbar
• Saving a Workbook as a Non-Interactive Web Page
• Saving a Workbook as an Interactive Web Page
• Import an External Data Source
• Refresh a Data Source and Set Data Source Properties
• Create a New Web Query

Chapter Three: Data Analysis and PivotTables

• Creating a PivotTable
• Specifying the Data a PivotTable Analyzes
• Changing a PivotTable's Calculation
• Selecting What Appears in a PivotTable
• Grouping Dates in a PivotTable
• Updating a PivotTable
• Formatting and Charting a PivotTable
• Creating Subtotals
• Using Database Functions
• Using Lookup Functions
• Grouping and Outlining a Worksheet

Chapter Four: What If Analysis

• Defining a Scenario
• Creating a Scenario Summary Report
• Using a One and Two Input Data Table
• Understanding Goal Seek
• Using Solver

Chapter Five: Advanced Topics

• Hiding, Displaying, and Moving Toolbars
• Customizing Excel’s Toolbars
• Sending Faxes
• Creating a Custom AutoFill List
• Changing Excel’s Options
• Password Protecting a Workbook
• File Properties and Finding a File
• Sharing a Workbook and Tracking Changes
• Merging and Revising a Shared Workbook
• Using Detect and Repair