Microsoft Excel | Ingress Academy
AZRU
Create account & apply
ARTIFICIAL INTELLIGENCE · INTERMEDIATE LEVEL

Microsoft Excel

In this course, we’ll take you from the absolute basics of Excel all the way to AI-driven workflows with Copilot. You’ll gain hands-on experience with 10,000-row datasets , automate data with Power Query , and master one-click tasks using VBA macros. From complex functions to building professional interactive dashboards, we cover it all through real-world projects. Finally, you’ll get a head start by learning about the international MOSE exam format and receive our certificate of completion

Intermediate8 weeks4096 hoursOnline
Create account & apply Explore syllabus ↓
Your selected course will be carried into Ingress Portal.
CONDENSED SYLLABUS

See the structure without reading a textbook.

Modules stay collapsed for quick scanning. Open any module to inspect its topics.

01Module 1: Excel Fundamentals and Core Functions6 lessons+

1. Excel Interface and Data Formatting

2. Basic Functions and Cell References

3. Conditional Formatting and Data Cleaning

4. Data Validation and Error Handling

5. Logic Functions (IF, AND, OR, IFS, SWITCH)

6. Lookup Functions and Module 1 Project

02Module 2: Advanced Functions and Data Tools7 lessons+

7. Multi-Condition Aggregation (SUMIFS, SUMPRODUCT)

SUMPRODUCT and Advanced Calculations

8. Text and Date/Time Functions

9. PivotTable, PivotChart and Slicer

10. Power Query: Import, Clean, Transform

11. Power Pivot, VBA and Workbook Protection

12. Visualization, Chart Design and Module 2 Project

03Module 3: Dashboard, Copilot and Assessment6 lessons+

13. Dashboard Design and Data Storytelling

14. Copilot and Prompt Engineering

Prompt Engineering for Excel

Prompt Engineering for Excel

15. MOSE Exam Information

16. Final Project Lab and Assessment

UPCOMING GROUPS

Choose the cohort you can actually attend.

Only current, open groups are shown.

STARTS

To be announced

Online
Schedule
To be announced
Format
Online
Duration
8 weeks · 4096 hours
Language
Confirm with advisor
Join the next cohort waitlist
YOUR INSTRUCTOR TEAM

Specialists matched to the modules they teach.

Course delivery is supported by practitioners across engineering, architecture and production backend development.

NM

Nigar Majidzada

Data AnalystMatanat A Group of Companies
CONTEXTUAL PROOF
“The program helped me connect individual skills into the way real teams design, build and deliver software.”

See real graduate stories from the Ingress community.

Explore graduate results
APPLICATION THROUGH INGRESS PORTAL

Your course stays selected while you create your account.

We use one Portal account for applications, assessments and future learning progress. You will not need to email your details or select the training again.

Questions first? Talk to an advisor
  1. 01

    Create or sign in to your Portal accountYour contact details stay connected to one student profile.

  2. 02

    Confirm your application detailsMicrosoft Excel is preselected.

  3. 03

    Submit your applicationThe admissions team receives it immediately and can follow up from the Portal.

SELECTED TRAININGMicrosoft ExcelOnline

Continue in Ingress Portal Already registered? The Portal will let you sign in instead.