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