Microsoft Excel Course Beginning/Intermediate

Course Introduction

Instructor:  Francie Black

Welcome to Microsoft Excel class!  Excel is a powerful tool for home or business.  This course will give you a solid foundation in Excel and take you beyond the basics.

This course is made up of 11 lectures which run anywhere from 6 minutes to 68 minutes.  Each of the 11 lectures are made up of a series of  2 – 15 video lessons that walk you through the series step-by-step.  The lessons ranges in time from 1 min to 11 mins.   The lecture and  lessons systematically walks you through beginning Excel topics and introduces you to several Intermediate level topics.

You can choose to follow along step-by-step if desired by pausing the video at any given moment or between lessons. Feel free to skip any topic with which you may already be familiar. The link at the end of the final video provides a link to the course certificate form which we can email you in pdf format for you to print.

Course Index (click to collapse)

Quick Access Links to Lectures:

  • Lecture 1 – Introduction & Excel Fundamentals (55 secs)
    • Course Certificate (55 sec)
  • Lecture 2 – Excel Fundamentals (18:34 mins)
    • Launching Excel for Mac 2011 (1:03 mins)
    • Adding Excel Icon to your Dock (1:41 mins)
    • Overview of the Excel Program Screen (5:00 mins)
    • Contextual Tabs (2:17 mins)
    • Navigating a Worksheet & Keyboard Tips (3:54 mins)
    • A Bit of Excel Terminology: Workbook vs Worksheet vs Spreadsheet vs File (2:00 mins)
    • Create, Open, & Close a Workbook (2:39 mins)
  • Lecture 3 – Getting Started with Worksheets (23:59 mins)
    • Entering & Editing Labels and Values (5:20 mins)
    • Entering Data Automatically – Tip (4:01 mins)
    • Saving Your Workbook, Save vs Save as… (5:18 mins)
    • Selecting a Cell Range and Entering Data – Tip (3:03 mins)
    • Entering Data in a Cell Range – Tip 2 (1:38 mins)
    • Entering Data: Labels vs Values (convert a number to text) (1:53 mins)
    • Entering and Formatting Dates (2:46 mins)
  • Lecture 4 – Getting Started with Formulas & Functions (30:48 mins)
    • Functions & Formulas Introduction. Sum Function. (4:13 mins)
    • Sum Function. Editing the Formula (3:11 mins)
    • Sum Function. Copying the Formula (4:08 mins)
    • Math Operators: Additions, Subtraction, Multiplication, Division (4:35 mins)
    • Formulas: Absolute vs. Relative Reference (8:12 mins)
    • Formula Ribbon (2:06 mins)
    • Formulas: Average, Min, Max (4:23 mins)
  • Lecture 5 – Editing a Worksheet (9:50 mins)
    • Moving and Copying Cell Contents (4:36 mins)
    • Copying Cell Contents to a New Sheet (3:33 mins)
    • Paste Menu Options (1:41 mins)
  • Lecture 6 – Formatting a Worksheet (68:52 mins)
    • Formatting Options (4:38 mins)
    • Format and Merge Cells (4:51 mins)
    • Why Format Options and Ribbons are Different (58 secs)
    • Number Formatting Overview (5:57 mins)
    • Number Formatting: Currency (4:35 mins)
    • Clear Formatting vs Clear Contents (3:20 mins)
    • Adjusting Column Widths (6:10 mins)
    • Adjusting Row Height (3:42 mins)
    • Alignment: Top, Bottom, Wrap Text (5:27 mins)
    • Insert Rows (5:07 mins)
    • Delete Rows (2:38 mins)
    • Inserting and Deleting Columns (4:41 mins)
    • Adding Cell Borders (5:19 mins)
    • Copy Formatting using Format Painter (2:17 mins)
    • Print & Print Preview (9:12 mins)
  • Lecture 7 – Working with Charts (28:45 mins)
    • Creating Charts (11:02)
    • Printing Charts (2:36 mins)
    • Updating Data in Charts (1:11 mins)
    • Copying and Moving Charts (5:20 mins)
    • Copying Charts (5:20 mins)
    • Adding A Chart Series (3:16 mins)
  • Lecture 8 – Sorting Data (17:07 mins)
    • Download PB Travel Sales Report Training.xlsx File (8 secs)
    • Sorting Your Data (3:58 mins)
    • Sorting a Selected Range vs Automated Sorting (3:56 mins)
    • Sorting Outside of a Range (1:41 mins)
    • Sorting a Selected Range (4:15 mins)
    • Sort by Multiple Criteria (3:17 mins)
  • Lecture 9 – Filtering Data (9:08 mins)
    • Filtering Data (3:53 mins)
    • Filtering by Number (5:15 mins)
  • Lecture 10 – Introduction to Tables (6:13 mins)
    • Introduction To Tables (Tables vs Filtering) (3:58 mins)
    • Table Features (2:15 mins)
  • Lecture 11 – Working with Multiple Worksheets (9:17 mins)
    • Creating, Copying, and Naming Worksheets (3:22 mins)
    • Moving and Navigating Between Worksheets (2:17 mins)
    • Deleting Worksheets and Changing Tab Color (1:22 mins)
    • Printing Multiple Worksheets (2:16 mins)
  • Lecture 12 – Working with Images (6:12 mins)
    • Inserting and Formatting Images (6:12 mins)
  • Lecture 13 – Course Certificate (45 secs)
    • Course Certificate & Feedback (45 secs)

Course Lectures

Welcome to Class! Click each lecture title to expand and collapse each section to hide or reveal each lesson.  Feel free to skip over any topic in which you are familiar or do not need for work.  We look forward to having you in class!

