Microsoft excel has quickly become one of the most used computer programs in the business world. While most people use it for basic functions, there are more than 400 functions in the program.
What are the top 6 six functions you should know about?
Without knowing the proper use of each, it can surely make and users overwhelmed. Fortunately, you do not need all 400 functions on a daily basis. Further listed here are the top six functions you learn in any Microsoft Excel Training that can help you shine in your workplace.
IF(B3>D3,” B is larger, “D is larger”) This is an example of an IF Function. It is considered to be one of the most popular functions in Excel. The IF Function can have only two results. It helps calculate whether a particular condition is true or false for a specified cell. In simpler words, it allows the user to make comparisons between a particular value and what you expected.
=IF (OR (AND ( B1>900, C1=” Orange”), AND (B1<900, C1=” Sunday “))
The OR and AND function in excel is a basic logical function. It is used to compare two statements or values. The difference between both is that while the OR function returns true even if one of the arguments mentioned is true and only returns false, all of the arguments are false. However, the AND function will come back false even if one of the mentioned values is false. The example mentioned here shows how you can use it with an IF function.
=VLOOKUP(F1,C1:D2,4,FALSE)
VLookup, short for vertical lookup, helps when you have to search for value inside a column. Once you have specified a particular range, using this function will match the input with a similar value from the other specified column in the same range.
If some of these Excel functions like VLOOKUP are too much for you to understand, then you should look into getting help from a 3rd party.
There are so many good training providers around, but one particularly good one in the UK is Acuity Training, who offer a range of Excel courses including an Advanced course that includes details about VLOOKUP, HLOOKUP, etc. They have training centres in London, Bristol, and Guildford, as well as offering online training.
=HLOOKUP(200,A1:F22,1,TRUE)
Similar to the prior mentioned example, the only difference is this works horizontally. It helps you explore rows instead of columns in a defined range input and further provides a conforming value to the defined row.
=MOD(ROW(),2)=0
This function is relatively more complicated. Known as Conditional Formatting, it highlights the parts of the data presented for any condition you want. As simple as it sounds, there are certain steps involved in it. Firstly, you have to select the data that you want to highlight. After that, on the ‘menu’ option, then select ‘format’ and Conditional Formatting.
Then delete the ‘cell value’ and add ‘formula is.’ Adding the formula above will allow you to alter every other row, which is indicated by the number 2.
=SUMIF($A$1:$A$10,”good”,$D$1:$D$10)
One of the most basic and used formulas in Excel for accounting and calculating costs, using this formula helps you sum the numbers in the denoted range. You can use it for both columns and rows.
The Bottom Line
Given the several benefits of these functions, it has made data input simpler and convenient for users. Learn more by opting for a Microsoft Excel Training program from customguide.
