Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel Like a Boss - 727 and 728 Certification Prep
For Complete Beginners (plus course resources)
Excel LAB - Intro and Goals (2:33)
The Excel Interface (5:30)
Create and Manage Workbooks (9:24)
Data Entry Essentials (6:25)
Shortcut Guide and Other Course Resources
Part One. Learn Excel Basics (and prep for the 77-727 exam)
Navigate Worksheets and Workbooks (8:24)
Manage Columns, Rows, Sheets (4:44)
Change Sheet Order, Headers and Footers (4:42)
Hide and Unhide Columns, Rows, Sheets (6:04)
Change Views, Zoom, Properties (6:15)
Print Area, Repeating rows (5:04)
Inspect a Workbook (5:50)
Insert Data in Cells and Ranges (6:49)
Format Cells and Ranges (7:51)
Sparklines and Subtotals (6:45)
Conditional Formatting (7:04)
Create and Manage Tables (7:40)
Filter and Sort a Table (5:52)
Analyze Data with Formulas and Functions (6:41)
IF, SUMIF, AVERAGEIF (6:33)
UPPER, CONCAT, RIGHT (6:26)
Create a Chart (6:27)
Format Charts (6:18)
Insert and Format Objects (4:28)
The 727 Practice Exam
727 Practice Excerise (1:09)
727 Solution Walkthrough (14:47)
Part Two. Start with Data Analysis (and prep for the 77-728 exam)
Using Templates and Macros (8:49)
Use a Structured Reference (7:38)
Manage Workbook Review (6:19)
Custom Formatting, Currency, Dates (7:28)
Advanced Autofill (4:09)
Advanced Conditional Formatting (7:38)
Custom Themes and Styles (5:26)
Macro and Form Control (7:23)
Data Validation (5:36)
IF, AND, OR, NOT (9:10)
AVERAGEIFS, SUMIFS, COUNTIFS (5:37)
HLOOKUP and VLOOKUP (7:00)
MATCH and INDEX (9:01)
NOW, TODAY, TEXT (5:55)
What If Analysis (8:21)
Troubleshoot Formulas (10:32)
Manage Named Ranges (7:10)
Add Trendline and Secondary Axis (7:09)
Create Pivot Tables (6:12)
GETPIVOTDATA (5:09)
Drill Down with PivotCharts (4:45)
Change Sheet Order, Headers and Footers
Complete and Continue