Excel resources
Videos and downloadable resources to help all users get to grips with Microsoft Excel.
First steps in Excel
- Opening Excel for the first time
-
An introduction to Excel spreadsheets for people who have never opened a spreadsheet before.
Includes:
- Opening a new spreadsheet or an existing one
- Entering information into cells
- Saving a spreadsheet
- Resizing rows and columns
- Wrapping text
- Beginning to use Excel
-
This video includes
- Editing cell content
- Inserting/deleting columns
- Numbers/text in cells
- Copying & pasting cells
- Open a new tab
- Copying a sequence with auto-fill
- Changing decimal places
- Accessing the format cells menu
- Calculations and functions
-
A first introduction to doing calculations in Excel, including:
- Using Excel as a calculator
- Using a formula referencing other cells
- Using a built-in function in Excel
- Enabling the ToolPak for data analysis
-
Instructions for how to enable the ToolPak in Excel.
- Filtering in Excel
-
Instructions for how to use the "filter" tool in Excel.
- Freezing panes in Excel
-
Instructions for how to freeze panes in Excel.
- Sorting in Excel
-
Instructions for how to sort data in ascending or descending order in Excel.
- Transposing data in Excel
-
Instructions for how to transpose data (swap rows and columns) Excel.
- Making histograms in Excel (without the ToolPak)
-
How to make a histogram quickly in Excel.
- Making histograms in Excel (with the ToolPak)
-
How to make a histogram using the Excel ToolPak.
- Making scatter graphs in Excel (without the ToolPak)
-
How to make a histogram using the Excel ToolPak.
Excel resources
Physical copies of these resources are available in the carousels in the MASH workspace.
List of useful shortcuts for Excel.
List of useful functions in Excel.
Describes how Excel can be used to summarise data using both basic summary measures and charts.
Introduction to the use of pivot tables in Excel.
Describes how to undertake an independent t-test in Excel.
Describes how to check normality for a set of data in Excel.
Describes how to construct a scatterplot and calculate a correlation coefficient between two variables in Excel.
Introduction to the Excel add-in: Analysis ToolPak.
Describes how to draw a histogram in Excel.
Excel worksheets
Using Excel functions to calculate some of the basic summary measures such as mean, median, range, and standard deviation.
Using the normal probability functions in Excel to calculate probabilities for the normal distribution.
Confidence interval for the mean
Using the functions in Excel to calculate the confidence interval for the mean.
Drawing a histogram in Excel.
Drawing a mean plot with error bars
Using Excel to draw a mean plot with error bars.
How to undertake a paired t-test in Excel and interpret the results.
How to undertake an unpaired t-test in Excel and interpret the results.
How to use the Analysis ToolPak in Excel to undertake a one-way ANOVA and interpret the results.
Scatterplots, correlation and simple linear regression
How to draw a scatterplot, calculate a correlation coefficient and undertake a simple linear regression in Excel.

Book a 1:1 appointment or workshop
Would you like to explore a maths or stats topic in greater depth? Why not book a 1:1 with an advisor or a workshop (current students only).