This 1 day course will introduce attendees to a number of ways of interpretating data using the features of Excel. You will explore a range of data analysis functions that can be used to extrapolate meaningful information from a large data set. The course will begin by introducing functions that are useful to clean data sets prior to manipulation. Our tutor will explore a range of functions and tools that exist within Excel to assist in the collection of meaningful information. This course is suitable for those with an intermediate level knowledge of Excel. It is not suitable for those with no knowledge of Excel. The course is suitable for those using Microsoft Office 2016 or above. Course Content: • Discover ways to clean and transform data prior to analysis • Learn how to highlight information with Conditional Formatting • Use a range of functions and tools to extract meaningful information • Become familiar with useful methods of summarising and analysing large data sets • Explore ways in which you can filter data to extract information On completion of this course participants will have gained the foundational skills required to effectively manage, analyse, and visualise data using Microsoft Excel. They will be better equipped to make informed decisions based on data insights, making them valuable assets in data-driven environments.