Home

PDF Ebook Microsoft Excel 2007™

Submitted by antoq on Tue, 08/18/2009 - 07:20

Microsoft Excel 2007™ is an electronic spreadsheet software package that allows you to organize data in a tabular format, perform mathematical calculations, and analyze data. This software includes functions, formulas, and charts. It is commonly used in business, engineering, mathematics, and statistics. This tutorial covers the basic functionality of the software.

The MS Excel 2007 interface brings out all the functionality of the software using tabs rather than drop-down menus. The main work area is called a spreadsheet where you can communicate your data using functions, formulas, and charts. The highlighted cell is called the active cell and is the current place where you can enter a value or a formula. We will describe the parts of the interface in the following sections.

Contents
Starting MS Excel
The MS Excel Window
Title Bar
Office Button

    Saving Your Work
      For the first time
      While you work
      Backing up your work

    MS Excel 1997-2003 File Format Compatibility

Printing

Quick Access Bar
Status Bar
What are Spreadsheets?
Cell References: Rows and Columns
Working With Data

    Text
    Number
    Boolean
    Date and Time
    Formula
      Constants
      Mathematical Operators
      Cell References and Cell Ranges
      Functions
      Creating Formulas
      Calculating with Functions
      The IF function
      Copy (Cut), and Paste
        Copy/Paste with AutoFill
        Relative Addressing
        Absolute Addressing

Ribbons
Home Ribbon

    Text Formatting
    Number Formatting
    Sorting
    Cell Formatting

Insert Ribbon
Illustrations
Charts

Download
PDF Ebook Microsoft Excel 2007™

»

Posted in :