Format Painter

Excel Format Painter,

 

    Excel 2010 Format Painter YouTube Video

      1.    Select the cell with the color you want to use…e.g. select cell A2 with yellow

      2.      Go to the “Home” tab in the “Clipboard” section and select the “Format Painter”

3.      Then click on the cell you want to fill with that color, e.g. cell B2

   4.      The color in cell B2 will now be yellow as well which is reflected from cell A2

   5.      Repeat the steps for all required cells

You can also do it much more quickly by

   6.      Highlighting e.g. column A> then click on “Format Painter” in “Clipboard” group

   7.      Then select e.g. column B

   8.      The colors on column A will now be reflected in the same way on column B

   9.      That's it

Read More..

Concatenate Formula

Excel 2010 Concatenate Formula

Theory
=CONCATENATE(Field 1," ",Field 2)
Example:
=CONCATENATE(B2," ",C2)
The concatenate formula is ideal for merging two or more fields together. The concatenate formula is also ideal for creating unique identifier fields or unique ID columns without creating a completely new column for inputting. For example, merging or Concatenate("Full Name" + "D.O.B" + "Post Code") of a customer can be used as an ID column. Though the data will have to be complete and kept clean. Read More..

Dollar Formula

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..

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..

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..