Lecture 1 & 2 (Lessons 1-8): Course Introduction & Excel Fundamentals (20:33)

Lesson 1:

Course Certificate

55 Secs

Lesson 2:

Launching Excel for Mac

1:03 mins

Lesson 3:

Adding Excel Icon to Your Doc

1:41 mins

Lesson 4:

Overview of Excel Program Screen

5:00 mins

Lesson 5:

Contextual Tabs

2:17 mins

Lesson 6:

Navigating a Worksheet & Keyboard Tips

3:54 mins

Lesson 7:

A Bit of Excel Terminology: Workbook vs Worksheet vs Spreadsheet vs File

2:00 mins

Lesson 8:

Create, Open & Close a Workbook

2:39 mins

Lecture 3 (Lessons 9 - 15): Getting Started with Worsheets (23:59)

Lesson 9:

Entering & Editing Labels and Values

5:20 Mins

Lesson 10:

Entering Data Automatically – Tip

4:01 Mins

Lesson 11:

Saving Your Workbook, Save vs Save as…

5:18 Mins

Lesson 12:

Selecting a Cell Range and Entering Data – Tip

3:03 Mins

Lesson 13:

Entering Data in a Cell Range – Tip 2

1:38 Mins

Lesson 14:

Entering Data: Labels vs Values (convert a number to text)

1:53 Mins

Lesson 15:

Entering and Formatting Dates

2:46 Mins

Lecture 4 (Lessons 16 - 22): Getting Started with Formulas & Functions (30:48)

Lesson 16:

Functions & Formulas Introduction. Sum Function.

4:13 Mins

Lesson 17:

Sum Function. Editing the Formula.

3:11 Mins

Lesson 18:

Sum Function. Copying the Formula.

4:08 Mins

Lesson 19:

Math Operators: Additions, Subtraction, Multiplication, Division

4:35 Mins

Lesson 20:

Formulas: Absolute vs. Relative Reference

8:12 Mins

Lesson 21:

Formula Ribbon

2:06 Mins

Lesson 22:

Formulas: Average, Min, Max

4:23 Mins

Lecture 5 (Lessons 23 - 25): Editing a Worksheet (9:50)

Lesson 23:

Moving and Copying Cell Contents

4:36 Mins

Lesson 24:

Copying Cell Contents to a New Sheet

3:33 Mins

Lesson 25:

Paste Menu Options

1:41 Mins

Lecture 6 (Lessons 26 - 40): Formatting a Worksheet (68:52)

Lesson 26:

Formatting Options

4:38 Mins

Lesson 27:

Format and Merge Cells

4:51 Mins

Lesson 28:

Why Format Options on Ribbon are Different

58 Secs

Lesson 29:

Number Formatting Overview

5:57 Mins

Lesson 30:

Number Formatting: Currency

4:35 Mins

Lesson 31:

Clear Formatting vs Clear Contents

3:20 Mins

Lesson 32:

Adjusting Column Widths

6:10 Mins

Lesson 33:

Adjusting Row Height

3:42 Mins

Lesson 34:

Alignment: Top, Bottom, Wrap Text

5:27 Mins

Lesson 35:

Insert Rows

5:07 Mins

Lesson 36:

Delete Rows

2:38 Mins

Lesson 37:

Inserting and Deleting Columns

4:41 Mins

Lesson 38:

Adding Cell Borders

5:19 Mins

Lesson 39:

Copy Formatting using Format Painter

2:17 Mins

Lesson 40:

Print & Print Preview

9:12 Mins

Lecture 7 (Lessons 41 - 46): Working with Charts (28:45)

Lesson 41:

Creating Charts

11:02 Mins

Lesson 42:

Printing Charts

2:36 Mins

Lesson 43:

Updating Data in Charts

1:11 Mins

Lesson 44:

Copying and Moving Charts

5:20 Mins

Lesson 45:

Copying Charts

5:20 Mins

Lesson 46:

Adding A Chart Series

3:16 Mins

Lecture 8 (Lessons 47 - 52): Sorting Data (17:07)

Lesson 47:

Download PB Travel Sales Report Training.xlsx File

8 Secs

Lesson 48:

Sorting Your Data

3:58 Mins

Lesson 49:

Sorting a Selected Range vs Automated Sorting

3:56 Mins

Lesson 50:

Sorting Outside of a Range

1:41 Mins

Lesson 51:

Sorting a selected Range

4:15 Mins

Lesson 52:

Sort by Multiple Criteria

3:17 Mins

Lecture 9 (Lessons 53 - 54): Filtering Data (9:08)

Lesson 53:

Filtering Data

3:53 Mins

Lesson 54:

Filter by Number

5:15 Mins

Lecture 10 (Lessons 55 - 56): Lecture Title (6:13)

Lesson 55:

Introduction To Tables (Tables vs Filtering)

3:58 Mins

Lesson 56:

Table Features

2:15 Mins

Lecture 11 (Lessons 57 - 60): Working with Multiple Worksheets (9:17)

Lesson 57:

Creating, Copying and Naming Worksheets

3:22 Mins

Lesson 58:

Moving and Navigating between Worksheets

2:17 Mins

Lesson 59:

Deleting Worksheets and Changing Tab Color

1:22 Mins

Lesson 60:

Printing Multiple Worksheets

2:16 Mins

Lecture 12 & 13 (Lessons 61 - 62): Working with Images & Course Certificate (6:57)

Lesson 61:

Inserting and Formatting Images

6:12 Mins

Lesson 62:

Course Certificate & Feedback

45 Secs