But, most of you barely know what it's capable of.
Here are 10 Excel features that'll save you hundreds of hours of your life:
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 see.
Shortcuts used:
• Ctrl + space bar = Insert Column
• Shift + space bar = Insert Row
• Ctrl + shift + + = Insert
• Ctrl + R = Fill Right
• =Sum(G8:G17)