Proficiency in Microsoft Excel is no longer a boost to your resume, it is a necessity.
A firm grasp on a few Excel functions can be the difference between a 20 minute task and a 3 hour project. With employers asking more out of their employees, there is no excuse for your Microsoft Excel skills to be subpar.
Where do we start?
The SUM formula: =SUM(A1, B1)
- There is no secret as to what the SUM formula does. It allows you to add 2 or more cells that contain numbers together. Gone are the days of typing =5+5 in the cells, or even doing the calculations outside of Excel and inputting the answers. With =SUM you can create a dynamic formula that can change with the ebbs and flows of your spreadsheet.
The VLOOKUP formula: = VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)
- Daunting complex at first, but extremely simple and useful once you complete a few, the VLOOKUP is used to pull specific data from one list to another. Read more about the VLOOKUP use cases here.
The Pivot Table function: Arguably the most powerful tool in Excel. An entire company, Tableau, is basically one extremely complex Pivot Table company.
- This is the best way to analyze large amounts of data in Microsoft Excel. Read more about Pivot Tables here.
- IF Statements: =IF(logical_statement, return this if logical statement is true, return this if logical statement is false)
- IF statements can be used in every way imaginable. We can create an IF statement to return the word Yes or No if a customer has bought the product more than once, or even create a customer health score based on usage data.
Here are a few sample IF statements to get started.
As always, please let the Excel Skin team know if you have any questions!
Leave a comment
Comments will be approved before showing up.