Microsoft Excel 2019
Introductory
Student Area
Module 1: Getting Started with Excel
OBJECTIVES:
- Open and close a workbook
- Navigate through a workbook and worksheet
- Select cells and ranges
- Plan and create a workbook
- Insert, rename, and move worksheets
- Enter text, dates, and numbers
- Undo and redo actions
- Resize columns and rows
- Enter formulas and the SUM and COUNT functions
- Copy and paste formulas
- Move or copy cells and ranges
- Insert and delete rows, columns, and ranges
- Create patterned text with Flash Fill
- Add cell borders and change font size
- Change worksheet views
- Prepare a workbook for printing
Module 1 - Student Files
Module 1 - Text
| Excel 2019 - Module 1 PDF |
Module 1 - Overview
|
Video Overview
|
PowerPoint Slides
| ||
Module 1 - Data Files
|
Case 1
|
Case 2
|
Module
| ||||||
Module 1 - Test
Module 2: Formatting Workbook Text and Data
OBJECTIVES:
- Change fonts, font style, and font color
- Add fill colors and a background image
- Create formulas to calculate sales data
- Format numbers as currency and percentages
- Format dates and times
- Align, indent, and rotate cell contents
- Merge a group of cells
- Use the AVERAGE function
- Apply cell styles
- Copy and paste formats with the Format Painter
- Find and replace text and formatting
- Change workbook themes
- Highlight cells with conditional formats
- Format a worksheet for printing
Module 2 - Student Files
Module 2 - Text
| Excel 2019 - Module 2 PDF |
Module 2 - Overview
|
Video Overview
|
PowerPoint Slides
| ||
Module 2 - Data Files
|
Case 1
|
Case 2
| ||||
|
Module
|
Review
| ||||||||
Module 2 - Test
Module 3: Performing Calculations with Formulas and Functions
OBJECTIVES:
- Translate an equation into a function
- Do calculations with dates and times
- Extend data and formulas with AutoFill
- Use the Function Library
- Calculate statistics
- Using the Quick Analysis toolbar
- Use absolute and relative cell references
- Use a logical function
- Retrieve data with lookup tables
- Do what-if analysis with Goal Seek
Module 3 - Student Files
Module 3 - Text
| Excel 2019 - Module 3 PDF |
Module 3 - Overview
|
Video Overview
|
PowerPoint Slides
| ||
Module 3 - Data Files
|
Case 1
|
Case 2
| ||||
|
Module
|
Review
| ||||
Module 3 - Test
Module 4: Analyzing and Charting Financial Data
OBJECTIVES:
- Create a pie chart
- Format chart elements
- Create a line chart
- Work with chart legends
- Create a combination chart
- Create a scatter chart
- Edit a chart data source
- Create a data callout
- Insert shapes and icons into a worksheet
- Create and edit a data bar
- Create and edit a group of sparklines
Module 4 - Student Files
Module 4 - Text
| Excel 2019 - Module 4 PDF |
Module 4 - Overview
|
Video Overview
|
PowerPoint Slides
| ||
Module 4 - Data Files
|
Case 1
|
Case 2
| ||||
|
Module
|
Review
| ||||
Module 4 - Test