This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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)
Introduction and Unit Objectives
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock