Remove Duplicates

Excel 2010 Remove Duplicates

Read More..

WEEKNUM

How to display what week number of a year a specific date is on in Excel 2010 WEEKNUM

1.      Go to the Formula tab> Select the Date & Time drop down list

2.      Click on WEEKNUM

 

3.      The function argument window will pop up

 

4.      In the Serial_number input box enter the required date with quotes (M/D/YYYY)

5.      In the return type enter 1 for Sunday as the first day of the week or 2 for Monday as the first day of the week

6.      Click on OK

7.      The result given for the 2^ndof August 2012 with Sunday being the first day of the week is

 

8.  So we are in week 31 of the year

Read More..

Else IF Statement

Excel 2010 Else IF Statement

=IF(A2="Hawl","Ha",IF(A2="Kental","Ken",IF(A2="Planet","Plan","Pli")))

Read More..

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