EDMIRE TRAININGS
Loading...
0%
Learn any skill, Anytime, Anywhere

10% OFF on all Courses – Enroll Now! - قريباً مع إدماير ترينينغز – مفاجآت وتدريبات جديدة بانتظاركم (Coming soon with Edmire Trainings – surprises and new trainings await you)

Apply Now

Why this course?

Formulas Do the Work

From SUM to IF and VLOOKUP — let Excel calculate for you.

Data to Insight

Sort, filter, chart and summarise thousands of rows in seconds.

The Career Skill

The single most requested tool in office job descriptions.

Program Overview

Microsoft Excel is the course that pays for itself. Working on realistic business data, you'll go from confident data entry and formatting to the formulas everyone needs — SUM, IF, VLOOKUP and friends — then tables, charts and finally PivotTables, the feature that turns hours of manual work into seconds. Everything is practised hands-on.

Course Highlights:
  • Real Business Data: Practise on the kind of files you'll actually meet at work.
  • The Formula Toolkit: SUM, AVERAGE, IF, COUNTIF, VLOOKUP/XLOOKUP and more.
  • Charts That Convince: Turn numbers into visuals managers understand instantly.
  • PivotTable Power: Summarise thousands of rows in a few clicks.
Prerequisites

None! Basic computer skills are enough — we take you from your very first worksheet to PivotTables step by step.

Edmire Certified

Earn the "Excel Professional" badge upon completing all modules and passing the hands-on final assessment.

Verifiable Credential

Course Curriculum

5 Modules
Module 01
Worksheets, Data Entry & Formatting
4 Hours
Module 02
Formulas & Functions That Do the Work
6 Hours
Module 03
Sorting, Filtering & Tables
4 Hours
Module 04
Charts & Visualisation
4 Hours
Module 05
PivotTables, Final Assessment & Certification
6 Hours

Frequently Asked Questions

Q: Which Excel version does this course cover?

The course is taught on Microsoft 365, the current version of Excel. Everything applies to recent desktop versions (2019 and later), and your trainer highlights differences — including XLOOKUP vs the classic VLOOKUP.

For classroom training, PCs with Office installed are provided at our training centre. For live online training, you'll need a computer with Excel (a Microsoft 365 trial works fine — we'll help you set it up).

To receive the Edmire Excel Professional Certificate, you must complete all 5 modules and pass the hands-on final assessment — a set of practical tasks on a realistic dataset (formulas, filtering, charting and a PivotTable summary). Students who do not pass on the first attempt can retake the assessment free of charge.

You can take this course as classroom training at our Dubai centre, as live online classes with an instructor, or as custom on-demand training for groups and companies. All course materials remain yours to keep, so you can revisit any topic after the course ends.

You're our favourite kind of student. Self-taught users typically automate 80% of their manual work during this course — one well-placed VLOOKUP or PivotTable often saves hours every single week. Bring your real work problems to class.

Enquire Now

Have questions?

Fill out the form below and we'll get back to you shortly.

Invalid phone number for selected country
Your details are strictly confidential.