Excel Course in Dublin

6 Lesson

16 Hours

Add to Wishlist

igmGuru offers the best Microsoft Excel Course in Dublin, delivered by professional trainers. This course covers basic and advanced Excel skills. Our training program gives you hands-on training in Excel tools like formulas, pivot tables, charts, and dashboards. In this course, we offer lifetime access to study materials, 100% practical training, and 100% job assistance to help you apply your skills in the real world. Enroll now and start your Excel journey!

Enroll Now

Overview

Learn both basic and advanced Excel skills: formulas, functions, pivot tables, charts, dashboards & more

Learn to manage, organize, and analyze large datasets

Expert-led training by certified professionals with real industry experience

100% practical learning through live projects and real-world business scenarios

Suitable for students, working professionals, and business users

Lifetime access to study materials: video recordings, PDFs, practice sheets

100% job assistance: resume help, interview prep, and placement support

Stay ahead in Dublin’s job market with in-demand Excel skills

Apply your learning directly to roles in data analysis, reporting, admin, and beyond

Gain Excel skills that are in high demand across finance, tech, and operations roles

Key Features

Experienced & Professional Trainers
Small Batches Upto 10 Participants
24 X 7 Lifetime Support & Access
1 On 1 Training Option Available
Flexible Schedule
Instructor-Led Training within 16 Hrs

Course Curriculum

Lesson 1 - Getting Started

1. Intro to Excel

2. Setting up tables

3. Cleaning bad data

4. Cleaning using Power Query

5. Writing formulas

6. Creating pivot tables

7. Making charts

8. Filtering & sorting

9. Shortcuts

Lesson 2 - Data + Tables + PQ

1. Excel Tables

2. Filtering, slicing tables

3. Bad data to good with PQ

4. Unpivoting data with PQ

5. Merging multiple files to one table

Lesson 3 - Writing Formulas

1. Referencing data

2. IF condition, CHOOSE, IFS

3. Statistical analysis

4. Conditional sum, count

5. Lookups

6. Advanced Lookups

7. Date formulas

8. Text analysis

9. Sentiment analysis

10. Exploratory data analysis

Lesson 4 - Making Pivot Tables

1. Creating pivot tables Data model + relationships

2. Multiple table pivots

3. Customizing pivots

4. Extra calculations in Pivots

5. Grouping data

6. Slicing and dicing

7. Get Pivot Data

Lesson 5 - Charts + Graphs

1. Intro to Charting

2. Picking right charts

3. Anatomy of Excel chart

4. Formatting charts

5. New charts in Excel 2016

6. Budget vs. Actual charts

7. Then vs. Now charts

8. Conditional charts

9. Sparklines

10. Interactive charts

Lesson 6 - Advanced Concepts

1. Data validation

2. Creating templates

3. Workbook protection

4. Publishing to web

5. Shapes + pictures

6. Navigation buttons

7. Printing

8. Form controls

9. Custom ribbons

Talk To Us

We are happy to help you

1-800-7430-173 (US Toll Free)

+91 7240740740 (India)

Drop Us a Query

Fields marked * are mandatory

Name

Phone Number

Comments

Request For Live Demo Class

Course Fees

SELF PACED LEARNING

US $ 199.00 US $ 99.00

Refund Policy

Duration : 16 hrs
Lifetime Free Upgrade
Reference Documents
24x7 Support & Access

WATCH 1st CLASS FREE

Online Class Room Program

US $ 699.00

100% Money Back Guarantee

Duration : 16 Hrs
Plus Self Paced

Classes Starting From

Fast Track Batch 18 Aug 2026
Weekday Batch 24 Aug 2026
Weekend Batch 22 Aug 2026

Corporate Training

Customized Training Delivery Model
Flexible Training Schedule Options
Industry Experienced Trainers
24x7 Support

Trusted By Top Companies Worldwide

Want to know Today's Offer

Microsoft Advanced Excel Certification

This Advanced Excel Course is designed to help you develop advanced spreadsheet and data analysis skills while preparing for the Microsoft Office Specialist (MOS): Excel Expert (Microsoft 365 Apps) certification. The training covers advanced formulas and functions, Power Query, PivotTables, PivotCharts, advanced charting, workbook management, data analysis, automation techniques, and reporting best practices. Upon successful completion of the course, you receive a course completion certificate from igmGuru and are prepared to pursue the Microsoft Office Specialist (MOS): Excel Expert certification.

Microsoft Office Specialist (MOS): Excel Expert Certification Guide

Below are the details for the Advanced Excel certification exam (Expert Level (MO-211)).

Exam Overview

Official Name: Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps)
Certification Provider: Microsoft
Exam Code: MO-211
Exam Format: Performance-Based
Exam Duration: 50 Minutes
Passing Score: 700 out of 1000 (scaled score)
Exam Cost: USD 100 (may vary by region)
Exam Delivery: Certiport Authorized Testing Centers
Language: Multiple languages (availability varies by region)

Reviews

Login

Email ID*

Password*

Forgot Password?