Check out our Help Guides....Office Tutorials - Virus Help Page - FREE SOFTWARE - Windows Errors - Album to CD - Backup Basics - Recover deleted files
 

To join our regular newsletter database, just
 click on email link below and say addme in
 either Subject or body of email
For News, Info, Special Offers, Internet Offers, Tutorials etc........
 

     Welcome To Daw Computers : Big enough to cope - Small enough to care....


 

MICROSOFT EXCEL
Introduction into Microsoft Excel
Starting Up Microsoft Excel
Creating Formulas
Order Of Operations
Borders and Shading
Inserting A Chart


 Introduction into Microsoft Excel
Microsoft Excel is allows you to create professional spreadsheets and charts. It performs numerous functions and formulas to assist you in your projects.

This tutorial will help you get started with Microsoft Excel and may solve some of your problems, but it is a very good idea to use the Help Files that come with Microsoft Excel , or go to Microsoft's web site located at http://microsoft.com/office/excel/default.htm for further assistance.

Back to top

Starting Microsoft Excel
 
  • Two Ways
     
    1. Double click on the Microsoft Excel icon on the desktop.
      Excel Icon On Desktop
    2. Click on Start --> Programs --> Microsoft Excel
      Excel from Start Menu


Back to top

Creating Formulas
 

  1. Click the cell in which you want to enter the formula.
  2. Type = (an equal sign).
  3. Click the Function Button
  4. Select the formula you want and step through the on-screen instructions


Back to top

Order of Operations Excel Uses
 

Precedence Operation Operator
1 Exponentiation ^
2 Multiplication *
2 Division /
3 Addition +
3 Subtraction -
4 Concatenation (putting 2 strings together, like Jenn & ifer) &
5 Equal To =
5 Greater Than >
5 Less Than <


Back to top

Adding Borders and Shading to Cells
 

  1. Make sure you have the Formatting toolbar visible
    • Click on View --> Toolbars --> Formatting
  2. Select cells you wish to format by left clicking on them and highlighting them
  3. Click the button to shade a cell and/or the to give a cell a border


Back to top

Inserting A Chart
 

  1. Select over the text you want to make your chart with
  2. Click Insert --> Chart
  3. Select the type of chart you want
  4. Confirm or change your data range
  5. Update the Chart Options
  6. Select if you want to put it into the current worksheet or into a new worksheet


 Back to top