Data · All levels
A self-paced library of Excel, Power Query, macro and Power BI courses, with recorded case reviews and templates for real office work.
You know Excel can do more than you use it for. You have watched a colleague build a report in minutes that takes you an afternoon, or write a formula that keeps working when the data changes. The gap is rarely intelligence. It is a set of tools and habits you have never had the time to learn properly.
Most people learn Excel one search at a time. That works until a file arrives with inconsistent columns, merged cells, hidden rows and a deadline. Then the searching starts again, and the same report costs you another evening.
This library replaces scattered tips with a structured path. It brings together eleven courses on formulas, advanced Excel, Power Query, macros, Power BI and dashboards, plus recorded case reviews, webinars and practice files. You learn the tool first, then apply it to the kind of messy work that actually lands on your desk.
You do not need to become a developer. You need to recognise which tool fits the task, use it with confidence, and leave behind a file that someone else can maintain without calling you.
Every ability is practised on a working file, not just demonstrated on screen.
Use core, logical and lookup functions without building fragile chains that break on the next copy.
Import, reshape and refresh tables in Power Query instead of patching them by hand.
Record and edit simple macros for routine formatting, filtering and data movement.
Design interactive Excel dashboards for headcount, call-centre and analytical reports.
Connect sources, build a simple model and create visuals for reports you refresh regularly.
Trace differences, check totals and spot broken links before a file leaves your desk.
Know when a formula, a pivot table, a query or a macro will save you the most time.
The library is fully self-paced. After purchase you get access to a personal learning area containing all included courses, recorded sessions, workbooks and templates. You can start with the Excel foundations or jump straight to Power Query, macros or dashboards if that is where your work hurts most.
Each course is built from short video lessons. A lesson explains one idea, shows it on screen in a working file, and ends with a practice task in a supplied workbook. The tasks use realistic office scenarios: sales exports, staff lists, call-centre logs, budget tables and reports that need cleaning before anyone can use them.
Recorded webinars and case reviews sit alongside the courses. They show how an experienced eye approaches a file: where to look first, which formula to avoid, how to simplify a query and how to present the result so a manager can read it. You can watch them in any order and return to them when a similar task appears.
There is no fixed schedule and nothing to attend live. You keep the material and can revisit a lesson months later, when a new file finally makes sense of it.
Eight modules take you from reliable formulas to automated reports and dashboards. Recorded webinars, case reviews and practice files are included throughout.
Everything is delivered in one learning area and stays available after purchase.
Foundations, advanced Excel, macros, Power Query, Power BI and three dashboard courses.
Short, practical lessons you can watch in any order and revisit at any time.
Practical sessions on formulas, charts, data collection and automation.
Walkthroughs of real files and reporting problems, with the reasoning behind each step.
Ready-made report, tracker and dashboard files you can adapt to your own work.
Exercises with worked solutions so you can check your own approach.
Focused sessions on charts and first macros, kept in the library for repeat viewing.
One purchase, no renewal, no expiry date on the material.
Every module follows the same rhythm. You start with a task that looks familiar and slightly annoying: a monthly export with three different date formats, a report that must be rebuilt each week, a summary that nobody trusts. Then you learn the single tool that solves it best, and you build the solution yourself in the supplied workbook.
This is deliberately narrow. Instead of touring every function in the ribbon, the lessons teach the small set of tools that cover most office work: lookups and logic for matching, pivots for summarising, Power Query for cleaning and combining, macros for repetition, and dashboards for presentation.
The recorded case reviews add the part that courses usually skip: judgement. You see a file being opened for the first time, the questions asked about it, the dead ends rejected, and the moment a simpler approach wins. That is the skill that makes you faster next month, not just during the course.
Practice files mirror the lessons, so you can pause the video, try the step yourself, and compare your result with the finished version before moving on.
A month from now, the monthly report that used to take an afternoon is a query refresh and a pivot table. The file with inconsistent columns is cleaned by a workflow you built once and can reuse, rather than by an hour of copy, paste and delete.
You will also have a clearer sense of what to learn next. Some people finish the dashboard module and move their recurring reporting into Power BI. Others stay in Excel and automate the boring parts with small macros. Both are valid, and the library supports both paths.
Most of all, you stop treating Excel as a memory test. You keep a personal set of patterns, templates and checked formulas that you understand, which means you can explain your work to a colleague, hand over a file without fear, and fix a problem when the data changes shape.
The material stays with you, so when a new task appears in six months, the relevant lesson is still there.
Most learners watch two or three lessons a week, which is roughly one to two hours including the practice task. The library is self-paced, so you can move faster through topics you already know and slow down on Power Query or macros.
You should be comfortable opening a workbook, entering data and writing a basic formula. The first module covers foundations properly, so a rusty user can start there, while experienced users can begin with advanced Excel, Power Query or dashboards.
Your order confirmation contains the link to the learning area, where all included courses, recorded sessions, workbooks and templates are unlocked. Access is tied to your account, so keep the login details you receive.
Lessons are recorded screen videos with narration, usually short enough to watch in one sitting. Each one comes with a workbook or practice file, and the recorded webinars and case reviews are longer walkthroughs you can pause and revisit.
Yes. The purchase is one-time and the material does not expire, so you can return to any lesson or template later. New material added to the library during your access period appears in the same learning area.
You have 14 days from purchase to request a refund. If the library is not what you expected, contact support within that window and the payment is returned according to the store policy.
A desktop version of Excel with Power Query included covers nearly everything. Power BI lessons require the free desktop application. Google Sheets users can follow the formula and dashboard lessons, though some automation topics are Excel-specific.
No. This is a recorded, self-study library: video lessons, recorded webinars and case reviews, workbooks and templates. There are no scheduled calls and no individual tutoring, which is why the material can be offered at this price.
Yes, the report, tracker and dashboard files are there to be adapted to your own data and processes. They are meant as starting points you modify, not as fixed products.
One purchase unlocks all eleven courses, the recorded sessions and the template library, with permanent access and a 14-day refund window.