Excel: from the fundamentals to dynamic formulas
From your first cell to LET, LAMBDA and dynamic array formulas: master Excel step by step, on real-world cases.
Access: an e-mail address is enough, you receive a sign-in code. Free modules need no bank card.
What you will be able to do
- Structure data as tables and write the essential formulas: SUM, COUNT, IF
- Look up data with VLOOKUP, XLOOKUP, INDEX/MATCH and a Power Query merge
- Handle text, dates and summaries with UNIQUE, SORT, FILTER and GROUPBY
- Simplify formulas with LET and master dynamic ranges (TRIMRANGE, dot operator, #)
- Build a tracking sheet and a dynamic report, as in a recruitment Excel test
- Automate advanced analyses: a one-formula search engine, Pareto with LAMBDA and SCAN
Who it is for
Beginner to experienced Excel users (finance, management control, administrative support, analysis) who want more reliable, faster spreadsheets.
Prerequisites
None for the foundation modules. LET, LAMBDA, SCAN, PIVOTBY or the dot operator require a recent version of Excel, to be checked on each computer.
Included
- Video with chapters
- PDF slides
- Marked quiz
- Verifiable certificate
Programme
Fundamentals
- 01Getting started with Excel and structuring data as a table
- 02Essential formulas: SUM, COUNT, IF and lookups
- 03Looking up data: VLOOKUP, XLOOKUP, INDEX/MATCH
- 04Converting a picture of a table into Excel data
Intermediate
- 05Fifteen key functions: text, dates, conditions and summaries
- 06Simplifying and speeding up your formulas with LET
- 07Dynamic ranges: TRIMRANGE, the dot operator and #
- 08Tracking table: checkboxes and a progress bar
- 09Case study: passing an Excel recruitment test
Advanced
- 10A search engine in one formula: LET, FILTER, SORT
- 11Automated Pareto (ABC) analysis with LAMBDA and SCAN
Training a team? Access for several employees, on quotation. admin@axent-consulting.com