• 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.
10 Excel Formulas To 10x Your Productivity:
• 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.
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 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 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
Sparklines let's us answer the question: How is each girl trending.
With Sparklines, we can insert graphical data directly into a cell of our table as simply as:
• Select Range
• Insert Sparkline
• I choose Column
In statistics, a quartile divides the number of data points into four parts, or quarters, of more-or-less equal size.
It lets us know the bottom 25% of sales people and the top 25% of sales people are.
Formula: =quartile(array,quart)
quart = the quartile we want.
We use sumifs when we want to add cells that meet multiple criteria, generally in a list.
In our scenario, we want to sum numbers between two quartiles.
Formula = sumifs(range, criteria1 range, criteria1, criteria2 range, criteria2)
X-Lookup is an upgraded V-Lookup.
We use it to find data in a table or range.
We are going to combine our X-Lookup with our Min and Max function.
The formula: =XLOOKUP(lookup value, lookup array, return array)
Ours will pull the min / max person by month.
Countif will count a value that meets certain criteria.
We will use this to determine how many times someone was the minimum value or maximum value in a month.
Formula: =countif(range, criteria)
Conditional formatting lets us highlight information for the readers.
We can either set our own rules or use preset rules, as we will in our example.
By using different colors it draws your eyes to the good, and bad.
You always want your finished product to look good and be consistent.
When someone reads your work and it looks good, they ask less questions.
When you are asked less questions, you are more productive.
Make your work look good.
If you want to 10x your Excel productivity, learn these 10 formulas and techniques:
• Conditional formatting
• Format & shortcuts
• Min +Max formula
• Concatenate
• Sparklines
• X-Lookup
• Quartile
• Countif
• Sumifs
1. Follow @IAmClintMurphy
2. Share the first tweet
https://t.co/zYFc73vj2C
Until next time,
Clint Murphy
10 Excel Formulas To 10x Your Productivity:
— Clint Murphy (@IAmClintMurphy) June 23, 2022
More from Productivity
You May Also Like
The UN just voted to condemn Israel 9 times, and the rest of the world 0.
View the resolutions and voting results here:
The resolution titled "The occupied Syrian Golan," which condemns Israel for "repressive measures" against Syrian citizens in the Golan Heights, was adopted by a vote of 151 - 2 - 14.
Israel and the U.S. voted 'No' https://t.co/HoO7oz0dwr
The resolution titled "Israeli practices affecting the human rights of the Palestinian people..." was adopted by a vote of 153 - 6 - 9.
Australia, Canada, Israel, Marshall Islands, Micronesia, and the U.S. voted 'No' https://t.co/1Ntpi7Vqab
The resolution titled "Israeli settlements in the Occupied Palestinian Territory, including East Jerusalem, and the occupied Syrian Golan" was adopted by a vote of 153 – 5 – 10.
Canada, Israel, Marshall Islands, Micronesia, and the U.S. voted 'No'
https://t.co/REumYgyRuF
The resolution titled "Applicability of the Geneva Convention... to the
Occupied Palestinian Territory..." was adopted by a vote of 154 - 5 - 8.
Canada, Israel, Marshall Islands, Micronesia, and the U.S. voted 'No'
https://t.co/xDAeS9K1kW
View the resolutions and voting results here:
The resolution titled "The occupied Syrian Golan," which condemns Israel for "repressive measures" against Syrian citizens in the Golan Heights, was adopted by a vote of 151 - 2 - 14.
Israel and the U.S. voted 'No' https://t.co/HoO7oz0dwr
The resolution titled "Israeli practices affecting the human rights of the Palestinian people..." was adopted by a vote of 153 - 6 - 9.
Australia, Canada, Israel, Marshall Islands, Micronesia, and the U.S. voted 'No' https://t.co/1Ntpi7Vqab
The resolution titled "Israeli settlements in the Occupied Palestinian Territory, including East Jerusalem, and the occupied Syrian Golan" was adopted by a vote of 153 – 5 – 10.
Canada, Israel, Marshall Islands, Micronesia, and the U.S. voted 'No'
https://t.co/REumYgyRuF
The resolution titled "Applicability of the Geneva Convention... to the
Occupied Palestinian Territory..." was adopted by a vote of 154 - 5 - 8.
Canada, Israel, Marshall Islands, Micronesia, and the U.S. voted 'No'
https://t.co/xDAeS9K1kW
Trending news of The Rock's daughter Simone Johnson's announcing her new Stage Name is breaking our Versus tool because "Wrestling Name" isn't in our database!
Here's the most useful #Factualist comparison pages #Thread 🧵
What is the difference between “pseudonym” and “stage name?”
Pseudonym means “a fictitious name (more literally, a false name), as those used by writers and movie stars,” while stage name is “the pseudonym of an entertainer.”
https://t.co/hT5XPkTepy #english #wiki #wikidiff
People also found this comparison helpful:
Alias #versus Stage Name: What’s the difference?
Alias means “another name; an assumed name,” while stage name means “the pseudonym of an entertainer.”
https://t.co/Kf7uVKekMd #Etymology #words
Another common #question:
What is the difference between “alias” and “pseudonym?”
As nouns alias means “another name; an assumed name,” while pseudonym means “a fictitious name (more literally, a false name), as those used by writers and movie
Here is a very basic #comparison: "Name versus Stage Name"
As #nouns, the difference is that name means “any nounal word or phrase which indicates a particular person, place, class, or thing,” but stage name means “the pseudonym of an
Here's the most useful #Factualist comparison pages #Thread 🧵
What is the difference between “pseudonym” and “stage name?”
Pseudonym means “a fictitious name (more literally, a false name), as those used by writers and movie stars,” while stage name is “the pseudonym of an entertainer.”
https://t.co/hT5XPkTepy #english #wiki #wikidiff
People also found this comparison helpful:
Alias #versus Stage Name: What’s the difference?
Alias means “another name; an assumed name,” while stage name means “the pseudonym of an entertainer.”
https://t.co/Kf7uVKekMd #Etymology #words
Another common #question:
What is the difference between “alias” and “pseudonym?”
As nouns alias means “another name; an assumed name,” while pseudonym means “a fictitious name (more literally, a false name), as those used by writers and movie
Here is a very basic #comparison: "Name versus Stage Name"
As #nouns, the difference is that name means “any nounal word or phrase which indicates a particular person, place, class, or thing,” but stage name means “the pseudonym of an
