GILL B. DREHER

EXCEL 2025

The Must-Have Guide to Master Microsoft Excel | From Beginner to Pro in less than 7 Days | Step-by-step Formulas and Functions with Tutorials and Illustrations

 

SCROLL BELOW

EXCEL VIDEO COURSE

BEGINNER
  • Beginner’s Introduction to Excel
  • [19:44]
  • Basic Formatting Techniques
  • [08:07]
  • Math & Statistical Functions (e.g. SUM, AVERAGE)
  • [08:06]
  • Date & Time Functions (e.g. TODAY, MONTH)
  • [13:25]
  • Text Functions (e.g. LEN, CONCATENATE)
  • [14:34]
INTERMEDIATE
  • Logical Functions (e.g. IF, AND)
  • [14:56]
  • Lookup & Reference Functions (e.g. VLOOKUP, MATCH)
  • [14:04]
  • Absolute and Relative Cell Referencing (i.e. the $ sign)
  • [07:44]
  • Naming Ranges and Cells
  • [09:58]
  • Data Validation with In-Cell Drop-Down List
  • [08:54]
  • Conditional Formatting
  • [09:11]
  • Introduction to Pivot Tables
  • [06:57]
  • Advanced Pivot Tables: Round 1
  • [08:18]
  • Advanced Pivot Tables: Round 2
  • [11:19]
  • Auto-Filter and Advanced Data Filtering
  • [06:34]
  • Creating and Designing Charts (including Sparklines)
  • [14:48]
  • Error Checking and Data Monitoring
  • [16:52]
ADVANCED
  • Information Functions (e.g. CELL, ISNUMBER)
  • [09:44]
  • Formula Auditing & Formula Evaluation
  • [07:28]
  • Advanced VLOOKUP Examples
  • [14:36]
  • Advanced INDEX & MATCH Lookup Examples
  • [09:40]
  • Five Powerful Excel Tips
  • [15:19]
  • Introduction to Macros & VBA programming
  • [13:08]
  • VBA Macro Walkthrough #1: Purchase Order Generator
  • [17:28]
  • VBA Macro Walkthrough #2: Message Encoder & Decoder
  • [16:51]
NextContactNext