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?
Many of us struggle with the vast amount of data currently available, finding that the structure of the reports we build to present this data limits their use. This course will provide hands-on techniques to help you create spreadsheets which are dynamic and expandable, enabling you to benefit from using functions including structured references, dynamic listing techniques and scenario modelling.
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
Module Three: Key Functions
Dynamic and expandable named ranges
Multi-nested functions / expandable referencing
Structured table references / table nomenclature
Aggregate calculation using the ‘wildcard’ technique
Module Four: Further Advanced Techniques For Summarizing And Presenting Data
DSUM / SUMPRODUCT / SUMIFS (and building conditions)
Advanced uses of: OFFSET / CHOOSE / INDEX / MATCH
ROWS
INDIRECT
Module Five: Excel Dashboards (Extracts)
Mini pivot table reports
Fast calculations with data tables
Data modelling with scenario manager
Histogram and Pareto Charts
Creative charting techniques
Building a visual analysis
Tips and tricks in custom formatting
Hands-on Tasks:
Bring your own laptop to run and follow up the exercises and tasks provided by the instructor. To be sure that you can perform all tasks, the most recent version of MS Office is required. The outline and hands-on tasks can be customized to fit the version you use in your company.
قدم الآن
25 - 29 فبراير
القاهرة
$1500
