Learn Free MS Excel2007
Introduction:
A spreadsheet looks a lot like a table you might see in a word processing package,but it has some very important features that most tables do not. Firstly, spreadsheets are designed to make repetitive and/or complicated calculations very easy to carry out. Secondly, most spreadsheet programs have advanced graphing capabilities that make producing graphs from the data in the spreadsheet relatively simple.In Ms Excel each document is referred to as a workbook. Within each workbook you can have multiple spreadsheets; Excel refers to these as sheets.
Ms Excel:
The default Excel is three sheets, but you can add as many sheets as necessary. At any given time, only one sheet is active in your work book. It is important to note that most page formatting options apply only to the sheet you are working with
(for example,margins, headers and footers). Additionally, when you print, by default Excel will print only the sheet that is active.
Feature Excel 2007
features some radical changes to Excel commands organization. The drop down menus so many of us are familiar with have been replaced by the Ribbon.When Excel is first launched you will usually see the window pictured in Figure 1.This window shows the Home Ribbon. Excel commands are organized into groups and the groups are organized into ribbons. For example, on the Home Ribbon (Figure 1) there are seven groups; Clipboard, Font, Alignment, Number, Styles,Cells, Editing. Ribbons are accessed by clicking one of seven tabs; Home, Insert,Page Layout, Formulas, Data, Review, or View. We will not cover all the tabs in this tutorial but instead will focus on finding the commands you will need to do basic data analysis and graphing. I will direct you to the location of a command using the
shorthand Home > Font to indicate “look on the Home Ribbon in the Font group”.