Course outline

Module 1: Creating a Microsoft Excel Workbook
This module explains how to create and start working with workbooks and worksheets.
Lessons
• Starting Microsoft Excel
• Creating a Workbook
• Saving a Workbook
• The Status Bar
• Adding and Deleting Worksheets
• Copying and Moving Worksheets
• Changing the Order of Worksheets
• Splitting the Worksheet Window
• Closing a Workbook
Lab: Creating a Microsoft Excel Workbook
After completing this module, students will be able to:
• Start Microsoft Excel.
• Create a Microsoft Excel workbook.
• Save a Microsoft Excel workbook.
• Understand the Status Bar.
• Add and delete Microsoft Excel worksheets.
• Copy and move worksheets.
• Split the worksheet window.8. To close a Microsoft Excel workbook.

Module 2: The Ribbon
This module explains how to work with the Ribbon.
Lessons
• Tabs
• Groups
• Commands
Lab: The Ribbon Exercises
• Open a Workbook
• Select, Open, and Save a Template Agenda
After completing this module, students will be able to:
• Work with tabs.
• Work with groups.
• Work with commands.
• Know which groups and commands are found on which tabs.

Module 3: The Backstage View (The File Menu)
This module explains how to work with the Backstage View.
Lessons
• Introduction to the Backstage View
• Opening a Workbook
• Open a Workbook
• New Workbooks and Excel Templates
• Select, Open and Save a Template Agenda
• Printing Worksheets
• Print a Worksheet
• Adding Your Name to Microsoft Excel
• Adding a Theme to Microsoft Excel
Lab: Backstage View Exercises
• Print a Worksheet
• Open a Workbook
After completing this module, students will be able to:
• Work with the Backstage view.
• Open a Microsoft Excel workbook.
• Start a new Microsoft Excel workbook.
• Use Microsoft Excel templates.
• Print a Microsoft Excel workbook.
• Personalize your copy of Microsoft Excel

Module 4: The Quick Access Toolbar
This module explains how to work with the Quick Access Toolbar.
Lessons
• Adding Common Commands
• Adding Additional Commands with the Customize Dialog Box
• Adding Ribbon Commands or Groups
• Placement
• Customize the Quick Access Toolbar
Lab: Customize the Quick Access Toolbar
After completing this module, students will be able to:
• Add common commands to the Quick Access Toolbar.
• Add additional commands to the Quick Access Toolbar.
• Move the Quick Access Toolbar.

Module 5: Entering Data in Microsoft Excel Worksheets
This module explains how to enter data in Microsoft Excel worksheets.
Lessons
• Entering Text
• Adding and Deleting Cells
• Adding a Hyperlink
• Add WordArt to a Worksheet
• Using AutoComplete
• Entering Text and Using AutoComplete
• Entering Numbers and Dates
• Using the Fill Handle
• Entering Numbers and Dates
Lab: Entering Data Exercises
• Entering Text and Using AutoComplete
• Entering Numbers and Dates
After completing this module, students will be able to:
• Enter text in Microsoft Excel worksheets.
• Add or delete cells in worksheets.
• Add an outline for your data.
• Enter a hyperlink in a worksheet.
• Use AutoComplete.
• Enter numbers and dates in Microsoft Excel worksheets.
• Use the Fill Handle to add data to cells.

Module 6: Formatting Microsoft Excel Worksheets
This module explains how to format Microsoft Excel worksheets.
Lessons
• Selecting Ranges of Cells
• Hiding Worksheets
• Adding Color to Worksheet Tabs
• Adding Themes to Workbooks
• Customize a Workbook Using Tab Colors and Themes
• Adding a Watermark
• The Font Group
• Working with Font Group Commands
• The Alignment Group
• Working with Alignment Group Commands
• The Number Group
• Working with Number Group Commands
Lab: Formatting Worksheets Exercises
• Customize a Workbook Using Tab Colors and Themes
• Working with Font Group Commands
• Working with Alignment Group Commands
• Working with Number Group Commands
After completing this module, students will be able to:
• Understand various ways you can format Microsoft Excel worksheets.
• Select a range of cells within a worksheet.
• Hide worksheets.
• Add color to workbook tabs.
• Add themes to worksheets.
• Bold, italicize and underline text.
• Add borders to cells.
• Change text and cell colors.
• Change the font and font size.
• Align text.
• Wrap text.
• Indent text.
• Merge and center text.
• Change number formats.
• Change date formats.
• Show decimals.

Module 7: Using Formulas in Microsoft Excel
This module explains how to work with formulas in Microsoft Excel.
Lessons
• Math Operators and the Order of Operations
• Entering Formulas
• AutoSum (and Other Common Auto-Formulas)
• Copying Formulas and Functions
• Relative, Absolute, and Mixed Cell References
• Working with Formulas
Lab: Working with Formulas
After completing this module, students will be able to:
• Understand math operators and the order of operations in Excel.
• Enter basic formulas.
• Use AutoSum to sum data with one click.
• Understand absolute, relative, and mixed cell references.
• Copy formulas and functions.

Module 8: Working with Rows and Columns
This module explains how to work with rows and columns in Microsoft Excel.
Lessons
• Inserting Rows and Columns
• Deleting Rows and Columns
• Transposing Rows and Columns
• Setting Row Height and Column Width
• Hiding and Unhiding Rows and Columns
• Freezing Panes
• Working with Rows and Columns
Lab: Working with Rows and Columns
After completing this module, students will be able to:
• Insert rows and columns in Microsoft Excel worksheets.
• Delete rows and columns in Microsoft Excel worksheets.
• Transpose rows and columns.
• Change row heights.
• Change column widths.
• Hide and unhide rows and columns.
• Freeze panes.

Module 9: Editing Worksheets
This module explains how to edit worksheets in Microsoft Excel.
Lessons
• Find
• Find and Replace
• Using Find and Replace
• Using the Clipboard
• Using Format Painter
• Managing Comments
Lab: Editing Worksheets Exercises
• Using Find and Replace
• Using the Clipboard
• Using Format Painter
After completing this module, students will be able to:
• Locate information in your worksheet using Find.
• Use Find and Replace to quickly replace data with other data.
• Use the Cut, Copy, Paste and Format Painter commands to edit worksheets.
• Manage comments

Module 10: Finalizing Microsoft Excel Worksheets
This module explains how to finalize Microsoft Excel worksheets.
Lessons
• Setting Margins
• Setting Page Orientation
• Setting the Print Area
• Print Scaling (Fit Sheet on One Page)
• Printing Headings on Each Page/Repeating Headers and Footers
• Headers and Footers
• Preparing to Print
Lab: Preparing to Print
After completing this module, students will be able to:
• Set margins in Microsoft Excel worksheets.
• Set the page orientation to portrait or landscape.
• Set the print area in a worksheet.
• Scale a worksheet so that all data prints on one page. Add headers and footers to a worksheet.