The goal of this course is to provide you with the knowledge required to use more advanced formulas and work with various tools to analyse data in spreadsheets, such as advanced sorting and filtering, and conditional formatting. You will also organise table data and present data as charts.
The course emphasises hands-on experience, with a series of self-guided exercises integrated into the training.
This course is aimed at existing Excel users who need to further their knowledge. Delegates are assumed to have experience of entering data and writing basic formulas, including common functions such as SUM and AVERAGE.
Module 1: Formula tools and techniques
Module 2: Popular Excel functions
Module 3: Working with data lists
Module 4: Mastering Excel tables
Module 5: Charts
Module 6: Additional features
Module 7: Conditional formatting
*IFS, XLOOKUP, UNIQUE, SORT AND FILTER functions are only available if you are using Office 365 or Excel 2021
Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.