Workshop
New

MS Excel (Advanced Level) 

Designed to take your Excel skills to a professional level. Learn advanced data analysis tools, task automation, and interactive reporting techniques to support accurate, fast decision-making in today’s dynamic work environments.

Enroll Now
Enroll Now

Why Bakkah?

Money Guaranteed
Self Study
Flexible Learning

By the end, you will be able to: 

  • Build dynamic, professional-level spreadsheets 
  • Use advanced Excel functions such as XLOOKUP, INDEX/MATCH, and nested formulas 
  • Create interactive reports using PivotTables and PivotCharts 
  • Leverage Excel's PowerPivot add-in for powerful data analysis 
  • Perform complex data validation and manage dynamic dropdowns 
  • Conduct What-If Analysis to make smarter business decisions 
  • Audit formulas, model data, and create clean, data-driven reports 
  • Automate routine tasks and apply conditional formatting to bring your data to life 
  • Analysts, accountants, data professionals, and business managers 
  • Excel users with basic/intermediate knowledge looking to level up their skills 
  • Students and graduates pursuing data-driven roles 
  • Professionals seeking to boost efficiency, speed, and accuracy in Excel 
  • Anyone who wants to enhance their career portfolio with expert Excel skills 

You’ll gain expert knowledge in: 

Advanced Excel Functions: 

  • Master XLOOKUP, VLOOKUP, INDEX, MATCH, nested IFs, and logical formulas 
  • Create dynamic ranges, perform data consolidation across sheets 

Pivot Tables & Charts: 

  • Build compelling dashboards and reports for business intelligence 

Data Validation Techniques: 

  • Set input restrictions, create cascading dropdowns, and ensure clean data entry 

Sorting & Filtering: 

  • Use advanced filters, custom sorts, and multi-level sorting to streamline your data view 

What-If Analysis: 

  • Use Goal Seek, Scenario Manager, Solver, and Data Tables to forecast and evaluate different scenarios 

More Advanced Tools: 

  • Work with date/time functions, text manipulation, formula auditing, and conditional formatting 
  • Master functions like COUNTIFS, SUMIFS, and Excel’s Data Modeling features 

Reading Learning Materials. 

Pre and Post Course Questions.  

Modules Exercises. 

The material language will be English. 

  • Module 1 - Working with Functions 
  • Module 2 - Pivot Tables 
  • Module 3 - Data Validations 
  • Module 4 - Sorting and Filtering Data 
  • Module 5 - What If Analysis 
  • Module 6 - More Functions 
WhatsApp