This intermediate workshop will continue building on the beginner workshop and is designed for those who want to take their Excel knowledge to the next level. A solid knowledge in basic Excel functions will act as a strong foundation, as you will expand your knowledge with the use and application of Data Validation, Pivot Tables, Table and Lookup functions. Beyond the application of these functions, this training will also include basic theoretical perspectives on information management, enabling you to manage large datasets and to harness the power of Excel functionality.
Learning objectives
The overall learning objectives for this workshop will include:
- Learning the most common Microsoft Excel functions used in data analysis
- Maintaining large sets of Excel data in lists or tables
- Building a solid understanding on the basics of Microsoft Excel
- Establishing foundational knowledge of formula syntax and its functionality
- Knowing how to format data in an excel sheet using borders, font and cell colours, and conditional formatting
- Using Images, Shapes and Charts to visualise data
- Managing Lists and Tables
- Use of Pivot Tables
- Comfort with the use of conditional and lookup functions
Who Should Attend?
The workshop will be available to anyone with an interest in establishing a foundational knowledge of Excel. It will cater for individuals who do not use Excel regularly and are not familiar with the full functionality of the application.
Registration fee
Click on Register to confirm your place.
- Price for this session: Eur95
Facilitators