• Home
• Spreadsheet Basics
• Sheet
• Rows
• Columns
• Cells
• Input Basics
  • Inputs through input line
  • Input in Cell
• Types of Data
  • Labels
  • Constants
• Formulas Basics
  • Formula (part1)
  • Formula (part2)
  • Complex Formula
  • Selecting cells
• Specific Formulas (or FUNCTIONS)
  • SUM
  • AVERAGE
  • MAX, MIN
  • COUNT, COUNTA
  • IF (testing condition)
  • Financial Functions (repayment of loan)
  • Mathematical Functions(sinus, cos, ...)
  • Text Functions (&, str, ...)
  • Function Wizard
• Copying formulas
  • Absolute positioning
  • Filling cells (all directions)
• Formatting
  • Formatting text
  • Formatting numbers
  • Column width
  • Inserting a column
• Graphs
  • Having Y-Axis on both side of the graphs

• Excel Examples
  • Open Topic List (very useful to keep track of tasks)
  • Hello Kitty Open topic List
  • Mini-budget
  • Bank loan repayments
  • Bank Interest
  • Psychedelic (have fun with Excel)

Previous    Next

This is how the Excel screen looks like

The top part is the menu (of course you know this).

Underneath where the E7 is. This is the name of the cell you have the cursor in. (you will see later that you can give this cell a name and then recall this name).

On the right side of the E7, after the =, the blank part is where you enter your value and formulaes (you will see later...).

On the bottom, you can see the wording Sheet1, sheet2, sheet3. These are 3 different sheets you can use to enter your work. You can add sheets (in menu insert) or rename them (by double clicking on the tab).

Previous    Next

Updated September 11th, 2010

Contact: admin@Excelmadeeasy.com

You are visitor no: 6965