About Lesson
After completing this course, participants will have learned to:
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