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

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.

Download written guide

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:

Useful Excel shortcuts

Useful Excel functions

Summary measures in Excel

Pivot tables Introduction

Checking normality in Excel

Calculating Normal probabilities in Excel

Calculating Confidence interval for the mean in Excel

Drawing a mean plot with error bars in Excel

Paired t-test in Excel

Unpaired t-test in Excel

One-way ANOVA in Excel

Scatterplots, correlation and simple linear regression in Excel