Skip to Main Content
library logo banner

Research Software Learning Online: Microsoft Excel

Accessing Microsoft Excel

Excel ChartMicrosoft 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. 

Searching for more courses on Excel

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: 

  • use the 'Format' filter to filter by resource type: courses are listed as 'Learning Path' or 'Video'
  • use the 'Topic' filter to filter for courses specifically on Excel 

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. 

Getting started courses

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. 


Microsoft Excel Beginners 2019 (7.5 hours)

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: 

  • Introduction to ExcelExcel beginners 2019
  • Creating and saving workbooks
  • Page setup 
  • Working with rows, columns and cells
  • Moving data
  • Formulas and functions
  • Working with sheets
  • Formatting workbooks
  • Creating charts
  • Sorting and filtering
  • Outlining and subtotaling
  • Working with views
  • Linking files
  • Advanced formula creation
  • Pivot tables
  • Shortcuts

The Complete Excel Guide: Beginners to Advanced (15.5 hours)

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: 

  • Gain a solid understanding of Microsoft Excel 2019
  • Techniques and shortcuts to make your job easy
  • Learn how to create charts and graphs

 

Intermediate and advanced courses

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. 


Excel Pro Tips: 75+ Tips to go from Excel Beginner to Pro (10.5 hours)

This course assumes a basic working knowledge of Excel and provides a wide range of tips to improve your Excel skills. The course covers: 

  • Productivity tipsExcel Pro Tips
  • Formatting tips
  • Formula tips
  • Visualisation tips
  • Pivot table tips
  • Analytics tips

Excel VBA Programming – The Complete Guide (17.5 hours)

This course assumes a good working knowledge of using Excel and introduces Visual Basic for Applications (VBA) for Excel. The course covers: 

  • Getting started with VBAExcel VBA programming
  • The Excel Object Model
  • Visual Basic Editor
  • Objects and methods
  • Variables and data types
  • Procedures (loops, arguments)
  • Object deep dive
  • Range references
  • Range actions
  • Conditional statements
  • Iteration
  • Using arrays
  • VBA functions
  • Debugging
  • Events
  • Creating user forms