04/05/2007 3:02:00 PM Z:\SCF\SFG ClearCF Only\Handouts and Howtos\tutorials\excel-tutorial\Excel-2007\excel-handout-2007.doc TM
1
Microsoft Excel 2007
Excel is Microsoft’s Spreadsheet program. Spreadsheets are often used as a method of displaying
and manipulating groups of data in an effective manner. It was originally created for accounting.
Excel is useful when you have a very large set of data and need to perform the same operation on
each Series / Set of it. It is well suited to tasks such as sorting, alphabetizing, adding 2 columns
together, and performing more complex mathematical functions on data.
Things to Note - Data types and Formula syntax
General Tip
- Do not worry about having to start from Cell A1. You can start wherever you like as
long as your data is in a solid block of adjacent cells. When you print, you can select a specific set of
cells so that empty cells are not printed.
Data Types
- There are four different types of data that can be entered into a cell; they are: text,
numbers, formulas and functions. These data are entered using the Formula Bar at the top of the
screen but you’ll notice that what you ente
r into the Formula Bar and what shows up in the Cell may
be two different things - especially when it comes to formulas and functions.
** If the Formula Bar is not visible, turn it on by going under View >> Formula Bar
Formula Syntax
- It is very important to make sure that, when working with formulas, you have the
correct syntax. Excel has its own mathematical syntax and, if this is used improperly, you will not get
the correct results from you functions and formulas. Excel will only check for logic errors.
Different versions of Excel and different installations on computers may have all kinds of shortcuts
added, or even removed. For consistency’s sake, we’ll use the
Ribbon Tabs
to explain how to
complete various tasks.
Microsoft Interactive Online Demos
Microsoft has developed a series of online demo programs to assist people with the transition to
Office 2007.
Start the Guide
for a program by clicking on that phrase on the webpage listed below
A new window will open in your web browser showing Office 2003
Use the familiar Toolbar from Office 2003 to find a Tool
A second window will appear to show you how to use the same Tool in Office 2007
The web address for the Excel Guide is:
http://office.microsoft.com/en-us/excel/HA101491511033.aspx

This
** preview**
has intentionally

**sections.**

*blurred***to view the full version.**

*Sign up*