Excel
Course Outline
Module 1: Creating a Microsoft Excel Workbook
This module explains how to create workbooks in Microsoft Excel.
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
- 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.
- Add and delete Microsoft Excel worksheets.
- Copy and move worksheets.
- Split the worksheet window.
- Close a Microsoft Excel workbook.
Module 2: The Ribbon
This module explains how to work with the Ribbon.
Lessons
- Tabs
- Groups
- Commands
Lab : Exploring the Ribbon
- Exploring the Ribbon
After completing this module, students will be able to:
- Work with tabs.
- Work with groups.
- Work with commands.
- Understand 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 aka the File menu.
Lessons
- Introduction to the Backstage View
- Opening a Workbook
- New Workbooks and Excel Templates
- Printing Worksheets
- Adding Your Name to Microsoft Excel
- Managing Workbook Versions
Lab : The Backstage View (The File Menu)
- Open a Workbook
- Select, Open and Save a Template Agenda
- Print a Worksheet
After completing this module, students will be able to:
- 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
Lab : The Quick Access Toolbar
- 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 how to enter data in Excel worksheets.
Lessons
- Entering Text
- Expand Data across Columns
- Adding and Deleting Cells
- Adding an Outline
- Adding a Hyperlink
- Add WordArt to a Worksheet
- Using AutoComplete
- Entering Numbers and Dates
- Using the Fill Handle
Lab : Entering Data in Microsoft Excel Worksheets
- 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 Excel worksheets.
Lessons
- Hiding Worksheets
- Adding Color to Worksheet Tabs
- Adding Themes to Workbooks
- Adding a Watermark
- The Font Group
- The Alignment Group
- The Number Group
Lab : Formatting Microsoft Excel Worksheets
- 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:
- Select a range of cells within a worksheet.
- Hide worksheets.
- Add color to workbook tabs.
- Add themes to worksheets.
- Apply bold, italics, and underlining to 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.
Module 7: Using Formulas in Microsoft Excel
This module explains how to use formulas in 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
Lab : Using Formulas in Microsoft Excel
- Working with Formulas
After completing this module, students will be able to:
- 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.
Lessons
- Insert lesson titles in a bulleted list.
- 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
Lab : Working with Rows and Columns
- 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.
Lessons
- Find
- Find and Replace
- Using the Clipboard
- Managing Comments
Lab : Editing Worksheets
- Using Find and Replace
- Using the Clipboard
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 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
Lab : Finalizing Microsoft Excel Worksheets
- 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.
Module 11: Microsoft Excel Features that Were New in 2013
This module explains how to use some of the features that were new in the 2013 version of Excel.
Lessons
- One Workbook Per Window Feature
- Using Flash Fill
Lab : Microsoft Excel Features that Were New in 2013
- Using Flash Fill
After completing this module, students will be able to:
- Use the one workbook per window feature.
- Use Flash Fill.
Module 12: Features New in 2016
This module explains how to use two new features in 2016.
Lessons
- Tell Me
- Smart Lookup
Lab : None
- None
After completing this module, students will be able to:
- Use the Tell Me feature.
- Use the Smart Lookup feature.