Home / Courses / Microsoft End User / Excel 2013: Level 3

Excel

Excel 2013: Level 3

Lesson 1: Automating Worksheet Functionality
Topic A: Update Workbook Properties
Topic B: Create and Edit a Macro
Topic C: Apply Conditional Formatting
Topic D: Add Data Validation Criteria

Lesson 2: Auditing Worksheets
Topic A: Trace Cells
Topic B: Troubleshoot Invalid Data and Formula Errors
Topic C: Watch and Evaluate Formulas
Topic D: Create a Data List Outline

Lesson 3: Analyzing and Presenting Data
Topic A: Create Sparklines
Topic B: Create Scenarios
Topic C: Perform a What-If Analysis
Topic D: Perform a Statistical Analysis with the Analysis ToolPak
Topic E: Create Interactive Data with Power View

Lesson 4: Working with Multiple Workbooks
Topic A: Consolidate Data
Topic B: Link Cells in Different Workbooks
Topic C: Merge Workbooks

Lesson 5: Exporting Excel Data
Topic A: Export Excel Data
Topic B: Import a Delimited Text File
Topic C: Integrate Excel Data with the Web
Topic D: Create a Web Query

Appendix A: Importing and Exporting XML Data

 

Course Registration

 

1 day
$245.00

 

Course Outline

 

Request