Prices shown are original rates. Check our store for current discounts.
Visit the store
Skills · Advanced Excel

Excel Pro Lab

Advanced Excel practice for people who already know the basics. Each lesson explains the idea with a worked example, then you build the formula yourself on realistic work data and get it checked the moment you press Enter. It covers modern lookups, dynamic arrays, LET and LAMBDA, what-if tools and dashboards, plus a module on using AI to write and check formulas. "Pro" describes the level of the topics. It's one file that works offline.

What you get

  • 13 modules, 66 hands-on exercises and 80 quiz questions
  • Advanced lookups: INDEX/MATCH and XLOOKUP in all its forms
  • Dynamic arrays: FILTER, SORT, SORTBY, UNIQUE, TAKE and SEQUENCE
  • LET and LAMBDA, SUMPRODUCT, MAXIFS and MINIFS, TEXTBEFORE, TEXTAFTER and TEXTJOIN, and finding duplicates
  • PivotTables, conditional formatting, data validation, Goal Seek, Data Tables and Solver
  • 5 chart tasks, a chart quiz and a KPI dashboard
  • Formula auditing, plus Power Query, macros, VBA and Office Scripts as concepts
  • Excel with AI: prompts and hands-on tasks where you check and fix AI formulas. No AI is built in and you need no AI account.
  • An interview quiz and older-Excel alternatives for every modern function
  • 6 capstone projects and a printable certificate of completion
  • A practice spreadsheet and a guide to 116 functions
  • Separate profiles with an optional PIN for shared devices

Who it's for

Working professionals in accounts, finance, sales, operations, HR and MIS, analysts and managers, job seekers preparing for Excel tests, and students who already know the basics. If you're new to Excel, start with Excel - Basics for All.

Try before you buy

The free sample has Module 1 (warm-up), Module 2 (advanced lookups), taster exercises on UNIQUE, LET and one AI task, and the practice spreadsheet. Your sample progress moves to the full version.

Good to know

  • Independent product. Made by 99DigiProStore, a new initiative by a qualified CMA. Microsoft Excel is a trademark of Microsoft Corporation. This product is not affiliated with or endorsed by Microsoft. ChatGPT, Gemini, Copilot and Claude are trademarks of their owners and are named only as examples.
  • A light learning spreadsheet. The practice spreadsheet is made for learning. It is not a full copy of Excel, and many advanced Excel features are not included. Use Excel or Google Sheets for your real work.
  • Works with your Excel. XLOOKUP, FILTER and LET need Excel 2021 or Excel 365. LAMBDA, TAKE and TEXTBEFORE need Excel 365 or Excel 2024. The lessons show older alternatives too.
  • Not included. Power Query and macros are explained but not run in the file. MAP, BYROW and REDUCE are not practised. There are no videos; everything is read-and-do.
  • No promises about results. This course does not promise that you will become an Excel pro. "Pro" is the level of the topics, not a promise about you. It does not promise a job, a promotion or any exam result. Skill comes from regular practice, and this gives you a structured place to do it.
  • Examples, not advice. Companies, figures and rules in the exercises are made up for practice. They are not tax, legal or investment advice.
  • Certificate. It records course completion on your own device. It is not an accredited qualification.
  • Devices. Use a laptop or desktop (Chrome, Edge, Firefox or Safari) or an Android phone in Chrome. iPhones preview downloaded .html files without saving progress, so use a laptop there.
  • Personal use. One buyer, personal use. Please don't share or resell the file.
  • All sales are final. If the file is faulty, we fix it, replace it or refund you. See the refund policy.