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
Intermediate
Excel For Finance & Accounting
A practical, specialized course on applying advanced Excel tools to financial modeling, corporate valuation, budgeting, financial statements analysis, and accounting workflows.
Verified certificate
What you'll learn
- Financial Statement Modeling: Construct fully linked, dynamic 3-statement financial models with automated balancing mechanisms and error-checking flags.
- Capital Budgeting & Valuation: Evaluate investment opportunities using time-value-of-money (TVM) functions (NPV, IRR, XNPV, XIRR, PMT, CUMIPMT).
- Scenario & Sensitivity Analysis: Conduct risk analysis and stress-test financial projections using Excel Data Tables (1-way and 2-way), Goal Seek, and Scenario Manager.
- Accounting & Financial Analysis: Calculate key financial ratios, perform variance analysis (Budget vs. Actuals), and automate general ledger reconciliations using dynamic array formulas.
- Model Audit & Best Practices: Apply standardized financial modeling standards (FAST/Wall Street standards), clean formatting, and formula auditing tools (Trace Precedents/Dependents).
Course content
The full curriculum is being finalised. Contact us for the syllabus.
About this course
Master the essential Excel techniques required by modern financial analysts, accountants, and corporate finance professionals. This course bridges standard spreadsheet functions with real-world financial decision-making and reporting. You will learn to construct dynamic 3-statement financial models (Income Statement, Balance Sheet, and Cash Flow Statement), perform discounted cash flow (DCF) valuations, execute sensitivity and scenario analyses, and build automated budgeting tools. Additionally, you will master specialized financial functions to evaluate investments, structure loan schedules, and analyze financial performance with precision.
Tools you'll use
Microsoft Excel (365 / 2021+)Power QueryOffice 365Excel Financial Modeling Toolkits
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 Advanced Formulas & Functions
An advanced, formula-driven course mastering modern dynamic arrays, financial and statistical functions, nested computat...
4 Weeks Beginner Certificate
From
KES 6,000