Excel 2010 - Part 3 - Class Outline

Print Preview \| E-Mail Outline

Excel 2010 - Part 3 Duration: Traditional Instructor Led Learning - 1.00 Day(s) Online Anytime - Self Paced Online Live - 1.00 Sessions Mentored Learning - Flexible Overview: The students will learn about some of the more advanced features of Excel including automating common tasks, auditing workbooks to avoid errors, sharing data with other people, analyzing data, and using Excel data in other applications. Who Should Attend: This course is intended for a student who has experience working with Excel and would like to learn more about creating macros, working with shared documents, analyzing data, and auditing worksheets. At Course Completion: After course completion you will know how to: • Automate worksheet functions. • Audit worksheets. • Analyze data. • Work with multiple workbooks. • Import and export data.
Prerequisite(s) or equivalent knowledge:
Excel 2010 - Part 1 Excel 2010 - Part 2
Prerequisite Comments:
Students enrolling in this class should have experience working in Excel, creating, editing, and managing workbooks.

Outline:	Top
Lesson 1: Automating Worksheet Functionality
Update Workbook Properties Create and Edit a Macro Apply Conditional Formatting Add Data Validation Criteria	Top
Lesson 2: Auditing Worksheets
Trace Cells Troubleshoot Invalid Data and Formula Errors Watch and Evaluate Formulas Create a Data List Outline
Lesson 3: Analyzing Data
Create Sparklines Create Scenarios Perform a What-If Analysis Perform a Statistical Analysis with the Analysis ToolPak
Lesson 4: Working with Multiple Workbooks
Create a Workspace Consolidate Data Link Cells In Different Workbooks Merge Workbooks
Lesson 5: Exporting Excel Data
Export Excel Data Import a Delimited Text File Integrate Excel Data with the Web Create a Web Query	Top

*Content, days, and times vary depending on your location. Please view the outline on the checkout page prior to purchase or
contact the local center for more information.