Data Analysis with Excel – Advanced
This advanced Excel training course will help you gain the skills to effectively manage and present data, create dynamic and flexible reports and use advanced Excel features such as structured referencing, scenario modelling and search techniques. The course is designed for financial professionals, analysts, managers and advanced Excel users who want to increase their competence in working with data.
Why should you attend this course?
- You will learn how to manage and present data effectively, which will help you overcome the difficulties of information overload.
- You will gain practical skills that will enable you to create dynamic and flexible reports with greater usability.
- You will learn how to use advanced techniques in Excel such as structured referencing, dynamic listing and scenario modelling.
- You will discover and learn how to apply lesser-known but powerful Excel functions, which will increase your efficiency when working with data.
Language of the course
English
Training level
advanced
Who is this course for?
- For finance professionals who want to deepen their knowledge of advanced Excel functions.
- For data analysts who regularly use Excel and want to create more reliable spreadsheets.
- For spreadsheet authors who want to increase the efficiency of their work.
- For advanced Excel users looking for new techniques and features.
- For financial managers and decision makers who want to better manage financial data and analysis.
- For financial controllers and junior accountants who want to increase their competence in working with Excel.
- For those who have completed our training course Data Analysis in Excel - intermediate level.
What will you learn during the course?
- You will learn to maintain dynamic and extensible datasets, minimising the need for future maintenance.
- You will master advanced techniques for creating lists and dependent dynamic lists.
- You will learn how to effectively extract unique values and facilitate computation.
- You will learn methods for working with dynamic and extensible named ranges and structured table references.
- You will gain skills in using key Excel functions such as DSUM, SUMPRODUCT, SUMIFS, and advanced search and data modelling techniques.
- You will learn to create mini pivot table reports and use advanced data summarisation and presentation techniques.
- You will gain knowledge of techniques for building interactive dashboards and simple VBA exercises to speed up your work processes.
- You will learn practical tips and tricks for custom formatting in Excel.
Additional information
- In order to use the course effectively, it is necessary, in addition to viewing the online training, to have Excel turned on. To do this, we recommend using a second screen or an additional device to avoid constantly switching between windows.
- The course is based on Excel for Windows, it is recommended to use version 2010 or later.
- MAC users are welcome to attend the course, but some features may differ from the Windows version. The instructor will adapt the course content to the MAC version during the course if there are MAC users attending the training.
„The presenter was very good, gave good examples and was very communicative. He is able to explain everything in a simple way.”
From a feedback form on tailored training provided in 2023.5,57/6
Average evaluation of tutors and training materials among participants of workshops for companies organized in 2023-2024.„Training delivered in an understandable manner and at the right pace.”
From a feedback form on tailored training provided in 2024.97%
of all participants of the 2023-2024 tailored workshops for companies would recommend our training to their friends!
Open courses
Our open courses are short courses taught by experienced tutors whose role is to give you practical knowledge and skills that you can use immediately in your daily work.
It's a great opportunity to expand your knowledge and enhance your skills, whether you're motivated by an internal desire to develop or by your employer.
Bespoke programmes for companies
Does your team need training on this topic? Or, would your organization benefit from additional focus on specific issues in the course program, allowing some elements to be explored in greater depth?
With bespoke programs, we can adjust the training content to meet your organization’s specific needs. This includes adding topics not covered in the standard program or omitting sections less relevant to your team. The final cost of customized training is set individually at the proposal stage.
Related courses
Data Analysis with Excel - Intermediate
Find out more
Power BI - An Essential Toolkit
Find out more
Technical Skills for Finance Professionals - a package of 25 Knowledge Bits
Find out more