Using Microsoft Excel
Level 3
Course Description
Length: 6 hours
Prerequisites: Microsoft Excel - Level 2 Course
Simple Macros
• Designing Macros
• Macro Recorder
• Workbook Macros
• Personal Macros
• Running Macros
• Viewing VBA Code
Templates
Web Integration
• Saving as HTML Documents
• Inserting Hyperlinks
Add-Ins
• Analysis ToolPak
• AutoSave
Data Maps
• Inserting Maps
• Available Maps
• Map Toolbar
• Map Tools
• Map Features
Conditional Formatting
Linking Data
• Working With Workbooks
• Linking Individual Cells
• Linking Worksheets
Consolidating Worksheets
• Consolidating Worksheets
• Goal Seek
• Solver Utilities
Scenario Manager
Advanced Functions
• Error Messages
• Nested Functions
• Days360
• Networkdays
• Now
• Workday
• If
• Hyperlink
• Exact
• Lower
• Upper
• Concatenate
• VLookup
Reports
• Designing Reports
• Report Wizard
Importing & Exporting Data