BAMBIZHUB

VIDEO: Introduction to Microsoft Excel

Excel Elements

Understanding Columns, Rows, and Cells

Navigating In and Around Worksheets

VIDEO: Introduction to Excel

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

VIDEO: Introduction to Spreadsheets

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

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

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

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