Sunday, May 11, 2014
Wednesday, April 30, 2014
Save as PDF File
Excel 2007 Save as PDF File,
1. Click on “File”> Then click on “Save As”> PDF or XPS
2. PDF should be selected by default, if not select “Save as type” of PDF
3. Enter a “File Name”
4. The Open file after publishing if checked will open the file after saving it
5. Select whatever “Optimize for:” option you want...I will select “Standard (publishing online...)
6. Click the “Options” button to publish the entire workbook, a selection or just the active worksheet(s)
7. Click OK> Then Click “Publish”>
Tuesday, April 1, 2014
COUNT Formula counts numbers and dates
Theory:
=COUNT(Range)
Example:
=COUNT(A2:A9)
The count formula above counts the number of times a date value or number value is listed. The count formula will not count anything other than dates and numbers.
=COUNT(Range)
Example:
=COUNT(A2:A9)
The count formula above counts the number of times a date value or number value is listed. The count formula will not count anything other than dates and numbers.
Friday, March 28, 2014
true/false match formula
Theory:
To test if the values of 2 adjacent cells match exactly do the following:
=cell1=cell2
The results will be displayed as "True" if the pairs match or "False" if the pairs don't match.
Example:
You want to compare cell A2 to cell B2. Let's say both cells have the value of 108. The formula would be:
=A2=B2
The result would be "True".
To test if the values of 2 adjacent cells match exactly do the following:
=cell1=cell2
The results will be displayed as "True" if the pairs match or "False" if the pairs don't match.
Example:
You want to compare cell A2 to cell B2. Let's say both cells have the value of 108. The formula would be:
=A2=B2
The result would be "True".
Sunday, March 9, 2014
Date Formula
| Formula | Description | Value |
|---|---|---|
| =NOW() | Returns today's date and time | 24/06/2012 20:15 |
| =TODAY() | returns today's date | 24/06/2012 |
| =WEEKDAY(NOW()) | Returns the day of the week for today (Sunday) as a number | 1 |
| =WEEKDAY(TODAY()) | Returns the day of the week for today (Sunday) as a number | 1 |
| =DAY(TODAY()) | Retruns the day of the month for today (24th) | 24 |
| =DAY(NOW()) | Retruns the day of the month for today (24th) | 24 |
| =WEEKNUM(NOW()) | Returns the week number of the year which is 26 weeks into the year for today | 26 |
| =WEEKNUM(TODAY()) | Returns the week number of the year which is 26 weeks into the year for today | 26 |
| =MONTH(NOW()) | Retruns the month of the year which is 6 (June) | 6 |
| =MONTH(TODAY()) | Retruns the month of the year which is 6 (June) | 6 |
| =YEAR(NOW()) | Retruns the current year which is 2014 | 2014 |
| =YEAR(TODAY() | Retruns the current year which is 2014 | 2014 |
Straight Line Value Formula
Excel Straight Line (SLN) Depreciation YouTube Video
The straight line value is an excel formula which calculates the total depreciation amount of an asset you may hold for you business. Such as manufacturing machines.
Theory:
=SLN(Cost of item, Lowest depreciated value, Life span of asset in years)
Example with number values:
=SLN(6789,1000,10)
Example using cell references:
=SLN(A2,A3,A4)
Where cells:
A2 = Cost of item
A3 = Lowest depreciated value
A4 = Life span of asset in years
Read More..
The straight line value is an excel formula which calculates the total depreciation amount of an asset you may hold for you business. Such as manufacturing machines.
=SLN(Cost of item, Lowest depreciated value, Life span of asset in years)
Example with number values:
=SLN(6789,1000,10)
Example using cell references:
=SLN(A2,A3,A4)
Where cells:
A2 = Cost of item
A3 = Lowest depreciated value
A4 = Life span of asset in years
Friday, January 3, 2014
Growth Formula
The Growth formula is used to forecast predicted growth in for example a business's projected sales figures.
Theory:
=Growth(previous sales data range, previous month numbers data range, new month number or cell reference)
Example:
=Growth($B$2:$B$13,$A$2:$A$12,C2)
For the formula above make sure you use absolute cell referencing with the dollars on both sides of the letters as shown, a part from the last cell reference being "C2" in this case. Then fill the formula down.
OR
=Growth($B$2:$B$13,$A$2:$A$12,13)
For the formula above make sure you use absolute cell referencing with the dollars on both sides of the letters as shown, a part from the last part which is just a number in this case "13". This paticular formula using the number 13 and not a cell reference is only useful for single next month prediction.
Theory:
=Growth(previous sales data range, previous month numbers data range, new month number or cell reference)
Example:
=Growth($B$2:$B$13,$A$2:$A$12,C2)
For the formula above make sure you use absolute cell referencing with the dollars on both sides of the letters as shown, a part from the last cell reference being "C2" in this case. Then fill the formula down.
OR
=Growth($B$2:$B$13,$A$2:$A$12,13)
For the formula above make sure you use absolute cell referencing with the dollars on both sides of the letters as shown, a part from the last part which is just a number in this case "13". This paticular formula using the number 13 and not a cell reference is only useful for single next month prediction.
Subscribe to:
Posts (Atom)