Excel & Office Productivity
excel Essentials
A practical, beginner-friendly introduction to spreadsheet fundamentals, covering data entry, formatting, core formulas,...
4 Weeks Beginner Certificate
Self-paced
Beginner
Excel Advanced Formulas & Functions
An advanced, formula-driven course mastering modern dynamic arrays, financial and statistical functions, nested computational logic, and error-proof spreadsheet architecture in Microsoft Excel.
4 Weeks Verified certificate
What you'll learn
- Dynamic Array Engine: Master modern spill array functions (FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, RANDARRAY) to build fully dynamic calculation models.
- Matrix & Array Manipulation: Leverage dynamic functions like LET, LAMBDA, MAP, REDUCE, and BYROW to create scalable custom functions without VBA code.
- Advanced Lookup & Retrieval: Execute advanced structural calculations using nested INDEX/MATCH, multi-criteria XLOOKUP, and dynamic structural references.
- Complex Logical & Conditional Calculations: Build flexible business rules using complex conditional logic (SUMIFS, COUNTIFS, AVERAGEIFS) combined with boolean array operations.
- Error Prevention & Optimization: Diagnose complex formula dependencies, build graceful error handling using IFERROR/ISNA, and optimize dynamic models for high-speed calculation.
Course content
The full curriculum is being finalised. Contact us for the syllabus.
About this course
Take your financial modeling, reporting, and data processing capabilities to the highest level without relying on code. This course focuses on complex formula construction and the revolution of Dynamic Array formulas introduced in modern Excel. You will learn how to write scalable, multi-layered formulas that auto-spill, handle complex arrays, transform matrices, and run advanced statistical or financial analysis. Additionally, you will master advanced computational logic, array manipulation, custom formula creation with LAMBDA, and performance optimization techniques for massive workbooks.
Tools you'll use
Microsoft Excel (365 / 2021+)Office 365 Dynamic Array EngineExcel Online
Learn anywhere
Phone, tablet or laptop. Pick up exactly where you left off.
Hands-on practice
Quizzes, coding exercises and projects marked by instructors.
Verified certificate
Each certificate has a code employers can verify online.
You might also like
Excel & Office Productivity
Excel Intermediate
A practical course designed to elevate spreadsheet skills by mastering advanced lookup functions, conditional logic, Piv...
Beginner Certificate
Excel & Office Productivity
Excel Dashboards & Data Analysis
A comprehensive course on designing interactive business dashboards, performing advanced data analysis, and building aut...
6 Weeks Beginner Certificate
From
KES 3,000