This is our 1 day Microsoft Excel Advanced course focusing on how to validate and summarise data. If you already have a good level of Excel skills or if you have previously attended our Excel Intermediate course, then this training session will show you how to manipulate and analyse larger sets of data.
During this course you’ll work through examples of how to create dropdown boxes for lists and protect areas of a spreadsheet, cleanse data with functions, summarise data including using advanced filters and PivotTables and charts, import data from various sources such as databases or a website ready to manipulate in Excel, record and run simple macros effectively and more.
By the end of the session you will be comfortable at transforming data in Excel through a number of advanced techniques that will support you in your daily working situation.
This course is designed for those who already have a good level of Excel skills or may have previously attended our Excel Intermediate course.