We use cookies to operate our site, help keep you safe, improve your experience, perform analytics, and serve relevant ads. Click on 'I accept' to accept all cookies.

Microsoft Excel: Advanced Level

Course Description

Microsoft Excel – Advanced Level takes your spreadsheet skills to the next stage, equipping you with powerful tools to analyze, manipulate, and visualize data efficiently. This course delves into advanced Excel features, including Power Query, Power Pivot, formula arrays, and automation through VBA and macros.

Excel is more than just a spreadsheet tool—it is an essential platform for data management, reporting, and business intelligence. Through this course, participants will gain hands-on experience in handling large datasets, building dynamic reports, and leveraging Excel’s automation capabilities to streamline workflows.

Whether you are working in finance, engineering, project management, or any other data-driven profession, mastering advanced Excel functions will help you improve efficiency, enhance decision-making, and unlock valuable insights.

 

 

COURSE OBJECTIVES

 

Develop advanced data modeling skills using Power Query and Power Pivot.
Optimize spreadsheet efficiency with formula arrays and defined names.
Automate repetitive tasks with VBA and macros.
Improve reporting and dashboard creation through data visualization techniques.
Enhance workflow speed with expert-level keyboard shortcuts.

Schedule

April 2025: 7, 10, 14, 17, 24, 28
Time: 1:00 - 3:00 PM (KSA Time)

Topics
Pivot Tables: Create multiple reports from the same dataset.

Functions: Use advanced Excel formulas such as SUM, IF, VLOOKUP, and more to enhance data manipulation.

Charting & Quick Analysis: Visualize complex datasets using Excel’s dynamic charting tools.

Power Query: Connect and combine data from multiple sources, then reshape it to meet your needs. (Exercise: Extracting information from Revit & CostX software).

Power Pivot: Work with data across multiple tables, create relationships, and develop KPIs and DAX measures for improved reporting.

Defined Names: Assign human-friendly names to cells and ranges for easier formula referencing.

Formula Arrays: Write powerful formulas that perform multiple calculations on datasets. (Exercise: Bill of Quantity development, adjustments, and comparisons).

Quick VBA and Macros Overview: Learn basic automation techniques with simple VBA scripts. (Exercise: Bill of Quantity development, adjustments, and comparisons).

Keyboard Shortcuts Ninja: Master time-saving keyboard shortcuts to boost productivity.

Case Study & Data Visualization: Apply all acquired skills to build a sales dashboard using real-world business data.
 

 

Contact us
at DGJ Academy

For more information about the courses, fee structures and dates, or to discuss tailored training programmes, call us on: