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. 

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

Excel Essential Training (Microsoft 365) (2.5 hours)

In this course, you will learn how to efficiently manage and analyze data using Microsoft Excel. Here's what the course covers:
 

  • Describing the process for adding a command to the Quick Access toolbar
  • Citing shortcuts for Undo and Redo
  • Naming keys commonly used to move, copy, and insert data
  • Explaining how to create a chart
  • Summarizing the process for freezing and unfreezing panes

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

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: 

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

 

Excel: Introduction to Formulas and Functions (2 hours)

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:

  • Creating and editing formulas with mathematical operations
  • Summarizing data using functions like SUM and AVERAGE
  • Managing named ranges and Excel tables for efficient data organization
  • Handling data using text functions and data validation rules
  • Auditing worksheet formulas to ensure accuracy and troubleshoot errors

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: Managing and Analyzing Data (3.75 hours)

In this course, you will learn how to effectively manage and analyze data in Excel. Here's what the course covers:

  • Checking data quality and using functions like UNIQUE and PivotTables
  • Splitting columns for data clean-up using tools like Flash Fill and Power Query
  • Data preparation techniques, including structuring data for optimal usage and using Excel's Tables
  • Working with multiple data sets through functions like VLOOKUP and XLOOKUP
  • Sorting and filtering data using various criteria and tools like Dynamic Arrays and Power Query

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: Advanced Formulas and Functions (5.25 hours)

Mastering advanced Excel formulas and functions can significantly boost your efficiency and productivity. Here's what the course covers:

  • How to use Tables and Dynamic Arrays for Data Integrity and Consistency
  • The World of IF Statements and Conditions, including SUMIFS, COUNTIFS, MAXIFS, MINIFS, and AVERAGEIFS
  • Looking Up, Down, and All Around: Comparing and Combining with Lookups like VLOOKUP, XLOOKUP, and INDEX/MATCH
  • Formula Tips and Strategies for building complex formulas and writing formulas for future use
  • Working with Text and Arrays, Statistical Functions, Math Functions, and exploring New, Handy, and Fun Functions

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