An Excel advanced course for people who already master pivot tables and XLOOKUP and want reports to build themselves. In 16 hours your team automates cleaning with Power Query, solves with dynamic array formulas (FILTER, UNIQUE, SORT, LET) what used to need helper columns, relates tables in the data model with Power Pivot, builds dashboards and records macros that run the weekly close with one click.
It is the third level of the path: a 16-hour program about automation. It covers Power Query to import and clean data from several files and folders without touching them by hand; the Microsoft 365 dynamic array formulas (FILTER, UNIQUE, SORT, SEQUENCE, LET, basic LAMBDA); the data model with Power Pivot and simple DAX measures to relate tables without VLOOKUP; dashboards with connected slicers; and macros recorded and edited in VBA for repetitive tasks. It follows the Excel intermediate course and connects naturally with the data analysis with Excel course and with Power BI.
The exact duration is in the first card. It runs on-site at your company, live virtual for teams in several locations or self-paced on the platform; every participant who meets attendance and assessment receives a DC-3 certificate with the STPS, and Geedle Bot answers questions afterwards with the exact minute of the recording.
16 hours
Live virtual · On-site · Self-paced
DC-3 · STPS
Geedle Bot answers questions 24/7 with the exact minute of the recording
Proposal with three scope options and a closed price in under 24 business hours
Three independent levels, each with its DC-3; hire one or chain them as a learning path.
Learning objectives observable on the job.
Import folders and several files, transform, append and merge queries, parameters and one-click refresh.
FILTER, UNIQUE, SORT, SEQUENCE, XLOOKUP with arrays, LET and basic LAMBDA to replace helper columns.
Data model with relationships, calendar table, simple DAX measures and pivot tables on top of the model.
Dashboards with connected slicers, advanced conditional formatting, macros recorded and edited in VBA with run buttons.
Six modules in order, each with a deliverable you apply in your operation the following week. Exercises use real files and cases from your organization, each module's assessment is recorded on the platform and serves as evidence for the DC-3 certificate.
Connecting to files, folders and tables, data types, conditional columns, pivot and unpivot, applied steps.
Query that consolidates a folderAppending several sources, merging like VLOOKUP, parameters, reference queries and scheduled refresh.
Reusable load modelFILTER, UNIQUE, SORT, SEQUENCE, multi-column XLOOKUP, LET and a basic LAMBDA; when to use them and when not to.
Report with no helper columnsRelationships between tables, calendar table, sum, count and percentage DAX measures, pivot tables on the model.
Model with 3 related tablesConnected slicers and timelines, combo charts, sparklines, icon-based conditional formatting and executive layout.
Executive dashboardRecording macros, editing the essentials in VBA (simple loops and conditions), buttons, macro security and process documentation.
Documented one-click closeAnalysts, accountants, planners and people in charge of inventory, payroll, quality, sales or finance who consolidate information from several sources every week or month and need the process to be reproducible. Also for university and government data areas that receive files from many units in different formats. Requires the intermediate level or fluent use of pivot tables and lookup functions.
The close that took a day shrinks to refreshing a Power Query query and a dashboard. Files from several branches or areas consolidate on their own, dynamic array formulas remove helper columns and intermediate sheets, the data model relates sales, catalogs and budget without VLOOKUP, and a macro leaves the report ready to send. The team documents the process and is one step away from Power BI.
Request the proposal for the excel advanced course: three scope options with a closed price in under 24 business hours.
From the administrative assistant to the analyst: every role gets the level it needs and leaves with a real file from its operation (inventory, payroll, quotes, weekly report) solved with method. We combine it with the courses for retail and services.
Administrative, registrar and finance areas that consolidate reports from several faculties in shared sheets: data validation, pivot tables and Power Query so closings do not depend on a single person. It is part of the courses for university administrative staff.
Registries, official letters, budget and quarterly reports that are entered by hand today: validated forms, matches between databases and dashboards for planning and comptroller liaisons. You will find it within the courses for government and the public sector.
Real projects told with facts, not promises.
Move graduate and undergraduate subjects, plus English and Spanish language courses, to a virtual format with academic quality and a consistent look.
Read the full caseUpdate a large faculty — university and high school — on artificial intelligence and inclusive teaching, without stopping classes.
Read the full case
Geedle Bot is trained on the syllabus, materials and recordings of your course. Participants ask in plain language and get an exact answer, not a generic one.
All of them issue a DC-3 certificate and leave records on the platform; what changes is how people practice and how the calendar is organized.
| Live virtual | On-site at your company | Self-paced on the platform | |
|---|---|---|---|
| Ideal for | Teams across several sites or remote | Hands-on practice, team dynamics and brigades | Rotating shifts and large workforces |
| Interaction | Live instructor, breakout rooms and real cases | Instructor in the room, role-plays and practice with equipment | Microlessons, challenges and automatic assessments |
| Typical duration | 2-to-4-hour sessions on different days | 4-to-8-hour days | 2 to 4 weeks at your own pace |
| Records | Attendance, participation and assessment on the platform | Roster, assessment and photo evidence | Progress, grades and time on the platform |
| Questions between sessions | Geedle Bot 24/7 | Geedle Bot 24/7 | Geedle Bot 24/7 |
| Certificate | DC-3 with the STPS | DC-3 with the STPS | DC-3 with the STPS |
Short reads to decide better before you hire.
Other data, office tools and digital security courses and the full category.
Tell us how many people, in which city and in which format. We reply the same day, free and with no commitment.
