Why Attend This Training Course?

With the basic knowledge of Excel and a love for analysis, you will learn how this tool combined with advanced techniques can help you build analytics systems, data pipelines and interactive reports for stakeholder analysis.

What Is The Training Course Methodology?

This training course methodology depends on enabling participants to interact and exchange experiences, explore their competencies and achieve their career aspirations, using forward-thinking training arts, such as theoretical lectures and/or open discussion to exchange opinions and experiences, scenarios, innovative thinking brainstorming. Participants will receive an agenda including training material as a reference, in addition to some extra notes and booklets. 

Who Should Attend This Training Course?

This training course is designed for those who use Excel on a regular basis and want to further their knowledge of how to produce more robust spreadsheets, the course covers the more advanced features of Excel.

What Are The Training Course Objectives?

What Is The Training Course Curriculum?

Module One: Advanced Listing Techniques

• Tricks in creating dependent lists

• Dynamic selection tips

• Dynamic extraction of unique values

Module Two: Facilitating Calculations

• Dynamic and expandable named ranges

• Multi-nested functions / expandable referencing

• Structured table references / table nomenclature

• Aggregate calculation using the ‘wildcard’ technique

Module Three: Key Functions

• DSUM / SUMPRODUCT / SUMIFS (and building conditions)

• Advanced uses of: OFFSET / CHOOSE / INDEX / MATCH

• ROWS

• INDIRECT

Module Four: Further Advanced Techniques For Summarizing And Presenting Data

• Mini pivot table reports

• Fast calculations with data tables

• Data modelling with scenario manager

• Histogram and Pareto Charts

Module Five: Excel Dashboards (Extracts)

• Creative charting techniques

• Building a visual analysis

• Tips and tricks in custom formatting