Intermediate Excel Training
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.
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.
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.
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.
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.
Transfer
One-way airport transfer
Two-way airport transfer
Entertainment
Desert Safari Dubai
La Perle by Dragone
LEGOLAND Dubai
Aquaventure World Dubai
Ferrari World Abu Dhabi
Motiongate Dubai
Warner Bros. World Abu Dhabi
Where will you be?
Book nearby accommodations
Accommodation
Comfortable lodging nearbyRestaurants
Best restaurants nearbyParks
Parks for relaxation and walks- Accommodations
- Restaurants
- Parks