Excel Made Easy

Start Here or read the introduction further. Examples and Templates are in the left column.

Ideally you should have Excel to test them. These examples will also work in alternative versions of Excel (not from Microsoft). You can find a link to these programs here.

If you would like to get some different examples or new ones, do not hesitate to send an email to the address at the bottom of this page. I wish you a good reading.

Home
Spreadsheet Basics

Input Basics
- Inputs through input line
- Input in Cell
Types of Data
- Labels
- Constants
Formulas Basics
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
Graphs
- Having Y-Axis on both side of the graphs

Excel Examples and Templates
- Open Topic List (very useful template to keep track of tasks)
- Hello Kitty Open topic List with Hello Kitty colours. A great template for the HK lovers.
- Mini-budget is a nice template to follow your costs
- Bank loan repayments is a very useful template to re-calculate your loans.
- Bank Interest can be used as a template to calculate your interests.
- Psychedelic is a template to see what funny things you can do with Excel.

Updated May 4th, 2012

Contact: admin@Excelmadeeasy.com

You are visitor no: 24061