Intermediate Excel Training
Offline
Dubai
Accommodation options are available for this course
The Intermediate Excel Training course is a practical, hands-on program designed for individuals looking to strengthen their data lookup, summarization, and preparation skills. Participants will build confidence with core Excel functions like XLOOKUP and INDEX/MATCH, work effectively with tables, PivotTables, PivotCharts, and dashboards, and master essential data-cleaning techniques including Power Query.
The course combines step-by-step practice with real-world datasets, mini-projects, and interactive Q&A sessions to ensure participants can immediately apply their skills in professional settings. This program equips learners with the practical expertise to streamline workflows, enhance data accuracy, and present insights effectively.
Course Breakdown
- Core Lookup Skills
- XLOOKUP & INDEX/MATCH Basics
- Working with Tables
- PivotTables Foundations
- PivotCharts & Dashboards
- Conditional Formatting & Validation
- Data Cleaning Tools
- Power Query Introduction
- Mini project applying learned skills and open Q&A session
Course Details
- Total Duration: 12 hours
- Number of sessions: 6 sessions
- Duration of one session: 2 hours
- Format: On-site
- Class Schedule: weekday and weekend options
- Level: Beginner to Intermediate
Course Instructor
Ahmed Salama — Google-certified Data Analyst and AI entrepreneur with 5+ years of experience delivering over 150 Excel and data skills trainings to professionals across multiple industries. Ahmed is focused on practical, real-world learning and simplifying complex concepts.
Training Methodology
- Practice workbooks
- Step-by-step exercises
- Reference sheets for formulas and shortcuts
- Sample datasets for hands-on practice
Why Choose DG Institution?
- Experienced instructors
- KHDA certified courses
- Practical training
- Small groups
- Customization
- Flexible learning modes
- Job assistance and career counselling
What You Will Get
- Confident use of VLOOKUP, HLOOKUP, and XLOOKUP for data search and comparison
- Ability to summarize datasets using PivotTables and PivotCharts
- Data cleaning and transformation using Power Query and advanced filters
- Improved spreadsheet structure, formatting, and formula troubleshooting
- Interactive practice with real datasets and step-by-step exercises
By the end of this course, you’ll be able to confidently manage, analyze, and visualize data in Excel, streamline your workflows, and solve real-world spreadsheet challenges all while earning a Certificate of Completion.
Gallery
School accommodation
KSK Homes Student Residence and Hotel
- KSK Homes Twin Room
- Bed Type: Two Single
- Occupancy: Double Occupancy
- Important information: The minimum booking period is 1 month. Booking must be made strictly 3 weeks in advance as the number of spots is limited.
$1089.00
Month
KSK Homes Student Residence and Hotel offers modern twin-share accommodation for two students with an en-suite bathroom, twin beds, study desks, wardrobe, LED TV, fridge, and electronic safe. Residents enjoy access to a rooftop pool, gym, study lounges, gaming room, shared kitchens, regular housekeeping, Wi-Fi, utilities included, and shuttle service for a comfortable student lifestyle.
KSK Homes Student Residence and Hotel
- KSK Homes Single Room
- Bed Type: Single
- Occupancy: Single Occupancy
- Important information: The minimum booking period is 1 month. Booking must be made strictly 3 weeks in advance as the number of spots is limited.
$1634.00
Month
KSK Homes Student Residence and Hotel offers modern single-occupancy student accommodation with an en-suite bathroom, single bed, desk, wardrobe, LED TV, fridge, and electronic safe. Residents have access to a rooftop pool, gym, study rooms, a gaming area, communal kitchens, regular housekeeping, Wi-Fi, utilities, and shuttle service for a comfortable student living experience.
Yugo Dubailand
- Yugo Twin Room
- Bed Type: Two Single
- Occupancy: Double Occupancy
- Important information: The minimum booking period is 4 months. Booking must be made strictly 3 weeks in advance as the number of spots is limited.
$1008.00
Month
Yugo Dubailand offers modern twin-share accommodation for students with an en-suite bathroom, twin beds, study desks, wardrobe, LED TV, fridge, and electronic safe. Residents enjoy access to a rooftop pool, gym, study lounges, gaming room, shared kitchens, regular housekeeping, Wi-Fi, utilities included, and shuttle service for a comfortable student lifestyle.
Yugo Dubailand
- Yugo Single Room
- Bed Type: Double
- Occupancy: Single Occupancy
- Important information: The minimum booking period is 4 months. Booking must be made strictly 3 weeks in advance as the number of spots is limited.
$1634.00
Month
Yugo Dubailand offers modern single accommodation for students with an en-suite bathroom, a double bed, study desk, wardrobe, LED TV, fridge, and electronic safe. Residents enjoy access to a rooftop pool, gym, study lounges, gaming room, shared kitchens, regular housekeeping, Wi-Fi, utilities included, and shuttle service for a comfortable student lifestyle.
Transfer
One-way airport transfer
Airport transfer from DXB to accommodation
$90.00
For the service
Airport transfer from DXB to accommodation
Two-way airport transfer
Two-way airport transfer from DXB to accommodation
$170.00
For the service
Two-way airport transfer from DXB to accommodation
Entertainment
Desert Safari Dubai
Desert safari with dinner in a Bedouin camp is an unforgettable evening adventure in the heart of the Arabian desert, combining thrilling activities, stunning views, and traditional UAE culture.You wi...
$245.00
For the service
Desert safari with dinner in a Bedouin camp is an unforgettable evening adventure in the heart of the Arabian desert, combining thrilling activities, stunning views, and traditional UAE culture.You will be picked up from your hotel approximately between 2:30 PM and 3:00 PM (exact time depends on the hotel’s location). At the end of the program, you will be comfortably dropped back at your hotel by 9:00 PM.
La Perle by Dragone
La Perle is a breathtaking live show featuring world-class acrobatics, aquatic stunts, and stunning visual effects. Performed in a unique theater with a 360° stage and water pool, it creates an unforg...
$90.00
For the service
La Perle is a breathtaking live show featuring world-class acrobatics, aquatic stunts, and stunning visual effects. Performed in a unique theater with a 360° stage and water pool, it creates an unforgettable atmosphere of magic, emotion, and excitement. Perfect for families, couples, and a memorable night in Dubai.
LEGOLAND Dubai
LEGOLAND Dubai is a family-friendly theme park with over 40 rides, shows, and play areas built from millions of LEGO bricks. Kids can drive cars, fly planes, build creations, and explore themed worlds...
$87.00
For the service
LEGOLAND Dubai is a family-friendly theme park with over 40 rides, shows, and play areas built from millions of LEGO bricks. Kids can drive cars, fly planes, build creations, and explore themed worlds. The highlight is Miniland, an air-conditioned area featuring Dubai’s iconic landmarks made of LEGO.
Aquaventure World Dubai
Aquaventure World Dubai is a great destination for an active family getaway, offering water attractions, a beach, kids’ entertainment, and opportunities to explore marine life. The park is open daily ...
$115.00
For the service
Aquaventure World Dubai is a great destination for an active family getaway, offering water attractions, a beach, kids’ entertainment, and opportunities to explore marine life. The park is open daily and features restaurants and all the necessary facilities for a comfortable day out.
Ferrari World Abu Dhabi
Ferrari World Abu Dhabi — an exciting adventure for the whole family! As the world’s first Ferrari-themed park, it offers thrilling high-speed rides and unforgettable experiences for both kids and adu...
$105.00
For the service
Ferrari World Abu Dhabi — an exciting adventure for the whole family! As the world’s first Ferrari-themed park, it offers thrilling high-speed rides and unforgettable experiences for both kids and adults.
Motiongate Dubai
Motiongate Dubai is a Hollywood-themed amusement park at Dubai Parks and Resorts. It features rides and live shows inspired by popular movies like Shrek, Kung Fu Panda, Madagascar, and The Smurfs, cre...
$87.00
For the service
Motiongate Dubai is a Hollywood-themed amusement park at Dubai Parks and Resorts. It features rides and live shows inspired by popular movies like Shrek, Kung Fu Panda, Madagascar, and The Smurfs, created by DreamWorks, Lionsgate, and Columbia Pictures. A perfect destination for family fun.
Warner Bros. World Abu Dhabi
Warner Bros. World Abu Dhabi is one of the world’s largest indoor theme parks. Fully air-conditioned, it features iconic Warner Bros characters such as Batman, Superman, Wonder Woman, Bugs Bunny, and ...
$105.00
For the service
Warner Bros. World Abu Dhabi is one of the world’s largest indoor theme parks. Fully air-conditioned, it features iconic Warner Bros characters such as Batman, Superman, Wonder Woman, Bugs Bunny, and Scooby-Doo. The park offers 29 family-friendly rides, interactive attractions, live shows, and themed dining across six immersive zones.
Where will you be?
Book nearby accommodations
Accommodation
Comfortable lodging nearbyRestaurants
Best restaurants nearbyParks
Parks for relaxation and walks- Accommodations
- Restaurants
- Parks
Close
Related courses
Offline
Dubai
Accommodation options are available for this course
A2-B1
English
Groups
Limited Seat - 10
24 hours / course
The Advanced Excel Training course is designed for professionals who want to move beyond spreadsheets and unlock the full power of data analysis and reporting. This hands-on program combines practical...
$653.51
Offline
Dubai
Accommodation options are available for this course
A2-B1
English
Groups
Limited Seat - 10
16 hours / course
The Microsoft Office Course is designed for students, professionals, and entrepreneurs who want to build strong, practical skills across the most essential workplace tools —Microsoft Word, Excel, and ...
$612.66