Duration: 1 Day
In this course, you will learn about some of the more advanced features of
Excel, including automating common tasks, auditing workbooks to avoid errors,
sharing your data with other people, analyzing data, and using Excel data in
other applications.
This course includes access to our exclusive Microsoft Office Online Support
Program, enabling you to build your skills and expertise after class. The
program provides 24x7 access for 60 Days to:
- Online labs for continued practice and skills-building
- Online mentoring via chat from Microsoft Office experts
- Access to your recorded class, indexed and searchable for your review
and reference
Certification:
This course is one of three recommended to help you prepare for Microsoft
Exam 77-882: Excel 2010, which is required for the Microsoft Office Specialist
(MOS): Microsoft Office Excel 2010 certification.
What You Will Learn
- Automate worksheet functions
- Audit worksheets
- Analyze data
- Work with multiple workbooks
- Import and export data
Audience
Anyone with has experience working in Excel and would like to learn more about creating macros, working with shared documents, analyzing data, and auditing worksheets
Prerequistes
Course Outline
1. Automating Worksheet Functionality
- Updating Workbook Properties
- Creating and Editing a Macro
- Applying Conditional Formatting
- Adding Data Validation Criteria
2. Auditing
Worksheets
- Tracing Cells
- Troubleshooting Invalid
Data and Formula Errors
- Watching and Evaluating Formulas
- Creating a Data List Outline
3. Analyzing Data
- Creating Sparklines
- Creating Scenarios
- Performing a What-If Analysis
- Performing a Statistical Analysis with the Analysis ToolPak
4.
Working with Multiple Workbooks
- Creating a Workspace
- Consolidating Data
- Linking
Cells In Different Workbooks
- Merging Workbooks
5. Exporting Excel Data
- Exporting Excel Data
- Importing a Delimited Text File
- Integrating Excel Data with the Web
- Creating a Web Query
Course Labs
