Excel 2013 - Level 3

Course details

In this course students will learn some of the more advanced features of Excel, including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analyzing data, and using Excel data in other applications. 

What will I learn?

Lesson 1: Automating Worksheet Functionality

• Update Workbook Properties
• Create a Macro
• Edit a Macro
• Apply Conditional Formatting
• Add Data Validation Criteria

Lesson 2: Auditing Worksheets

• Trace Cells
• Troubleshoot Invalid Data and Formula Errors
• Watch and Evaluate Formulas
• Create a Data List Outline

Lesson 3: Analyzing and Presenting Data

• Create Sparklines
• Create Scenarios
• Perform a What-If Analysis
• Perform a Statistical Analysis with the Analysis Toolpak
• Create Interactive Data with Power View

Lesson 4: Working with Multiple Workbooks

• Consolidate Data
• Link Cells in Different Workbooks
• Merge Workbooks

Lesson 5: Exporting Excel Data

• Export Excel Data
• Import a Delimited Text File
• Integrate Excel Data with the Web
• Create a Web Query

Requirements

Students enrolling in this class should have experience working in Excel, creating, editing, and managing workbooks.

Excel 2013 - Level 1

Excel 2013 - Level 2