Microsoft Excel is a spreadsheet programme with extensive functionality for data management, analysis and visualisation. It is used widely across all quantitative academic disciplines and professional services.
All University of Bath users can access Excel via the institutional Office 365 subcription. It is available on all University computers and can be installed on your own device: https://www.bath.ac.uk/guides/download-and-install-microsoft-office-on-your-personal-device/
The University of Bath offers training workshops on Microscoft Excel for staff and postgraduate students.
Please note that O'Reilly deletes content in December and June. If you are linking to courses on this platform we advise that you check that they are still running in January and July of each year.
These courses are suitable for those who are new to using Microsoft Excel but may also be useful for those with a basic working knowledge who can dip in to the courses past the 'getting started' videos.
This video course is suitable for those who are completely new to Excel but might also be useful to those with a very basic working knowledge. Note that this course is using Excel 2019 whilst the University provides the Office 365 version of Excel. This means that the layout on screen might be different to the layout on the video. The course covers:
In this course, you will learn how to efficiently manage and analyze data using Microsoft Excel. Here's what the course covers:
This course will help you grasp all the essential and advanced skills for Microsoft Excel 2019 with the help of interesting activities. Note that this course is using Excel 2019 whilst the University provides the Office 365 version of Excel. This means that the layout on screen might be different to the layout on the video. The course covers:
In this course, you will learn how to create powerful Excel formulas and functions to enhance your data analysis skills. Here's what the course covers:
These courses are suitable for those with a working knowledge of Microsoft Excel. As they are video courses you can dip in and out of any of these to learn specific skills, or take the entire course to extend your skills in Excel.
In this course, you will learn how to effectively manage and analyze data in Excel. Here's what the course covers:
This course assumes a basic working knowledge of Excel and provides a wide range of tips to improve your Excel skills. The course covers:
Mastering advanced Excel formulas and functions can significantly boost your efficiency and productivity. Here's what the course covers:
This course assumes a good working knowledge of using Excel and introduces Visual Basic for Applications (VBA) for Excel. The course covers: