Excel 2010 Exam Bundle Training Course - Training Options

Training » Categories » Microsoft Office » Excel » Excel 2010 Exam Bundle

Course Summary

This bundle combines Excel 2010 Level 1, Level 2 and Level 3 and also includes the Microsoft Office Specialist Exam at the end of the classes.

Duration

3 days.

3 course(s)

Outline

Excel 2010 Level 1 (1 day)

Lesson 1: Creating a Basic Excel Worksheet: Topic 1A: Identify the Elements of the User Interface; Topic 1B: Customize the Excel Interface; Topic 1C: Work with Cells; Topic 1D: Enter Data in an Excel Workbook; Topic 1E: Obtain Help in Excel

Lesson 2: Performing Calculations in an Excel Worksheet: Topic 2A: Create Basic Formulas; Topic 2B: Calculate the Cell Values by Using Functions; Topic 2C: Copy Formulas and Functions

Lesson 3: Modifying an Excel Worksheet: Topic 3A: Manipulate Data; Topic 3B: Modify the Worksheet Elements; Topic 3C: Search for Data in a Worksheet; Topic 3D: Modify Rows and Columns

Lesson 4: Formatting an Excel Worksheet: Topic 4A: Modify Fonts; Topic 4B: Check a Worksheet for Spelling Errors; Topic 4C: Apply Number Formatting; Topic 4D: Add Borders and Colors to Cells; Topic 4E: Align the Content in a Cell; Topic 4F: Apply Cell Styles

Lesson 5: Printing Excel Workbooks: Topic 5A: Set the Page Layout Options; Topic 5B: Set Page Breaks; Topic 5C: Print a Workbook

Lesson 6: Managing an Excel Workbook: Topic 6A: Format Worksheet Tabs; Topic 6B: Manage Worksheets; Topic 6C: View Worksheets and Workbooks

Excel 2010 Level 2 (1 day)

Lesson 1: Calculating Data with Advanced Formulas: Topic 1A: Apply Cell and Range Names; Topic 1B: Calculate Data Across Worksheets; Topic 1C: Use Specialized Functions; Topic 1D: Analyze Data with Logical and Lookup Functions

Lesson 2: Organizing Worksheet and Table Data: Topic 2A: Create and Modify Tables; Topic 2B: Format Tables; Topic 2C: Sort or Filter Data; Topic 2D: Use Functions to Calculate Data

Lesson 3: Presenting Data Using Charts: Topic 3A: Create a Chart; Topic 3B: Modify Charts; Topic 3C: Format Charts

Lesson 4: Analyzing Data Using PivotTables, Slicers, and PivotCharts: Topic 4A: Create a PivotTable Report; Topic 4B: Filter Data Using Slicers; Topic 4C: Analyze Data Using PivotCharts

Lesson 5: Inserting Graphic Objects: Topic 5A: Insert and Modify Pictures and ClipArt; Topic 5B: Draw and Modify Shapes; Topic 5C: Illustrate Workflow Using SmartArt Graphics; Topic 5D: Layer and Group Graphic Objects

Lesson 6: Customizing and Enhancing the Excel Environment: Topic 6A: Customize the Excel Environment; Topic 6B: Customize Workbooks; Topic 6C: Manage Themes; Topic 6D: Create and Use Templates

Excel 2010 Level 3 (1 day)

Lesson 1: Streamlining Workflow: Topic 1A: Update Workbook Properties; Topic 1B: Create a Macro; Topic 1C: Edit a Macro; Topic 1D: Apply Conditional Formatting; Topic 1E: Add Data Validation Criteria

Lesson 2: Collaborating with Other Users: Topic 2A: Protect Files; Topic 2B: Share a Workbook; Topic 2C: Set Revision Tracking; Topic 2D: Review Tracked Revisions; Topic 2E: Merge Workbooks; Topic 2F: Administer Digital Signatures; Topic 2G: Restrict Document Access

Lesson 3: Auditing Worksheets: Topic 3A: Trace Cells; Topic 3B: Troubleshoot Invalid Data and Formula Errors; Topic 3C: Watch and Evaluate Formulas; Topic 3D: Create a Data List Outline

Lesson 4: Analyzing Data: Topic 4A: Create a Trendline; Topic 4B: Create Sparklines; Topic 4C: Create Scenarios; Topic 4D: Perform a What-If Analysis; Topic 4E: Perform a Statistical Analysis with the Analysis ToolPak

Lesson 5: Working with Multiple Workbooks: Topic 5A: Create a Workspace; Topic 5B: Consolidate Data; Topic 5C: Link Cells in Different Workbooks; Topic 5D: Edit Links

Lesson 6: Importing and Exporting Data: Topic 6A: Export Excel Data; Topic 6B: Import a Delimited Text File

Lesson 7: Integrating Excel Data with the Web: Topic 7A: Publish a Worksheet to the Web; Topic 7B: Import Data from the Web; Topic 7C: Create a Web Query

Lesson 8: Structuring Workbooks with XML: Topic 8A: Develop XML Maps; Topic 8B: Import and Export XML Data