They Stole What Lab | Mr. Ford's Class

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Microsoft Excel - From Beginner to Certified Professional

Unit 01 Welcome To Excel

Introduction and Unit Objectives (1:21)
Welcome To The New Excel (6:50)
The Excel Interface (4:00)
The Excel Menu System (7:33)
The Quick Access Toolbar (3:34)
Files, Workbooks, and Worksheets (1:39)
Feedback on the Microsoft Office Specialists (MOS) Exam 77-727: Excel 2016

Unit 02 Create and Manage Worksheets and Workbooks

Introduction and Unit Objectives (1:09)
Creating, Saving, and Opening a Workbook (9:25)
Workbook Properties (7:06)
Creating Worksheets (2:41)
Moving, Hiding, and Deleting Worksheets (7:45)
Formatting Worksheets (9:52)
Adding, Removing, Hiding and Unhiding Rows and Columns (8:19)
Changing Your Views (10:17)

Unit 03 Create Cells and Ranges

Introduction and Unit Objectives (0:42)
Data Entry (12:53)
Cut, Copy, Paste, and Move (6:00)
Merging Cells (3:11)
Fonts (6:12)
Format Cells (7:57)
Find, Select, & Lookup (5:28)

Unit 04 Formulas and Functions

Introduction and Unit Objectives (0:36)
Naming Cells and Ranges (4:50)
Cell References (8:29)
Simple Formulas (5:15)
Introduction To Functions (3:31)
Basic Functions (3:19)
Using Functions To Format (8:23)

Unit 05 Conditional Formulas

Introduction and Unit Objectives (3:35)
IF (3:34)
Shipping Lab (9:04)
Nesting IFs (2:29)
SUMIF (2:48)
They Stole What Lab (7:03)
AVERAGEIF (3:29)
COUNTIF (4:06)

Unit 06 Your Best Table Please

Introduction and Unit Objectives (1:09)
Making Tables (5:12)
Adding and Removing Columns and Rows (2:18)
Table Styles and Options (3:09)
The Total Row (3:08)
Filter and Sort A Table (6:41)
Remove Duplicates (2:29)

Unit 07 Charts and Art

Introduction and Unit Objectives (1:32)
Create A New Chart (3:54)
Tweaking Your Chart (3:13)
Resizing and Moving Your Chart (2:11)
Change Chart Titles (3:24)
Elements, Layouts, and Styles (3:58)
Insert and Format Objects (5:49)

Unit 08 Summarize and Organize Data

Introduction and Unit Objectives (1:32)
Creating and Formatting Sparkline (5:57)
Outlining and Grouping Data (4:04)
Using Subtotals (4:26)
Conditional Formatting Revisited (8:06)

Unit 09 Printing

Introduction and Unit Objectives (1:08)
Page Setup Revisited (2:15)
Configuring a Print Area (1:50)
Give Me A Page Break (3:37)
Print Scaling (4:04)
Repeating Rows and Columns, Repeating Rows and Columns, Repeating ..... (2:43)
Mastering Excel's Headers and Footers (2:06)
Printing It All Out, or Just a Page (4:10)
Thank You and Good Bye (1:42)

Teach online with

They Stole What Lab

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock