Excel resources

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.

Excel shortcuts

List of useful shortcuts for Excel.

Excel functions

List of useful functions in Excel.

Summarising data

Describes how Excel can be used to summarise data using both basic summary measures and charts.

Pivot tables

Introduction to the use of pivot tables in Excel.

Independent t-test

Describes how to undertake an independent t-test in Excel.

Checking normality

Describes how to check normality for a set of data in Excel.

Scatterplots and correlation

Describes how to construct a scatterplot and calculate a correlation coefficient between two variables in Excel.

Analysis ToolPak

Introduction to the Excel add-in: Analysis ToolPak.

Histograms

Describes how to draw a histogram in Excel.

Excel worksheets

Summary measures in Excel

Using Excel functions to calculate some of the basic summary measures such as mean, median, range, and standard deviation.

Normal probabilities

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

Drawing a histogram in Excel.

Drawing a mean plot with error bars

Using Excel to draw a mean plot with error bars.

Paired t-test

How to undertake a paired t-test in Excel and interpret the results.

Unpaired t-test

How to undertake an unpaired t-test in Excel and interpret the results.

One-way ANOVA

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.