The Excel Techniques That Will Make You Get Noticed At WorkAssociation of Business Training
April 16, 2014 — 1,655 views
If you’re a busy professionals, aren’t we all? And you want to make an impression on your supervisors, try and master the skills of Microsoft Excel. By mastering these skills you will start getting noticed and will be appreciated at your workplace.
Excel is a powerful tool that will help you improve your analytical skills, save you precious time, and overall simplify your workday. It allows you to do just about anything related to mathematical calculations, graphical representations and even engineering as well as financial operations.
Here is a brief explanation of some of the most commonly used tools in Excel:
This feature of excel allows you to look up or find any value in one column and find the same or corresponding value in the same row, or a different row in a different column. The Vlookup formula or syntax is as follows: VLOOKUP(lookup_value,table_array,col_index_num,range_lookup).Using this formula you can find an exact or approximate match of the value.
This function gives you the value or reference to a value from a table or range of cells. There are two types of index function. The Array form finds you the value of a specified cell or array of cells. The Reference form finds you the reference to specified cells. The syntax is: INDEX( array, row_number, [column_number] )
The match function searches for an item in a range or group of cells and then gives you the position of that item in the range. The syntax is: MATCH(lookup_value, lookup_array, [match_type]). Suppose a range of cells contains the values 4, 26 and 30, and you want to find 26, the match function will result in 2, because 26 is the second value in the range.
The sum function adds up all the numbers in a specific range or array of cells and gives you the total of the numbers. The syntax is: SUM(number1, [number2], [number3], [number4], ...). For eg: SUM(B1:B5) adds up all the numbers in cells B1 to B5.
This function combines up to 255 items such as text, numbers or cell references into one text string. Basically two separate items of information in two different cells can be joined together into one single cell using this function. The syntax is: CONCATENATE(text1, [text2], ...)
These tables help you to automatically extract data from one table and arrange as well as summarize it in a different format to make comparisons, detect relationships and study trends between the two tables.
Working with these functions will help you save lot of time, which will help you in creating a good impression on your supervisors.