Skip to main content Rasmussen University
Rasmussen University Online Library

Excel Help Guide

Use this guide as you navigate the wealth of Microsoft Excel supports available to you at no additional cost.

Getting Started in Excel

Save time by using shortcuts in Excel:

Ctrl+Z

Undo

Ctrl+Home

Move to cell A1

Ctrl+End

Move to last cell in range

Alt+Enter

Start a new line in the same cell

Ctrl+;

Enter date

Ctrl+ (backtick)

Alternate between formula view and cell view

F2

Glance at the cells

View the video below to learn more about working with sheets in Excel, and access the corresponding SkillSurfer content by clicking on the related hyperlinks at the bottom of the page. Having trouble accessing SkillSurfer content? Make sure you are logged into the Student Portal or one of your online courses.

Visit SkillSurfer for additional, step-by-step written tutorial content on:

Having trouble accessing this content? Make sure you are logged into the Student Portal or one of your online courses.

View the videos below for help with formatting an Excel worksheet, and access the corresponding SkillSurfer content by clicking on the related hyperlinks. Having trouble accessing SkillSurfer content? Make sure you are logged into the Student Portal or one of your online courses.

SkillSurfer text-based tutorial content on formatting and editing data

SkillSurfer text-based tutorial content on numeric formatting

SkillSurfer text-based tutorial content on headers and footers

View the videos below to learn more about performing calculations using Excel, and access the corresponding SkillSurfer content by clicking on the related hyperlinks. Having trouble accessing SkillSurfer content? Make sure you are logged into the Student Portal or one of your online courses.

SkillSurfer text-based tutorial content on: Order of operations and Entering formulas

View the video below for a demonstration of how to create a VLookUp to search for specific information within an Excel spreadsheet.

Pivot tables allow you to analyze data in a spreadsheet in different and useful ways. The video below gives a quick overview of how to create a pivot table in Microsoft Excel.

SkillSurfer text-based tutorial content on pivot tables