An Excel intermediate course for people who already use formulas and filters and spend hours matching lists, cleaning text and building the same summary every week. In 16 hours your team masters XLOOKUP and INDEX/MATCH, text and date functions, data validation, pivot tables and charts and protecting shared files, with the real reports from your operation.
It is the second level of the path: 16 hours to turn an Excel user into someone who matches, cleans and summarizes information without help. It covers lookup functions (XLOOKUP, VLOOKUP, INDEX and MATCH), text, date and combined logical functions, data validation with drop-down lists, pivot tables with calculated fields and slicers, pivot charts and sheet and workbook protection. It follows the Excel basic course and prepares for the advanced level, where Power Query, array formulas and macros come in.
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.
XLOOKUP, VLOOKUP, INDEX and MATCH, with error handling (IFERROR) and multi-criteria lookups.
LEFT, MID, TRIM, TEXT, DATEDIF, WORKDAY and combinations to standardize keys, names and dates.
Drop-down lists, dependent lists, date and number rules, error messages and formula-based conditional formatting.
Pivot tables with calculated fields, date grouping, slicers, pivot charts and sheet and workbook protection.
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.
XLOOKUP and VLOOKUP, INDEX and MATCH, approximate and multi-criteria lookups, IFERROR and structured references in tables.
Reconciliation of two databasesTRIM, UPPER, MID, TEXT, TEXTJOIN, DATEDIF, WORKDAY, EOMONTH, AND / OR with nested IF.
Clean, standardized databaseDrop-down lists, dependent lists, custom rules, input and error messages, formula-based conditional formatting.
Validated entry formLayout, date grouping, calculated fields and items, percent of total, several tables from one source and refresh.
Weekly summary with pivot tablesPivot charts, slicers and timelines connected to several tables, a summary sheet designed for management.
One-page dashboardProtecting sheets and workbooks, allowing editable ranges, comments, co-authoring in OneDrive and good naming and versioning practices.
Protected workbook ready to shareAnalysts, administrative staff, accountants, buyers, HR, sales, logistics and quality staff who report and reconcile information in Excel and need to match databases, summarize with pivot tables and deliver files that do not break when someone else uses them. Also for government and university administrative areas that consolidate reports from several units. Requires the basic level or comfortable use of formulas and filters.
Reports built with pivot tables instead of formulas copied cell by cell, matches between databases that no longer fail because of spaces or capitals, data-entry forms with validation that stop errors at the source and protected files several people use without wrecking them. The weekly summary that took an afternoon refreshes in minutes, and the team is ready for Power Query and automation at the advanced level.
Request the proposal for the excel intermediate 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.
