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.
There are over 70 courses on O'Reilly Learning on using Excel. You can search for more courses and resources for learning Excel on O'Reilly Learning. Enter 'Excel' into the search bar on the home page. We recommend that you filter the results:
If you cannot see 'Learning Path' and 'Video' as an option under the Format filter you should delete the site cookies and refresh the page.
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:
TThis 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:
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.
This course assumes a basic working knowledge of Excel and provides a wide range of tips to improve your Excel skills. 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: