## Course curriculum

• 1

• 2

### Microsoft Excel

• VIDEO: Introduction to Microsoft Excel

• Excel Elements

• Understanding Columns, Rows, and Cells

• Navigating In and Around Worksheets

• VIDEO: Introduction to Excel

• 3

### Chapter 1 – Introduction to Spreadsheets

• VIDEO: Introduction to Chapter 1

• Planning a Worksheet Design

• Enter Required Text (Step 1)

• Appyling Autofill as a Sequence (Step 2)

• Enter Values (Step 3)

• Enter Dates and Times (Step 4)

• Assignment 1

• 4

### Chapter 2 – Mathematical Operations and Formulas

• VIDEO: Introduction to Chapter 2

• Mathematical Operations & Formulas

• Using Cell References in Formulas (Step 1)

• Apply the Order of Operations

• Use Semi-Selection to Create a Formula (Step 2)

• Copy Formulas (Step 3)

• Displaying Cell Formulas (Step 4)

• Assignment 2

• VIDEO: Mathmatical Operations & Formulas

• 5

### Chapter 3 – Worksheet Structure and Clipboard Tasks

• VIDEO: Introduction to Chapter 3

• Worksheet Structure & Clipboard Tasks

• Insert Cells, Columns, and Rows (Step 1)

• Delete Cells, Columns, and Rows (Step 2)

• Adjust Column Width (Step 3)

• Select a Range (Step 4)

• Copy and Paste a Range (Step 5)

• Use Paste Options and Paste Special (Step 6)

• Assignment 3

• VIDEO: Worksheet Structure & Clipboard Tasks

• Chapter 3 Video: Demo File

• 6

### Chapter 4 – Worksheet Formatting

• VIDEO: Introduction to Chapter 4

• Worksheet Formatting

• Applying Cell Styles, Alignment, and Font Options (Step 1)

• Change Horizontal and Vertical Cell Alignment (Step 2)

• Increase and Decrease Indent (Step 3)

• Apply Borders and Fill Color (Step 4)

• Apply a Number Format (Step 5)

• Assignment 4

• VIDEO: Worksheet Formatting

• Chapter 4 Video: Demo File

• 7

### Chapter 5 – Worksheets, Page Setup, and Printing

• VIDEO: Introduction to Chapter 5

• Worksheets, Page Setup, and Printing

• Copy or Move a Worksheet (Step 1)

• Specify Page Options (Step 2)

• Creating Headers and Footers (Step 3)

• Previewing and Printing a Worksheet (Step 4)

• Assignment 5

• VIDEO: Worksheets, Page Setup, & Printing

• Chapter 5 Video: Demo File