Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel Master Class: Beginner to Professional
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! (0:24)
Getting Started: How To Use This Course To Gain The Maximum For Our Teachings! (0:57)
Excel 2016 - INTRO (4:33)
ALL RESOURCE FILES FOR THIS COURSE
Section 2: - Worksheet Basics
S2L1 - Excel 2016 Parts of the Screen (5:48)
S2L2 - Excel 2016 Using the Worksheet (6:53)
S2L3 - Ecxel 2016 Navigating Worksheets (4:40)
S2L4 - Excel 2016 Multiple Worksheets (6:46)
S2L5 - Excel 2016 The Ribbon (7:21)
S2L6 - Excel 2016 Saving and Opening Files (6:30)
S2L1OLD - Excel 2016 Parts of the Screen (6:31)
Section 3: Manipulating Columns and Rows
S3L1 - Excel 2016 Resizing Columns and Rows (7:28)
S3L2 - Excel 2016 Insert and Delete Columns and Rows (6:19)
Section 4: Entering Data
S4L1 - Excel 2016 Entering Text (6:33)
S4L2 - Excel 2016 Editing Data (5:24)
S4L3 - Excel 2016 Undo Changes (2:36)
S4L4 - Excel 2016 Excel Data Entry Helps (4:01)
S4L5 - Excel 2016 Entering Numbers (5:15)
S4L6 - Excel 2016 Entering Dates (5:08)
S4L7 - Excel 2016 Entering Symbols (4:57)
S4L1OLD (7:03)
Section 5: Selecting Cells and Ranges
S5L1 - Excel 2016 Selecting With Mouse (2:48)
S5L2 - Excel 2016 Selecting With Keyboard (4:34)
S5L3 - Excel 2016 The Extend Key (3:00)
Section 6: Formulas
S6L1 - Excel 2016 Basic Formulas (7:30)
S6L2 - Excel 2016 Rule of Order (2:42)
S6L3 - Excel 2016 Formulas on Dates (3:50)
S6L4 - Excel 2016 Formulas with Text (4:55)
S6L5 - Excel 2016 Multi Sheet Formulas (3:31)
Section 7: Copying and Moving
S7L1 - Excel 2016 Copying Cells or Ranges (5:44)
S7L2 - Excel 2016 Move Cells or Ranges (3:08)
S7L3 - Excel 2016 Copy Move Columns or Rows (4:35)
S7L4 - Excel 2016 Copying Formulas (7:59)
S7L5 - Excel 2016 Using the Clipboard Pane (4:14)
S7L6 - Excel 2016 Move or Copy Sheets (4:30)
Section 8: The Fill Handle
S8L1 - Excel 2016 Fill Handle Basics (4:46)
S8L2 - Excel 2016 Fill Series (5:03)
S8L3 - Excel 2016 Custom Fill Lists (4:30)
Section 9: Naming Ranges
S9L1 - Excel 2016 Overview of Naming Ranges (3:36)
S9L2 - Excel 2016 Multi Sheet Range Names (6:40)
S9L3 - Excel 2016 Using Rang Names Like Bookmarks (2:43)
Section 10: Functions
S10L1 - Excel 2016 SUM Function (7:22)
S10L2 - Excel 2016 Quick Analysis (5:09)
S10L3 - Excel 2016 The If Function (10:27)
S10L4 - Excel 2016 If Multiple Criteria (3:00)
S10L5 - Excel 2016 Vlookup1 (7:19)
S10L6 - Excel 2016 Vlookup2 (2:22)
S10L7 - Excel 2016 Data Validation (6:34)
S10L8 - Excel 2016 Multiple VLookups (4:56)
S10L9 - Excel 2016 More Functions (7:27)
S10L10 - Excel 2016 Proper Round and Other Functions (5:36)
Section 11: Formatting Worksheet Contents
S11L1 - Excel 2016 Basic Formatting (5:19)
S11L2 - Background Fill Patterns and Effects (4:30)
S11L3 - Excel 2016 Aligning Cell Contents (5:38)
S11L4 - Excel 2016 Borders (2:40)
S11L5 - Excel 2016 Formatting Numbers (3:37)
S11L6 - Excel 2016 Custom Number Formats (5:00)
S11L7 - Excel 2016 Custom Number Format Exercise (6:18)
S11L8 - Excel 2016 Date Formats (4:27)
S11L9 - Excel 2016 Time Formats (4:15)
S11L10 - Excel 2016 Conditional Formatting 1 (4:46)
S11L11 - Excel 2016 Conditional Formatting 2 (6:22)
Section 12: Table Filters and Keyboard Shortcuts
S12L1 - Excel 2016 Format Table and Filters (6:20)
S12L2 - Excel 2016 Data Slicers (4:09)
Section 13: Bringing it All Together Print Exercise
S13L1 - Excel 2016 Start and Finish (6:04)
S13L2 - Excel 2016 Format and Quick Analysis (4:44)
S13L3 - Excel 2016 Print Area and Titles (4:40)
S13L4 - Excel 2016 6 Month Totals (3:46)
S13L5 - Excel 2016 Modify Print Titles Header Footer (6:16)
S13L6 - Excel 2016 Final Adjustments (2:31)
S13L3 - Excel 2016 Print Area and TitlesOLD (5:13)
Section 14: Payment Function and What If Analysis
S14L1 - Excel 2016 Using the PMT Function (3:14)
S14L2 - Excel 2016 Using Goal Seek (3:32)
S14L3 - Excel 2016 Using Scenario Manager (5:35)
S14L4 - Excel 2016 Using Data Table (5:01)
Section 15: Finding and Fixing Errors
S15L1 - Excel 2016 Using Error Checking (6:00)
S15L2 - Excel 2016 Fixing Circular References (2:02)
S15L3 - Excel 2016 Tracing Precedents and Dependents (2:53)
S15L4 - Excel 2016 Evaluate Formulas (4:47)
Section 16: More on Working With Tables
S16L1 - Excel 2016 Sorting Tables (3:28)
S16L2 - Excel 2016 Creating Subtotals (5:59)
S16L3 - Excel 2016 Adding Records to a Table (4:54)
S16L4 - Excel 2016 Using a Form for Data Entry (5:13)
S16L5 - Excel 2016 Removing Duplicates (4:17)
Section 17: Protecting Your Work
S17L1 - Excel 2016 Protect Sheet (4:44)
S17L2 - Excel 2016 Highlight Unlocked Cells (2:45)
S17L3 - Excel 2016 Allow Commands (3:42)
S17L4 - Excel 2016 Protect Workbook Structure (1:59)
S17L5 - Excel 2016 Share and Mark as Final (3:56)
S17L6 - Excel 2016 Protect Workbook (2:17)
Section 18: Pivot Tables
S18L1 - Excel 2016 Create a Pivot Table (4:45)
S18L2 - Excel 2016 Multiple Rows and Columns (3:45)
S18L3 - Excel 2016 Printing Pivot Tables (3:34)
S18L4 - Excel 2016 Change Display Totals (6:17)
S18L5 - Excel 2016 Pivot Table Filters (4:17)
S18L6 - Excel 2016 Filtering Pivot Tables with Timelines (3:52)
S18L7 - Excel 2016 Changing Pivot Table Appearance (5:40)
S18L8 - Excel 2016 Recommended Pivot Tables (4:22)
Section 19: Viewing Large Worksheets and Multiple Workbooks
S19L1 - Excel 2016 Freezing Panes and Split (4:05)
S19L2 - Excel 2016 Using the Watch Window (2:01)
S19L3 - Excel 2016 Viewing Multiple Workbooks (6:40)
Section 20: Working with Charts
S20L1 - Excel 2016 Prep Data and Make Chart (5:55)
S20L2 - Excel 2016 Formatting Chart 1 (5:54)
S20L3 - Excel 2016 Formatting Chart 2 (8:01)
S20L4 - Excel 2016 Sunburst and Treemap (5:14)
S11L10 - Excel 2016 Conditional Formatting 1
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock