Advanced Excel

The Complete Revision Course for Accounting & Management Control.

Turn Excel from a tool you use into a skill you can prove. This practical guide takes accountants, finance professionals and job candidates from solid basics to confident, interview-ready expertise.

What you will learn

Clean data structuring, tables and references

Logical and lookup functions: IF, IFS, XLOOKUP, INDEX+MATCH

Conditional formulas: SUMIFS, COUNTIFS, SUMPRODUCT

Text, dates and dynamic arrays

PivotTables and Power Query

Charts and dashboards that support decisions

Management control: budget vs actual, margins, break-even, WCR and DSO

Financial functions: PMT, NPV, IRR, depreciation, what-if analysis

Power Pivot, DAX and automation

What you get

20 focused chapters in a clear, practical PDF

Ready-to-use formulas for monthly reporting and financial analysis

7 hands-on exercises with model solutions

Review questions with answers

Keyboard shortcuts and an error-fixing guide

An English/French function glossary for international teams

An interview test checklist and a 4-week practice plan

Who it's for

Accountants and auditors

Financial controllers

Finance students

Anyone preparing for an Excel test or a promotion

Why it works

Short, practical and built around real finance tasks: monthly reporting, ageing balances, reconciliations and dashboards. Read it in an afternoon and use it the next morning.

Get your copy today

Just $10 instead of $25