Topic 1

Automating Worksheet Functionality

• Workbook Properties
• Macros
• Conditional Formatting
• Data Validation

Topic 2

Auditing Worksheets

• The Trace Cells Feature
• Invalid Data
• The Watch Window
• Outlines

Topic 3

Analyzing and Presenting Data

• Sparklines
• Scenarios
• Add-In Types
• Analysis ToolPak
• The Power View Add-In

Topic 4

Working with Multiple Workbooks

• Data Consolidation
• The Consolidate Dialog Box
• Consolidation Functions
• External References
• The Compare and Merge Workbooks Feature

Topic 5

Exporting Excel Data

• The Export Process
• The Get External Data Group
• Delimited Text Files
• Methods of Importing Text Files
• The File Publishing Process
• Publish as Web Page Dialog Box
• Web Queries
• The New Web Query Dialog Box

Topic 6

Importing and Exporting XML Data

• XML
• XML Components
• XML Schemas
• XML Maps
• The XML Source Task Pane
• Import and Export XML Data