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
- 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.
- Enabling the ToolPak for data analysis
-
Instructions for how to enable the ToolPak 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.
Drawing a histogram in Excel with the ToolPak
- Making scatter graphs in Excel (without the ToolPak)
-
How to make a histogram using the Excel ToolPak.
Excel resources
Use these links to download written guides:
Calculating Normal probabilities in Excel
Calculating Confidence interval for the mean in Excel
Drawing a mean plot with error bars in Excel
Scatterplots, correlation and 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).