Excel 2010 Tutorial

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 program features.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 Tab This tab hascommands 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 worksheets with largeamounts 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 document including freezing orsplitting 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 Word will open. If notfollow 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 Workbook 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 a variety of templates onOffice.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, select the template that you want, and thenclick 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 Worksheet 1. Click the cell where you want to enter data. 2. Type the datain 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 understand the options. To select A single cell A...