© 2019 Nightwing Consulting & Rhonda Williams Byrd

Excel Level 3 Outline

Lesson 1 -  Using Advanced Functions

Using Lookup Functions

Using the VLOOKUP Function

Using the HLOOKUP Function

Using the IF Function

Using Nested IF Functions

Using the ISERROR Function

Using an AND Condition with IF

Using an OR Condition with IF

Using the ROUND Function

Limiting the Precision of Numbers

Lesson 2 -  Exporting and Importing Data

Exporting Data to Other Applications

Importing Data from Access

Importing Data from Text Files

Changing External Data Range Properties

Importing Data from Other Applications

Removing the Query Definition

Importing Dynamic Data from the Web

Copying a Table from a Web Page

 

Lesson 3 -  Working with Outlines

Applying an Outline

Collapsing/Expanding an Outline

Modifying Outline Settings

Using Auto Outline

Clearing an Outline

Creating Subtotals in a List

Removing Subtotals from a List

 

Lesson 4 -  Using Conditional and Custom Formats

Applying Conditional Formats

Changing a Conditional Format

Adding a Conditional Format

Creating a Custom Conditional Format

Using Data Bars

Deleting a Conditional Format

Creating a Custom Number Format

 

Lesson 5 -  Using Paste Special

Working with Paste Special

Copying Values between Worksheets

Copying Formulas between Worksheets

Performing Mathematical Operations

Lesson 6 -  Using Multiple Workbooks

Opening Multiple Workbook Windows

Cascading Open Workbook Windows

Activating Cascaded Workbook Windows

Tiling Open Workbook Windows

Activating Tiled Workbook Windows

Comparing Workbooks Side by Side

Copying Data between Workbooks

Saving a Workspace

Closing All Open Workbooks

Opening a Workspace

Linking Workbooks

Opening Linked Workbooks

 

Lesson 7 -  Working with Data Series

Using the Series Command

Creating a Linear Series

Creating a Date Series

Using a Stop Value

Creating a Growth Trend Series

 

Lesson 8 -  Creating/Revising PivotTables

Creating a PivotTable Report

Adding PivotTable Report Fields

Selecting a Report Filter Field Item

Refreshing a PivotTable Report

Changing the Summary Function

Adding New Fields to a PivotTable Report

Moving PivotTable Report Fields

Using Expand and Collapse Buttons

Hiding/Unhiding PivotTable Report Items

Deleting PivotTable Report Fields

Creating Report Filter Pages

Formatting a PivotTable Report

Creating a PivotChart Report

Publishing PivotTable Reports to the Web

 

Lesson 9 -  Using Scenarios and Goal Seeking

Using the Scenario Manager

Creating a Scenario

Displaying a Scenario

Editing a Scenario

Creating a Scenario Summary Report

Using Goal Seek

 

Lesson 10 -  Consolidating Worksheets

Using Consolidated Worksheets

Consolidating by Category or Position