Useful LINKS

Templates

FAQ

Can I change the color of the worksheet tabs in my workbook?

I saved my workbook with a password and Excel won't recognize it. How can I recover my document?

How can I display the day of the week?

I have a range of time values, but when I try to sum them, the total is never greater than 24 hours.

How can I print on one page?

Can I write a formula that returns the number of distinct entries in a range?

Great Templates

Easy Budget

Bank Repayments

Bank Interest

Open Topic List

Hello Kitty Open Topic List

Funny Sheet

Here the tutorial overview

• 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 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 October 4th, 2012

Contact: admin@Excelmadeeasy.com

You are visitor no: 55