Excel Course for Financial Analyst

Lesson 1 • Efficient Navigation Techniques

Teaches keyboard shortcuts and cell-range navigation for speed. Reduces mouse dependency critical when working with large financial datasets.

Lesson 2 • Configuring Excel for Financial Use

Adjusts calculation settings, decimal precision, and display options. Ensures consistent numeric behaviour before any financial model is built.

Lesson 3 • Data Entry and Cell Management

Covers efficient data entry, autofill, and cell editing techniques. Accurate entry habits prevent downstream errors in financial reports.

Lesson 1 • Structured Tables for Financial Data

Converts ranges to Excel Tables for dynamic referencing and filtering. Tables simplify data management and auto-expand when new financial records are added.

Lesson 2 • Page Setup and Print-Ready Reports

Configures headers, footers, print areas, and scaling for professional output. Ensures financial statements print correctly for client and management distribution.

Lesson 3 • Cell and Range Styling

Uses cell styles, borders, and colour schemes to structure financial layouts. Consistent styling signals data hierarchy and improves readability for stakeholders.

Lesson 1 • Time Value of Money Functions

Applies PV, FV, NPV, IRR, and PMT to investment and loan scenarios. These functions are the foundation of capital budgeting and debt analysis in finance.

Lesson 2 • Logical and Conditional Functions

Builds IF, AND, OR, and nested logic for scenario-driven financial outputs. Conditional formulas enable dynamic models that respond to assumption changes.

Lesson 3 • Formula Logic and Cell References

Explains relative, absolute, and mixed references within formula construction. Mastery here prevents reference errors when copying formulas across financial models.

Lesson 4 • Arithmetic and Aggregation Functions

Covers SUM, AVERAGE, MIN, MAX, and COUNT family functions. These form the computational backbone of every financial summary and variance report.

Lesson 1 • Reference Functions for Financial Models

Applies OFFSET, INDIRECT, CHOOSE, and MATCH to build dynamic model ranges. These functions enable scenario selectors and rolling-period references in dashboards.

Lesson 2 • VLOOKUP and HLOOKUP Mechanics

Explains syntax, match types, and common pitfalls of VLOOKUP and HLOOKUP. Understanding limitations here motivates the transition to more robust lookup methods.

Lesson 3 • XLOOKUP for Modern Workflows

Uses XLOOKUP's return-array and if-not-found arguments for cleaner lookup logic. Replaces legacy functions in environments supporting current Excel versions.

Lesson 1 • Data Type Conversion and Validation

Converts text-stored numbers, fixes date formats, and applies data validation rules. Prevents formula errors caused by mixed data types in financial imports.

Lesson 2 • Text Functions for Data Standardisation

Uses TRIM, CLEAN, LEFT, RIGHT, MID, and FIND to fix imported text fields. Standardised account names and codes are prerequisites for accurate lookups and pivots.

Lesson 3 • Removing Duplicates and Outliers

Identifies and removes duplicate transactions and flags statistical outliers. Clean transaction data is essential for accurate period-over-period financial comparisons.

Lesson 1 • Grouping and Period Analysis

Groups dates by month, quarter, and year for time-series financial reporting. Period grouping enables budget-vs-actual and year-over-year comparisons directly in the pivot.

Lesson 2 • Building Your First PivotTable

Covers source data requirements, field placement, and basic layout options. A well-structured PivotTable is the fastest path from raw data to financial summary.

Lesson 3 • Slicers, Timelines, and Interactivity

Adds slicers and timelines to filter PivotTables dynamically for management review. Interactive controls transform static summaries into self-service reporting tools.

Lesson 4 • PivotCharts for Financial Reporting

Links PivotCharts to PivotTables for dynamic visual summaries of financial data. Charts update automatically when filters change, supporting live management presentations.

Lesson 1 • Building a Three-Statement Model

Links income statement, balance sheet, and cash flow statement with live formulas. The integrated model is the core deliverable of financial planning and analysis roles.

Lesson 2 • Goal Seek and Solver for Targets

Applies Goal Seek and Solver to back-solve for required inputs given a target output. These tools answer what-if questions like required revenue to achieve a margin target.

Lesson 3 • Model Auditing and Error Checking

Uses trace arrows, formula evaluation, and watch windows to audit model integrity. Systematic auditing reduces the risk of presenting incorrect figures to stakeholders.

Lesson 4 • Scenario Manager and Data Tables

Uses Scenario Manager and one- and two-variable data tables to test assumption ranges. Scenario tools quantify upside and downside outcomes for executive decision-making.

Lesson 1 • Macro Recording and VBA Basics

Records macros and edits basic VBA to automate repetitive monthly reporting tasks. Automation reduces processing time and eliminates manual-step errors in recurring workflows.

Lesson 2 • Power Pivot and Data Modeling

Builds a relational data model in Power Pivot using DAX measures for large datasets. Enables analysis across multiple financial tables without VLOOKUP-based data merging.

Lesson 3 • Dynamic Array Functions

Applies FILTER, SORT, UNIQUE, and SEQUENCE to build spill-range financial outputs. Dynamic arrays replace complex helper-column formulas with single-cell solutions.

Lesson 4 • Advanced Conditional Aggregation

Uses SUMIFS, COUNTIFS, AVERAGEIFS, and MAXIFS for multi-criteria financial aggregation. These functions replace PivotTables when formula-based summaries are required in models.