Use of excel

From WikiEducator
Jump to: navigation, search



Microsoft Excel is a spreadsheet program that is used to store, sort and efficiently crunch numbers. Accountants use Excel to keep track of transactions for their company. Students might use Excel to help draw conclusions from the data they gathered on a science project. No matter what you are using Excel for it is important that you have the basic knowledge required to do the everyday operations you will encounter while using this program.

Microsoft Excel


Software developed and manufactured by Microsoft Corporation that allows users to organize, format, and calculate data with formulas using a spreadsheet system broken up by rows and columns. Microsoft Excel usually comes bundled with Microsoft Office and is compatible with other applications offered in the suite of products. The first software program similar to Excel was released in 1982 and was called Multiplan.

How to use Excel

How to Use Excel is a Series of Excel Tutorials designed with the absolute beginner in mind. These tutorials will show you how to use Excel to produce a complete spreadsheet. The tutorials cover:

Parts of the Excel Screen

This article identifies the main parts of the Excel spreadsheet work area. There are links from each label to glossary items describing each part in greater detail. Entering Data in Excel

This article covers the basics of how to enter data into an Excel spreadsheet. Items such as the importance of planning your spreadsheet before you enter data, widening columns, the types of data that can be entered, and editing cells to change data, are covered in this tutorial. Basic Excel 2003 Spreadsheet Tutorial

The tutorial, as the name suggests, shows you how to create a basic spreadsheet in Excel 2003. Topics covered include entering data, creating simple formulas, and formatting a worksheet.

Excel Math

These articles cover how to carry out basic math operations in Microsoft Excel. If you want to know how to add, subtract, multiply, or divide numbers in Excel, these articles will show you how.

Excel Formulas Step by Step Tutorial

Formulas are a very important and a frequently used feature in Excel. This article uses a step by step example to show you how to create and use formulas in Excel.

SUM and AutoSUM Step by Step Tutorial

This step by step tutorial walks through how to use Excel's SUM function and the AutoSUM feature to perform spreadsheet calculations. How to Use the Excel's Date Function

There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This article covers the most commonly used date functions used in Excel.

  • Entering Data in Excel

This tutorial covers basic information for entering data into an Excel spreadsheet. Click on the links below to read specific information.

  1. Plan your spreadsheet - Before you start to type
  2. How to Enter Data into a Spreadsheet - Doing the Excel three - step
  3. Cells and cell references in Excel - Keeping track of where your data is going
  4. Using AutoComplete to Enter Data - Getting help from Excel
  5. Types of data in Excel - Labels, values and other data types
  6. Getting around your spreadsheet quickly - Shortcut keys
  7. Editing data in a cell - Updating data and fixing those mistakes

1) Why Use Formulas in Excel? Excel formulas are one of the most useful features of the program. Formulas can be as simple as adding two numbers or can be complex calculations needed for high end business projections. Once you learn the basic format of creating a formula, Excel does all the calculations for you.

2) Basic Excel 2010 Spreadsheet Tutorial This step by step tutorial shows you the steps for writing basic formulas in Excel 2010. The topics include using cell references, pointing to create formulas and how to copy formulas using the fill handle.

3) Excel 2007 Step by Step Formula Tutorial This step by step tutorial shows you the steps for writing basic formulas in Excel 2007. The topics include using cell references and pointing to create formulas.

4) Using Formulas in Excel 2003 This step by step tutorial shows you the steps for writing basic formulas, using cell references and pointing to create formulas, how to use formula operators and to edit the data in formulas.

5) Excel 2010 SUM Function Tutorial The Excel SUM function is probably the most often used function in Excel spreadsheets. This tutorial covers how to use the SUM function in Excel 2010.

6) Excel 2007 SUM Function Tutorial This tutorial covers how to use the SUM function in Excel 2007.

7) IF Function Step by Step Tutorial One of the most useful functions in Excel is the IF function. The IF function works by testing to see if a certain condition is true. If it is, the function enters one result in a specific cell, if it is not, it enters a different result in that cell.

8) "What If" Questions in Excel "What if" questions involve changing the data used in Excel formulas to give different answers. Asking "What if" questions is very useful in business when planning new projects. Cost projections for different scenarios can be quickly created and the results compared. Overview of Excel 2003 Chart Wizard "Example charts created with the Excel Chart Wizard" Using Excel's SUM and Auto SUM Functions

In this tutorial we will add up several columns and rows of data in our spreadsheet using the SUM function and the Auto SUM button on the standard toolbar in Excel.

Entering Data

Instructions for entering the data, including cell references, are available at the end of this tutorial.


Excel's Formatting options is a way to make your spreadsheets easier to read and to understand the important data. This Series of Tutorials and Articles takes you through the basics of using Excel's formatting features to improve the look and effectiveness of your spreadsheets.

1) Formatting Numbers in Excel Number formatting involves adding percent symbols ( % ), commas ( , ), decimal places, and dollar signs( $ ) to a spreadsheet. This article gives you an overview of where to find Excel's number formatting options and how to use them.

2) Excel Formatting Tools Part 1 Part One of this two part tutorial covers a number of formatting tools available in Excel:

   * number formatting
   * changing cell colors
   * adding text formatting

3) Excel Formatting Tools Part 2 Part Two of this tutorial covers:

   * changing the alignment of text in cells
   * adding a range name
   * adding formulas
   * using the NOW function to add the current date to the spreadsheet.

4) Adding Headers and Footers to Excel Spreadsheets In Excel spreadsheets, headers and footers are lines of text that print at the top (header) and bottom (footer) of each page in the spreadsheet. They contain descriptive text such as titles, dates, and/or page numbers and are used to add information to a printed spreadsheet.

5) How to Use Microsoft Excel's Format Painter To quickly copy formatting from one cell or group of cells to another part of the spreadsheet use the format painter in Excel. This feature is very useful when extending a spreadsheet and you need to format the newly added cells to match the original ones.

6) Changing the Sheet Tab Color of Excel Spreadsheets In Microsoft Excel 2003 it is possible to color code the tabs of worksheets. Changing the tab color of worksheets containing related information can make it easier to navigate through very large spreadsheets.

7) How to Use Excel's AutoFormat Option To quickly apply a number of Excel's Formatting features to a spreadsheet you can use one of the 17 AutoFormat styles available. These styles combine a number of formatting options that will instantly give your spreadsheets a professional look.

In Microsoft Excel, headers and footers are lines of text that print at the top (header) and bottom (footer) of each page in the spreadsheet.

They contain descriptive text such as titles, dates, and/or page numbers. They are used to add information to a spreadsheet that is being printed.

View Headers and Footers

   * Headers and footers are not visible in the normal worksheet view.

   * To view a header or footer before printing the spreadsheet, use the Print Preview option.

   * A header or footer can contain up to three pieces of information. This information can appear in three locations on the page.
   * For headers, the locations are the top left corner, the top center, and the top right corner of the page.
   * For footers, the locations are the bottom left corner, the bottom center, and the bottom right corner of the page.

Preset or Custom Headers and Footers

   * Excel has several preset headers and footers that you can use.
   * These standard options include the sheet name, date, time, page number, and file name.
   * There is also an option for creating your own custom headers or footers that can include text, graphics, or other spreadsheet data.
     How to add headers and footers to a worksheet:
        1. Choose File > Page Setup from the menu to open the Page Setup dialog box.
        2. Select the Header-Footer tab.
        3. Select from the preset or custom header - footer options.
        4. Create the header or footer.
        5. Preview in Print Preview.