By learning formulas of Microsoft excel 2013, it can enhance your skills while performing daily activities on excel 2013. Microsoft excel 2013 specialists are advised to learn and practice these formulas in order to make excel 2013 easy for you. Give your best performance on spread sheets by applying direct formulas when needed. These formulas are suggested because they help in supervision of time. A few most important and frequently used formulas in Microsoft excel 2013 are:

 

 V Lookup Formula:

 

V Lookup is the most important formula of excel 2013. Excel 2013 specialist are advised to practice this formula as it is used regularly. Its function is to drag information from one table to another. If there is a table whose population is high, it will drag the piece of information from the table of large population and put it to the table where new data is stored.

 

Sum Formula:

 

This formula is used in order to add figures in Microsoft excel 2013. First of all enter all the figures you want to sum up. 

 

Then write this formula right in the end of the list of figures: 

 

=SUM(row:column) 

 

Once sum up formula is applied, excel 2013 will sum all the numbers and will give you the exact result. 

 

IF Formula:

 

IF is used to find out whether the statement is True or False. For this function start filling Wizard columns. Fill logical test, value if True and value if False functions in the Wizard box to get the mandatory results. 

 

OR Function:

 

OR Function is similar to AND function in excel 2013. Excel 2013 specialists should learn this function because it performs single task multiple times according to the criterion of the formula. If one statement in the related data is correct, then all data is considered correct in the spread sheet.

 

PROPER Function Formula:

 

To write everything with caps lock on, proper function formula is used. It capitalizes all data in the table and can convert the rest of data into small letters. Apply it on the first letter of every word and then copy it in order to make the rest of the word in capital letters.

 

NOW Function Formula:

 

NOW function is the easiest function of Microsoft excel 2013. It helps the user by telling the exact date and time. It has the easiest formula i.e. Now(). Users can simply type the formula in the table in order to get current date and time. Later, you can set the format of date and time according to your constraint. 

 

All of the above formulas are helpful for excel 2013 specialists as it saves time and give proficient outcomes. There are countless functions as well that can correspondingly be worthwhile.