Excel 2010 Dollar Formula
=DOLLAR(Cell Reference, Decimal Places)
This excel tutorial will look at the dollar formula.
It displays the number selected in your local currency format.
The local currency outputted is based on your regional settings.
Read More..
Monday, March 29, 2021
Dollar Formula
Friday, March 26, 2021
ACCRINT Formula
Excel 2010 ACCRINT Formula Displays the total interest gained from an investment product over a certain timeframe
1. Go to Formula tab
2. Click on Financial
3. Select ACCRINT
4. The function arguments window will pop up
5. In the issue input box enter the issue date for the security enclosed with quotes
6. In the first interest input box enter the first date that interest will be paid enclosed with quotes
7. In the settlement input box enter the settlement date for the product enclosed with quotes
8. In the Rate input box the annual rate of interest (percentage)
9. In the Par input box enter the value of the security
10. In the Frequency input box enter the number of annual interest payments
11. In the Basis input box enter 0 or leave blank if you want the average number of days to be 30 days per month
12. Click OK
13. As you can see from my inputs the outputted annual payments I will receive will be 12.50 pounds sterling
Keywords: Financial formula, Excel 2010 ACCRINT Formula , Excel 2010, ACCRINT Formula
Read More..
1. Go to Formula tab
2. Click on Financial
3. Select ACCRINT
4. The function arguments window will pop up
5. In the issue input box enter the issue date for the security enclosed with quotes
6. In the first interest input box enter the first date that interest will be paid enclosed with quotes
7. In the settlement input box enter the settlement date for the product enclosed with quotes
8. In the Rate input box the annual rate of interest (percentage)
9. In the Par input box enter the value of the security
10. In the Frequency input box enter the number of annual interest payments
11. In the Basis input box enter 0 or leave blank if you want the average number of days to be 30 days per month
12. Click OK
13. As you can see from my inputs the outputted annual payments I will receive will be 12.50 pounds sterling
WORKDAY Formula in Excel
How to display the end date of a project when the only information you have is the start date, the number of days the project should take, and the official holiday dates in Excel 2010 WORKDAY
1. Go to the Formula tab> Select the Date & Time drop down list> Click on WORKDAY
2. The function arguments window will pop up
3. In the Start_date input box enter the start date of the project enclosed in quotes
4. In the Days input box enter the total number of days for the project
5. In the Holidays input box enter the official holiday date
6. Click OK
7. The value will be displayed on the active cell in excel as a number
8. Right click on the cell and click format cells
9. Select the number tab
10. Select Date
11. Select the required date format
12. Click OK
13. The project end date is now displayed
Read More..
1. Go to the Formula tab> Select the Date & Time drop down list> Click on WORKDAY
2. The function arguments window will pop up
3. In the Start_date input box enter the start date of the project enclosed in quotes
4. In the Days input box enter the total number of days for the project
5. In the Holidays input box enter the official holiday date
6. Click OK
7. The value will be displayed on the active cell in excel as a number
8. Right click on the cell and click format cells
9. Select the number tab
10. Select Date
11. Select the required date format
12. Click OK
13. The project end date is now displayed
Tuesday, December 29, 2015
Pivot Table Calculated Field
Excel 2010 Pivot Table Calculated Field
The calculated field function within pivot tables is particularly useful for calculating percentages such as commissions.
Read More..
The calculated field function within pivot tables is particularly useful for calculating percentages such as commissions.
Thursday, April 9, 2015
Send Email attachment
1 Go to> File> Send> Email (attachment)
2 Outlook will open
3 Enter email address and click send
Saturday, January 17, 2015
Sunday, January 11, 2015
Removing spaces
1. Highlight column in question. In this case I will highlight column A.
NB: Make sure to highlight the required column or all spaces in the other columns will be replaced as well.
2. Select key CTRL + H...which is the keyboard shortcut for Find and Replace. Or go to the Home tab> Then go to the Editing group and Click “Replace”.
3. In the “Find What” text box, enter 1 single space by pressing the space bar
4. Make sure there are no data and no spaces in the “Replace With” text box
5. Click “Find Next”> Then click “Replace All”. This will replace all the spaces in the column highlighted.
6. In my case 10 spaces have replaces with nothing that is there are no longer any spaces in the highlighted column.
Subscribe to:
Posts (Atom)