Excel Brown Bag: Making Spreadsheets Easy
Have you ever shuttered in fear at the thought of crafting an elaborate report via Microsoft Excel? It is most likely a skill listed on your resume, but whether or not you can actually utilize it is a separate issue all together. Now your boss is asking for this quarter’s expenditure report and your palms are sweaty to say the least.
No need to fear – Vertical Technologies (VT) is here to solve your tech problems, no matter how large or small. Excel is a monster easily conquered despite its intimidating modular exterior. VT has compiled an Excel guidebook, complete with need to know shortcuts and formulas.
*(B4:B13) is a placeholder. Be sure to replace with the correct data range set.
Add 2 or more numbers together.
Adds your list and divides by the number of values.
Maximum and Minimum
Find the maximum and minimum values in a list.
Current Date and Time
To test a condition and to return one value if the condition is met, and another value if the condition is not met.
=IF (condition to test, output for TRUE, output for FALSE)
Delete Extra Space
Removes the extra spaces within the data set.
If you’re looking for a more in-depth dive inside the Excel “IF Function,” our friends at Spreadsheeto have a brand new comprehensive tutorial that we highly recommend. Check it out here to view their tutorial complete with a free sample file to get you started.
Now that you know some vital Excel basics, you can pass as ‘proficient.’ If you need some help getting to the expert level, though, contact Vertical Technologies. Our professionally trained staff has extensive information technology experience and will assist you no matter the size of your tech problem.