Excel Templates
Cash Receipt...
This template allows you to give a receipt to a customer for cash received, or when...
Grading Sheet...
Grading sheet template is an excel template that give you a form to put grade on...
Fitness Tracker...
This template will help you manage and track your exercise daily, so you can see...
Daily Planner...
Another excel template for your personal need, this excel template will help you...
Posted by
Andrian on
12 26th, 2009 |
No Comments Excel 2007 also add some new functions that not available on previous version, those functions are:
IFERROR—Used to check for an error, and display a message or perform a different calculation.
AVERAGEIF— Used to calculate a conditional average (similar to SUMIF and COUNTIF).
AVERAGEIFS—Used to calculate a conditional average using multiple criteria.
SUMIFS—Used to calculate a conditional...
Posted by
Andrian on
12 24th, 2009 |
No Comments One of the most common and helpful uses for data validation function is to create drop down list in a cell, just like the figure below shows. Figure below shows month names with range A1:A12 as the list source.
To create that kind of drop-down list are:
Enter the list items into a single-row or single-column range. These items are the ones that appear in the drop-down list.
Select the cell that will...
Posted by
Andrian on
12 19th, 2009 |
No Comments
Use this template to keep track of the value of your collectibles. The Low and High columns should reflect current retail selling ranges. The High column should represent full retail selling price. The Low column generally represents the lowest price one could expect to find the collectible with extensive shopping.
Posted by
Andrian on
12 19th, 2009 |
No Comments
This template allows you to give a receipt to a customer for cash received, or when you want to keep a receipt for cash disbursed.
Posted by
Andrian on
12 19th, 2009 |
No Comments This tips will give you steps on how to selectively load add-ins in specific worksheet, we’re able to do this on with a little code on macro. Here’s the steps:
Activate the worksheet in which you want an add-in to be loaded.
Press the shortcut button Alt+F11 to display the VBA Editor or click on Developer ribbon and then click the Visual Basic button on the left hand side.
Double-click...
Posted by
Andrian on
12 18th, 2009 |
No Comments
Grading sheet template is an excel template that give you a form to put grade on something or someone. Suitable for for teacher to put grades for their students, so it can easily accessed.
Posted by
Andrian on
12 18th, 2009 |
No Comments
This template will help you manage and track your exercise daily, so you can see how is your progress.
