10 Excel Formulas To 10x Your Productivity:
You have a table of cookie sales and have to answer:
β’ Who sold least / most cookies by month
β’ Who are the top 25% / bottom 25%
β’ Who has the most winning months
β’ Who has the most losing months
β’ Who sold the most cookies
β’ How is each girl trending
Let's dive in.
β’ Format & shortcuts
Before you start, format your worksheet and lay out what you want to build.
Shortcuts used:
β’ Ctrl + space bar = Insert Column
β’ Shift + space bar = Insert Row
β’ Ctrl + shift + + = Insert
β’ Ctrl + R = Fill Right
β’ =Sum(G8:G17)
β’ Min and Max
Min and Max are helpful when working with large data sets.
Min returns the lowest value in a series of data.
Max returns the highest value in a series of data.
Min Formula: =Min(number1, number2...)
Max Formula: =Max(number1, number2...)
β’ Concatenate
Concatenate will bring strings of data together.
When you want to combine a first and last name into a single cell, it's your tool.
The formula is:
=concatenate(text1, text2, text3)
Remember to add a " " between the first and second name as text2