By the end of this course, participants will be able to:

• Utilize Excel’s advanced features for data analysis and modeling
• Create complex data models and perform sophisticated analyses
• Use Power Query and Power Pivot to transform and analyze data
• Apply advanced functions and formulas for detailed data insights
• Develop compelling visualizations and interactive dashboards
• Perform scenario analysis and predictive modeling
• Automate tasks in Excel using Visual Basic for Applications (VBA) to enhance productivity

Introduction to Advanced Excel Features 

• Overview of advanced features in Excel 
• Setting up Excel for advanced data analysis 

Advanced Data Modeling 

• Principles of data modeling 
• Creating and managing data models in Excel 

Power Query 

• Importing and transforming data using Power Query 
• Merging and shaping data from multiple sources 

Power Pivot 

• Creating and managing data models with Power Pivot 
• Using DAX (Data Analysis Expressions) for complex calculations 

Advanced Functions and Formulas 

• Utilizing advanced Excel functions  
• Leveraging logical and statistical functions for in-depth analysis 

Data Visualization 

• Advanced charting techniques 
• Creating interactive dashboards using PivotTables and PivotCharts 

Scenario and What-If Analysis 

• Conducting sensitivity analysis using Data Tables, Scenario Manager, and Goal Seek 
• Building and analyzing complex scenarios 

Introduction to VBA for Automation 

• Basics of VBA programming 
• Automating repetitive tasks with VBA 

This course is suitable for a wide range of professionals, including the following:

• Business Analysts
• Finance professionals
• Data Analysts and Professionals
• Administrators with a need to improve data management techniques
• Researchers and Academics
• Monitoring and Evaluation professionals

The Advanced Data Modelling and Analytics Using Excel Training Course is delivered by our seasoned trainers who have vast experience as expert professionals in their respective fields of practice. The course employs a mix of methodologies including presentations, group exercises, case studies, and much more. Group work is an essential component of the course. The course is designed to be primarily workshop-based, in which participants can work through tasks and problems that mimic their daily activities. Instructors are there to facilitate the group work, addressing real-world concerns.

At Virgon Africa, we believe in experiential learning. We value active participation in our courses through sharing experiences, ideas and practices.