K
Kingwest
Administrative Training Program
Admin Dashboard
Curriculum · 25 Courses
Excel for Administrative Staff
Beginner to advanced. Each course runs 15–20 minutes.
Works in Google Sheets too →
Foundation
Courses 1–5 · For absolute beginners
COURSE 01
Getting Around Excel
Not Started
~17 minutes
COURSE 02
Entering and Editing Data
Not Started
~18 minutes
COURSE 03
Basic Formatting
Not Started
~16 minutes
COURSE 04
Managing Worksheets and Files
Not Started
~16 minutes
COURSE 05
Your First Formulas
Not Started
~18 minutes
Intermediate
Courses 6–15 · Building real spreadsheet skills
COURSE 06
Cell References That Move (and Don't)
Not Started
~17 minutes
COURSE 07
Logical Functions (IF, AND, OR, IFERROR)
Not Started
~18 minutes
COURSE 08
Conditional Math (COUNTIF, SUMIF)
Not Started
~17 minutes
COURSE 09
Working with Text
Not Started
~17 minutes
COURSE 10
Working with Dates and Times
Not Started
~17 minutes
COURSE 11
Sorting and Filtering
Not Started
~16 minutes
COURSE 12
Excel Tables
Not Started
~17 minutes
COURSE 13
Charts and Visuals
Not Started
~17 minutes
COURSE 14
Conditional Formatting
Not Started
~16 minutes
COURSE 15
Data Validation
Not Started
~16 minutes
Advanced
Courses 16–25 · Lookups, PivotTables, Power Query, Dashboards
COURSE 16
Lookup Functions (VLOOKUP, HLOOKUP)
Not Started
~18 minutes
COURSE 17
Modern Lookups (XLOOKUP, INDEX/MATCH)
Not Started
~18 minutes
COURSE 18
PivotTables: The Basics
Not Started
~19 minutes
COURSE 19
PivotTables: Going Further
Not Started
~18 minutes
COURSE 20
Power Query (Import and Clean)
Not Started
~19 minutes
COURSE 21
Advanced Formulas (IFS, SWITCH, LET, Dynamic Arrays)
Not Started
~19 minutes
COURSE 22
What-If Analysis (Goal Seek, Scenarios, Solver)
Not Started
~17 minutes
COURSE 23
Macros and Intro to VBA
Not Started
~18 minutes
COURSE 24
Building a Dashboard
Not Started
~20 minutes
COURSE 25
Protection, Sharing, and Collaboration
Not Started
~17 minutes