Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel 2016 Master Class: Beginner to Advanced
Section 1: Welcome To Our Microsoft Excel 2016 Master Class Course: Beginner To Advanced
Welcome To Our Course! Learn All of The Benefits Using Microsoft Excel Today! (1:42)
Getting Started: How To Use This Course To Gain The Maximum For Our Teachings! (3:32)
Bruce's Introduction (4:33)
Section 2: Worksheet Basics
The Parts of the Excel Screen (5:48)
The Worksheet - What Is It? (6:53)
Navigating Worksheets with Ctrl+Arrow Keys (4:40)
Multiple Worksheets (6:46)
The Ribbon - How Does It Work? (7:21)
Saving and Opening Files (6:30)
Quiz 1: Worksheet Basics Quiz
Section 3: Manipulating Columns and Rows
Resizing Columns and Rows (7:28)
Inserting, Deleting, Hiding and Unhiding Columns and Rows (6:20)
Quiz 2: Columns and Rows Quiz
Section 4: Entering Data
Entering Text (6:33)
Editing Data (5:25)
Undoing Changes (2:36)
Excel Data Entry Helps (4:01)
Entering Numbers (5:15)
Entering Dates (5:08)
Entering Symbols (4:57)
Quiz 3: Entering and Editing Data Quiz
Section 5: Selecting Cells and Ranges
Basic Selecting With The Mouse (2:48)
Basic Selecting With The Keyboard (4:34)
The Extend Key (3:01)
Quiz 4: Selecting Cells and Ranges Quiz
Section 6: Formulas
Basic Formulas (7:31)
Rule of Order (2:42)
Formulas on Dates (3:50)
Formulas with Text (4:55)
Multi-Sheet Formulas (3:31)
Quiz 5: Formulas Quiz
Section 7: Copying and Moving
Copy Cells or Ranges (5:45)
Move Cells or Ranges (3:08)
Copy or Move Columns and Rows (4:35)
Copying Formulas and Absolute References (7:59)
Using the Clipboard Task Panel (4:14)
Move or Copy Sheets (4:30)
Quiz 6: Copying and Moving Quiz
Section 8: The Fill Handle
Fill Handle Basics (4:46)
How to Use Fill Series (5:03)
Custom Fill Series (4:31)
Quiz 7: The Fill Handle Quiz
Section 9: Naming Ranges
Overview of Naming Ranges (3:37)
Multi Sheet Range Names (6:41)
Using Range Names Like Bookmarks (2:43)
Quiz 8: Naming Ranges Quiz
Section 10: Functions
SUM - The Most Popular Function (7:22)
Intro to the Quick Analysis Tool (5:09)
The IF Function (10:27)
Multiple Criteria in an If Statement (3:00)
VLookup 1 - Simple Example (7:20)
VLookup 2 - Match Within a Range (2:22)
Vlookup 3 - Intro to Data Validation Lists (6:34)
Vlookup 4 - Multiple VLookups Using the Validation List (4:56)
More Functions (7:27)
Proper, Round and Other Functions (5:36)
Quiz 9: Functions Quiz
Section 11: Formatting Worksheet Contents
Basic Formatting (5:19)
Background Fill, Patterns and Effects (4:30)
Aligning of Cell Contents (5:39)
Borders (2:40)
Formatting Numbers (3:37)
Custom Number Formats (5:00)
Custom Number Format Exercise (6:18)
Date Formats (4:28)
Time Formats (4:15)
Conditional Formatting 1 (4:46)
Conditional Formatting 2 (6:22)
Quiz 10: Formatting Quiz
Section 12: Table Filters and KEYBOARD SHORTCUTS
Format a Table and Use Filters (6:20)
Using Data Slicers (4:09)
Quiz 11: Table Filters Quiz
Section 13: Bringing It All Together PRINT Exercise
Looking at the Task and Getting Started (6:04)
Use Quick Analysis and Angle Alignment on Titles (4:44)
S13L3 - Excel 2016 Print Area and Titles (4:40)
S13L3 - Excel 2016 Print Area and TitlesOLD (5:13)
Create 6 Month Totals and Adjust Column Widths (3:47)
Modify Print Titles and add Header and Footer (6:16)
Final Adjustments and Print Preview (2:31)
Quiz 12
Section 14: Payment Function and What If Analysis
Using the PMT Function (3:14)
Using GOAL SEEK (3:32)
Using SCENARIO MANAGER (5:35)
Using 1 and 2 Variable Data Tables (5:01)
Quiz 13
Section 15: Finding and Fixing Errors
Using Error Checking (6:00)
Fixing Circular References (2:02)
Tracing Formula Precedents and Dependents (2:53)
Evaluate Formulas (4:48)
Quiz 14
Section 16: More on Working With Tables
Sorting Tables (3:28)
Creating Subtotals (5:59)
Adding Records to a Table (4:54)
Using a Form for Data Entry (5:14)
Removing Duplicate Records from a Table (4:17)
Quiz 15
Section 17: Protecting Your Work
Protect the Worksheet (4:44)
Highlight Unlocked Cells (2:45)
Allowing Specific Commands on a Protected Sheet (3:42)
Protect Workbook Structure (1:59)
Protect Workbook - Mark as Final (3:56)
Protect Workbook - Encrypt with Password (2:17)
Quiz 16
Section 18: Pivot Tables
Create a Pivot Table (4:45)
Multiple Pivot Rows and Columns (3:46)
Displaying and Printing Pivot Tables (3:34)
Change Display of Totals (6:17)
Pivot Table Filters (4:17)
Filtering Pivot Tables with Timelines (3:52)
Changing Pivot Table Appearance (5:40)
Recommended Pivot Tables (4:22)
Quiz 17
Section 19: Viewing Large Worksheets and Multiple Workbooks
Freezing Panes and Split (4:05)
Using the Watch Window (2:01)
Viewing Multiple Workbooks (6:40)
Quiz 18
Section 20: Working With Charts
Prepping Data and Creating a Chart (5:55)
Formatting and Modifying Charts 1 (5:54)
Formatting and Modifying Charts 2 (8:01)
Using Get & Transform to Create Sunburst and Treemap Charts (5:14)
Quiz 19
VLookup 2 - Match Within a Range
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock