Excel 2010

1

Microsoft Excel 2010 Tutorial
Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of
spreadsheets) in order to analyze data and make more informed business decisions. Specifically, you can use Excel to track data, build
models for analyzing data, write formulas to perform calculations on that data, pivot the data innumerous ways, and present data in a variety
of professional looking charts.

The Ribbon
Understanding the Ribbon is a great way to help understand the changes between Microsoft 2003 to Microsoft 2010. The ribbon holds all of
the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense
variety of programfeatures.
Home Tab
This is the most used tab; it incorporates all text and cell formatting features such as font and paragraph changes. The Home Tab also
includes basic spreadsheet formatting elements such as text wrap, merging cells and cell style.

Insert Tab
This tab allows you to insert a variety of items into a document from pictures, clip art, and headers and footers.

Page Layout TabThis tab has commands to adjust page such as margins, orientation and themes.

Created By: Amy Beauchemin

Source: office.microsoft.com

1/13/11

2
Formulas Tab
This tab has commands to use when creating Formulas. This tab holds an immense function library which can assist when creating any
formula or function in your spreadsheet.

Data Tab
This tab allows you to modifying worksheetswith large amounts of data by sorting and filtering as well as analyzing and grouping data.

Review Tab
This tab allows you to correct spelling and grammar issues as well as set up security protections. It also provides the track changes and
notes feature providing the ability to make notes and changes someone’s document.

View Tab
This tab allows you to change the view of your documentincluding freezing or splitting panes, viewing gridlines and hide cells.

Created By: Amy Beauchemin

Source: office.microsoft.com

1/13/11

3

Getting Started
Now that you have an understanding of where things are located, let’s look at the steps needed to create
an Excel document.
Opening Outlook
You may have a shortcut to Word on your desktop, if so double click the icon and Wordwill open. If not
follow the steps below:
1. Click on the Start button
2. Highlight Programs
3. Highlight Microsoft Office
4. Click on Microsoft Excel 2010

Create a New W orkbook
1. Click the File tab and then click New.
2. Under Available Templates, double click Blank Workbook or Click Create.
Find and Apply Template
Excel 2010 allows you to apply built-in templates and to search from avariety of templates on
Office.com. To find a template in Excel 2010, do the following:
1. On the File tab, click New.
2. Under Available Templates, do one of the following:
a. To reuse a template that you’ve recently used, click Recent Templates, click the template
that you want, and then click Create.
b. To use your own template that you already have installed, click My Templates, selectthe
template that you want, and then click OK.
c. To find a template on Office.com, under Office.com Templates, click a template category,
select the template that you want, and then click Download to download the template from
Office.com to your computer.
3. Once you click on the template you like it will open on your screen as a new document.
Enter Data in a W orksheet
1. Click the cellwhere you want to enter data.
2. Type the data in the cell.
3. Press enter or tab to move to the next cell.

Created By: Amy Beauchemin

Source: office.microsoft.com

1/13/11

4
Select Cells or Ranges
In order to complete more advanced processes in Excel you need to be able to highlight or select cells,
rows and columns. There are a variety of way to do this, see the table below to...