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

Excel for Data Analytics - Basics to Advanced

Learn Excel for data work step by step, then do it yourself. Each lesson explains the idea with a worked example, and then you clean, summarise and analyse sales, customer and operations data. Every answer is checked the moment you press Enter. The lesson and the practice sit on the same screen. A full module shows you how to use AI tools to write formulas and how to catch their mistakes. It's one file that works offline.

What you get

  • 18 modules, from your first formula to dashboards and dynamic arrays
  • A lesson before every exercise: plain explanation, worked example and key points
  • 121 hands-on exercises with instant feedback
  • Data cleaning: TRIM, PROPER, text splitting, duplicates and dates
  • SUMIFS, COUNTIFS and lookups (VLOOKUP, XLOOKUP, INDEX/MATCH)
  • Statistics: median, standard deviation, percentiles, correlation and forecasting
  • Dynamic arrays: UNIQUE, SORT, SORTBY, FILTER and SEQUENCE
  • KPI maths, a charts and dashboards module, PivotTables, Goal Seek, Data Tables and Solver
  • 5 analytics case studies and an interview warm-up with 8 questions
  • 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.
  • 73 quiz questions, a guide to 116 functions and a printable certificate of completion
  • A practice spreadsheet that opens your own .xlsx or CSV file
  • Separate profiles with an optional PIN for shared devices

Who it's for

Students and job seekers preparing for MIS, analyst or operations roles, working professionals who handle reports, small business owners, and beginners who want a clear path into data work.

Try before you buy

The free sample has Modules 1 and 2, taster exercises (cleaning names with TRIM and PROPER, a UNIQUE city list, and average order value and conversion rate) 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. Most formulas work in Excel 2010 and later and in Google Sheets. FILTER, SORT, UNIQUE and SEQUENCE need Excel 2021, Excel 365 or Google Sheets, and TAKE needs Excel 365.
  • Not included. Power Query and macros are explained but not run in the file. There is no Power BI, Python or SQL, and no videos; everything is read-and-do.
  • No promises about results. This course does not promise that you will become a data analyst or an Excel expert. 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.