Workshop
New

MS Excel (Intermediate Level)

Designed to elevate your Excel skills and streamline daily tasks. Learn how to analyze data, automate calculations, and create professional reports using PivotTables and essential functions—boosting your productivity and workplace efficiency.

Enroll Now
Enroll Now

Why Bakkah?

Money Guaranteed
Self Study
Flexible Learning

By the end, will be able to: 

  • Build well-structured and effective spreadsheets for real-world tasks 
  • Use key Excel functions like VLOOKUP, IF, and SUM to automate calculations 
  • Create and customize PivotTables and PivotCharts for insightful data reporting 
  • Sort and filter data quickly for better decision-making 
  • Apply statistical tools such as Mean, Median, Mode, and Standard Deviation 
  • Use Excel like a pro with time-saving tips, tricks, and shortcuts 
  • Work across multiple worksheets, link data, and automate simple tasks with Macro 

This course is ideal for: 

  • Office professionals seeking to improve their Excel productivity 
  • Data entry staff and administrative support professionals 
  • Business analysts and junior accountants 
  • Students and fresh graduates looking to boost their job readiness 
  • Anyone with basic Excel knowledge aiming to move to the next level 

You’ll gain hands-on skills in: 

  • Excel Fundamentals – data entry, editing, formatting, charts, and printing 
  • Formulas & Functions – including advanced tools like IF/IFS, VLOOKUP, and statistical functions 
  • Data Analysis – using sorting, filtering, and PivotTables 
  • Visualization – creating dynamic charts and sparklines 
  • Tips & Tricks – working with text, dates, graphics, random number generation, macros, and more 
  • Statistical Tools – applying key measures of central tendency and data spread to analyze datasets 

Reading Learning Materials  

Pre and Post Course Questions. 

Modules Exercises. 

Case Study. 

Training Manual. 

The material language will be English. 

  • Module 1 – Introduction to Excel
  • Module 2 – Advanced Excel Formulas & Functions
  • Module 3 – Pivot Tables/Charts
  • Module 4 – Sorting and Filtering Data
  • Module 5 – Tips & Tricks
  • Module 6 – Introduction to Excel Statistics
WhatsApp