Microsoft Excel 2010

                                                                                                  Bridegroom Killed During Wedding

Microsoft Excel 2010

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 in numerous 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 has commands to adjust page such as margins, orientation and themes.

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 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 document including freezing or splitting panes, viewing gridlines and hide cells.

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 not follow the steps below: 

• Click on the Start button 

• Highlight Programs 

• Highlight Microsoft Office 

• Click on Microsoft Excel 2010

Free Online Marketing Tips!!! Just Click!

Create a New Workbook

• Click the File tab and then click New.
•  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 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:

·         To reuse a template that you’ve recently used, click Recent Templates, click the template that you want, and then click Create.

·         To use your own template that you already have installed, click My Templates, select the template that you want, and then click OK.

·         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.

·         Once you click on the template you like it will open on your screen as a new document.

Enter Data in a Worksheet

• Click the cell where you want to enter data.
• Type the data in the cell.
• Press enter or tab to move to the next cell.

To select	Do this
A single cell	Click the cell, or press the arrow keys to move to the cell.
A range of cells	Click the first cell in the range, and then drag to the last cell, or hold down SHIFT while you press the arrow keys to extend the selection.
A large range of cells	Click the first cell in the range, and then hold down SHIFT while you click the last cell in the range. You can scroll to make the last cell visible.

All cells on a worksheet 

Click the Select All button or press CTRL+A.

Nonadjacent cells or cell ranges

Select the first cell or range of cells, and then hold down CTRL while you select the other cells or ranges. 

NOTE: You cannot cancel the selection of a cell or range of cells in a nonadjacent selection without canceling the entire selection.

An entire row or column

Click the row or column heading. 

1. Row heading

2. Column heading

Adjacent rows or columns

Drag across the row or column headings. Or select the first row or column; then hold down SHIFT while you select the last row or column.

Nonadjacent rows or columns

Click the column or row heading of the first row or column in your selection; then hold down CTRL while you click the column or row headings of other rows or columns that you want to add to the selection.

Cells to the last used cell on the worksheet (lower-right corner)

Select the first cell, and then press CTRL+SHIFT+END to extend the selection of cells to the last used cell on the worksheet (lower-right corner).

NOTE: To cancel a selection of cells, click any cell on the worksheet. This is not applicable to cells with formulas in it.