Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Microsoft Excel: from ZERO to ADVANCED
Section I: Getting Started with Excel
Chapter 1: Introducing Excel (4:16)
Chapter 2: Entering and Editing Worksheet Data (9:28)
Chapter 3: Performing Basic Worksheet Operations (8:10)
Chapter 4: Working with Excel Ranges and Tables (4:08)
Chapter 5: Formatting Worksheets (11:34)
Chapter 6: Understanding Excel Files and Templates (3:37)
Chapter 7: Printing Your Work (7:13)
Chapter 8: Customizing the Excel User Interface (1:47)
Section summary
Section II: Working with Formulas and Functions
Chapter 9: Introducing Formulas and Functions (5:26)
Chapter 10: Using Formulas for Common Mathematical Operations (7:41)
Chapter 11: Using Formulas to Manipulate Text (10:13)
Chapter 12: Using Formulas with Dates and Times (6:33)
Chapter 13: Using Formulas for Conditional Analysis (16:58)
Chapter 14: Using Formulas for Matching and Lookups (12:14)
Chapter 15: Using Formulas for Financial Analysis (11:56)
Chapter 16: Using Formulas for Statistical Analysis (11:44)
Chapter 17: Understanding and Using Array Formulas (7:47)
Chapter 18: Making your Formulas Error-Free (8:41)
Section III: Creating Charts and Other Visualizations
Chapter 19: Getting Started with Excel Charts (15:27)
Chapter 20: Using Advanced Charting Techniques (36:46)
Chapter 21: Creating Sparkline Graphics (5:50)
Chapter 22: Visualizing with Customer Number Formats and Shapes (20:02)
Chapter 23: Implementing Excel Dashboarding Best Practices (31:33)
Section IV: Managing and Analyzing Data
Chapter 24: Importing and Cleaning Data (10:08)
Chapter 25: Using Data Validation (9:47)
Chapter 26: Worksheet Outlines (3:47)
Chapter 27: Linking and Consolidating (5:55)
Chapter 28: PivotTables (16:38)
Chapter 29: What-If Analysis (15:11)
Chapter 30: Goal Seek and Solver (15:10)
Chapter 31: ToolPak (6:22)
Chapter 32: Protecting Data (3:56)
Section V: Understanding PowerPivot and PowerQuery
Chapter 33: Introducing Power Pivot (3:42)
Chapter 34: Data Model (7:57)
Chapter 35: Adding Formulas to Power Pivot (12:42)
Chapter 36: Power Query (10:52)
Section VI: Automating Excel
Chapter 37: VBA (14:45)
Chapter 38: User Defined Functions (6:32)
Chapter 39: UserForm (6:12)
Chapter 40: UserForm Example (12:19)
Chapter 41: Excel Events (4:15)
Chapter 42: Add in (6:49)
Chapter 14: Using Formulas for Matching and Lookups
Download
Chapter 14.xlsx
Complete and Continue
Lesson Content Locked
Your session expired. Please sign in again to continue.
Log In