Module 1: Advanced Topics
Setting Excel Options
Changing Your User Name
Changing your Default Font
Changing Your Default File Format
Setting Formula Options
Changing the Appearance of Your Excel Interface
Step-By-Step
Skill Sharpener
Excel and Windows
Searching for Documents
Using Office Diagnostics
Checking for Updates
Starting Excel Automatically when Windows Boots
Step-By-Step
Skill Sharpener
Using the Excel Viewer
What is the Excel Viewer?
Downloading the Excel Viewer
Using Excel Viewer
Step-By-Step
Skill Sharpener
Module 2: Getting the Most From Your Data
Getting The Most From Your Data
Using Automatic Outlining
Displaying and Collapsing Levels
Grouping Data Manually
Creating Subtotals
Step-By-Step
Skill Sharpener
PivotTables
What is a PivotTable?
Creating a PivotTable
Creating a PivotTable Frame
Specifying PivotTable Data
Rearranging PivotTable Data
Step-By-Step
Skill Sharpener
:: Course EXC07A ::
More About PivotTables
Modifying PivotTable Calculations
Formatting a PivotTable
Refreshing a PivotTable
Charting a PivotTable
Creating a PivotTable Based on External Data
Step-By-Step
Skill Sharpener
Exploring Scenarios
What is a Scenario?
Creating a Scenario
Creating a Scenario Summary Report
Saving Multiple Scenarios
Step-By-Step
Skill Sharpener
What If Analysis
Using a One and Two Input Data Table
Using Goal Seek
Using Solver
Step-By-Step
Skill Sharpener
Module 3: Excel and the Internet
Excel and Hyperlinks
What is a Hyperlink?
Inserting Hyperlinks
Modifying Hyperlinks
Using Hyperlinks in Excel
Step-By-Step
Skill Sharpener
Saving Workbooks as Web Pages
HTM and MHTML Files
Saving a Workbook as a Web Page
Saving a Worksheet as a Web Page
Saving a Chart as a Web Page
Saving a Range as a Web Page
Step-By-Step
Skill Sharpener
Getting Data from the Internet
Importing from an External Data Source
Creating a Web Query
Saving a Web Query
Refreshing a Web Query
Step-By-Step
Skill Sharpener
Excel and Office Servers
Publishing to a Document Server
Saving to a Document Management Server
Using Excel with Excel Services
Step-By-Step
Skill Sharpener
:: Course EXC07A ::
Module 4: Advanced Excel Tasks
Creating and Using Shared Workbooks
Sharing a Workbook
Opening and Editing a Shared Workbook
Tracking Changes
Resolving Conflicts in a Shared Workbook
Step-By-Step
Skill Sharpener
Using Custom AutoFill Lists
What is an AutoFill List?
Creating a Custom AutoFill List
Modifying a Custom AutoFill List
Using a Custom AutoFill List
Step-By-Step
Skill Sharpener
Using the VLOOKUP Function
Using VLOOKUP to Find Data
How to Find an Exact Match with VLOOKUP
Finding the Closest Match with VLOOKUP
Step-By-Step
Skill Sharpener
Linking, Consolidating, and Combining Workbooks
Linking Workbooks
Consolidating Workbooks
Combining Worksheets
Step-By-Step
Skill Sharpener
Programme scope, delivery arrangements and suitability are confirmed during enquiry.