Comprehensive Microsoft Excel 2010 Training

Delivery Options

• Customized Onsite Training (3 days): Request a Proposal

Class Description

Class Overview

Class Goals

• Create basic worksheets using Microsoft Excel 2010.
• Perform calculations in an Excel worksheet.
• Modify an Excel worksheet.
• Modify the appearance of data within a worksheet.
• Manage Excel workbooks.
• Print the content of an Excel worksheet.
• Learn to use formulas and functions.
• Create and modify charts.
• Convert, sort, filter, and manage lists.
• Insert and modify illustrations in a worksheet.
• Learn to use conditional formatting and styles.
• Create pivot tables and charts.
• Learn to trace precendents and dependents.
• Convert text and valiate and consolidate data.
• Collaborate with others by protecting worksheets and workbooks.
• Create, use, edit, and manage macros.
• Import and export data.

Class Outline

1. Creating a Microsoft Excel Workbook
   1. Starting Microsoft Excel
   2. Creating a Workbook
   3. Saving a Workbook
   4. The Status Bar
   5. Adding and Deleting Worksheets
   6. Closing a Workbook
2. The Ribbon
   1. Tabs
   2. Groups
   3. Commands
3. The Backstage View (The File Menu)
   1. Introduction to the Backstage View
   2. Opening a Workbook
   3. New Workbooks and Excel Templates
   4. Printing Worksheets
   5. Getting Help
   6. Adding Your Name to Microsoft Excel
4. The Quick Access Toolbar
   1. Adding Common Commands
   2. Adding Additional Commands with the Customize Dialog Box
   3. Adding Ribbon Commands or Groups
   4. Placement
5. Entering Data in Microsoft Excel Worksheets
   1. Entering Text
   2. Using AutoComplete
   3. Entering Numbers and Dates
   4. Using the Fill Handle
6. Formatting Microsoft Excel Worksheets
   1. Selecting Ranges of Cells
   2. The Font Group
   3. The Alignment Group
   4. The Number Group
7. Using Formulas in Microsoft Excel
   1. Math Operators and the Order of Operations
   2. Entering Formulas
   3. AutoSum (and Other Common Auto-Formulas)
   4. Copying Formulas and Functions
   5. Relative and Absolute Cell References
8. Working with Rows and Columns
   1. Inserting Rows and Columns
   2. Deleting Rows and Columns
   3. Setting Row Height and Column Width
   4. Hiding and Unhiding Rows and Columns
   5. Freezing Panes
9. Editing Worksheets
   1. Find
   2. Find and Replace
   3. Using the Clipboard
10. Finalizing Microsoft Excel Worksheets
    1. Setting Margins
    2. Setting Page Orientation
    3. Setting the Print Area
    4. Print Scaling (Fit Sheet on One Page)
    5. Headers and Footers
11. Advanced Formulas
    1. Using Named Ranges in Formulas
    2. Naming a Single Cell
    3. Naming a Range of Cells
    4. Naming Multiple Single Cells Quickly
    5. Using Formulas That Span Multiple Worksheets
    6. Using the IF Function
    7. Using the PMT Function
    8. Using the VLOOKUP Function
    9. Using the HLOOKUP Function
    10. Using the CONCATENATE Function
    11. Using the PROPER Function
    12. Using the LEFT and RIGHT Functions
    13. Using Date Functions
12. Working with Lists
    1. Converting a List to a Table
    2. Removing Duplicates from a List
    3. Sorting Data in a List
    4. Filtering Data in a List
    5. Adding Subtotals to a List
    6. Grouping and Ungrouping Data in a List
13. Working with Illustrations
    1. Working with Clip Art
    2. Using Shapes
    3. Working with SmartArt
14. Visualizing Your Data
    1. Inserting Charts
    2. Editing Charts
15. Advanced Formatting
    1. Applying Conditional Formatting
    2. Working with Styles
    3. Applying Styles to Tables
    4. Applying Styles to Cells
16. Using Pivot Tables
    1. Creating Pivot Tables
    2. Preparing Your Data
    3. Inserting a Pivot Table
    4. Inserting Slicers
    5. Inserting Pivot Charts
    6. More Pivot Table Functionality
17. Auditing Worksheets
    1. Tracing Precedents
    2. Tracing Dependents
    3. Showing Formulas
18. Data Tools
    1. Converting Text to Columns
    2. Data Validation
    3. Consolidating Data
    4. Goal Seek
19. Working with Others
    1. Protecting Worksheets and Workbooks
    2. Password Protecting a Workbook
    3. Password Protecting a Worksheet
    4. Password Protecting Ranges in a Worksheet
    5. Tracking Changes
    6. Accepting or Rejecting Changes
20. Recording and Using Macros
    1. Recording Macros
    2. Running Macros
    3. Editing Macros
    4. Adding Macros to the Quick Access Toolbar
21. Random Useful Items
    1. Sparklines
    2. Inserting Sparklines
    3. Customizing Sparklines
    4. Importing and Exporting Files
    5. Importing Text Files
    6. Exporting Worksheet Data to Microsoft Word
    7. Exporting Excel Charts to Microsoft Word

Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following areas is required:

• Familiarity with using a personal computer, mouse, and keyboard.
• Comfortable in the Windows environment.
• Ability to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Technical Requirements

Our computer technical requirements and setup process is easy, with support just a click away.

• Onsite course technical requirements and setup instructions.