Intermediate
Excel Course
Our Intermediate Excel Course is designed to help your team deepen their Excel skills and develop key competencies in data analysis and advanced reporting.
+2,000 companies trust us
Intermediate Excel Course
-
5.1 hrs of video lessons.
-
81 classes
-
+195 practical exercises.
-
Learning by Doing
Our Intermediate Excel Course is designed to help your team deepen their Excel skills and develop key competencies in data analysis and advanced reporting. Through certifications B1 and B2, they will learn to apply complex functions, work with pivot tables, merge databases, and create reports with greater accuracy and efficiency.
Your team will master time, date, and text functions, as well as data modeling, forecasting, validations, and analytical tools. They will learn to build and customize pivot tables and charts, apply advanced lookups and conditional functions, and use data tools for targeted analysis.
-
What your teams will learn:
-
Functions and projections:
Your team will apply text, date, and logical functions, and use Goal Seek and Scenarios to simulate decisions and transform data.
-
Pivot tables and charts:
They’ll be able to build pivot tables, group and segment data, and use linked charts to enhance the visualization of key information.
-
Lookup, validation, and data cleaning:
They’ll use functions like VLOOKUP, INDEX, and MATCH, validate dependent data, and consolidate information from multiple sources.
-
Auditing and smart formatting:
They’ll be able to audit formulas, prevent errors, apply conditional formatting, and protect documents while maintaining data integrity.
B1
Intermediate
Deepen analytical tool skills. Your team will learn to use text, date, and time functions, group data, build pivot tables and charts, and analyze and visualize information.
-
161 min.
-
6 units
-
Text Functions
-
Time and Date Functions
-
Outline
-
Data Forecast
-
Pivot Table
-
Pivot Charts
-
Final Exam B1
B2
Upper Intermediate
Improve the efficiency and quality of data analysis. Your team will learn to apply advanced conditional functions (VLOOKUP, INDEX, MATCH), validate data, audit formulas, and customize reports.
-
150 min.
-
6 units
-
Conditional Formatting1
-
Data Tools
-
Data Validation
-
Lookup Functions
-
Formula Auditing
-
Custom Pivot Table Tools
-
Final Exam B2
Excel Certifications That Validate Real Learning
Certify your team's skills with credentials that reflect a structured, applied learning process. Each completed course grants a certificate that’s part of a progressive learning path — measurable, relevant, and aligned with real workplace needs.
-
Certification by Level (A0 to C2)
Each completed stage is accredited with an individual certificate that proves technical progress.
-
QR Code with Skill Breakdown
Each certificate includes a unique QR code that lists the skills and tools acquired.
-
Shareable on LinkedIn and CVs
Certificates can be added to professional profiles or resumes to showcase proven Excel expertise
What
our clients say
Empower your teams with
high-impact training
Schedule a call with us and boost your organization’s Excel capabilities today.
Frequently Asked Questions
Take a look at some of the most common questions our clients ask.
Each course includes:
Short, practical video lessons.
Interactive exercises completed directly within Microsoft Excel via streaming.
Automatic feedback on every activity.
Unit assessments and a final exam.
A professional certificate for each completed level.
All content is designed using the learning by doing methodology, so learners can apply what they’ve learned from the very first class.
The content is organized by level and specific skills, ranging from A0 to C2.
You can request the Ninja Excel Test, a practical, untimed assessment with 30 questions.
At the end, you’ll receive a report via email with the recommended course level for each team member.
The courses are organized by proficiency level:
A0 to A2: From basic navigation to conditional functions and charts.
B1 and B2: Analysis tools, data validation, and pivot tables.
C1 and C2: Automation, macros, dashboards, and advanced data analysis.
Each level grants an independent certification and includes exercises aligned with real-world job challenges.
The levels range from basic Excel use (A0: interface and navigation) to advanced tasks like macro automation and dashboard creation (C2).
Each level develops specific skills and aligns with practical competencies for daily work.
Yes. Users can access all content anytime, from anywhere.
There are no fixed schedules or mandatory live sessions.
Teams can progress at their own pace and repeat exercises as many times as needed.
No. Our platform is integrated with Microsoft Excel via streaming, so there’s no need to install Excel or leave the learning environment.
The entire course—lessons, exercises, feedback, and navigation—takes place within the real Excel environment, with no simulators or extra setup required.
All you need is an internet connection to start practicing from anywhere.
Yes. Each completed course and level grants a professional certificate that validates specific Excel skills, depending on the completed level (A0 to C2) or specialization program.
Yes. Ninja Excel is designed for training entire teams.
You can request a demo or personalized consultation to manage bulk enrollments, progress tracking, and consolidated reporting.
We use real Microsoft Excel, not simulators.
Content adapts to progressive skill levels.
Over 400 exercises based on real-world work situations.
Automatic feedback and support from Microsoft Certified Trainers.
Everything happens in one platform—no switching environments or installing software.
Yes. You can book a free demo to explore the platform, the learning methodology, and how the courses fit your organization’s needs.