- The Workbook
- Posts
- Candy = productivity š«
Candy = productivity š«
Plus: Create custom color scales in Excel!
Hey there! After getting thousands of messages about hosting a beginner-friendly Excel class, Iām so excited to announce itās finally happening!
All of us right now š¤£
In this free live Excel class, Iām sharing tips to help you simplify Excel (buh-bye, Excel anxiety), build your confidence with the basics, and save up to 3 hours each week!
Here are the dates:
Thursday, November 14 at 3 PM ET
Friday, November 15 at 12 PM ET
Save your spot here. See you soon!
Create Data That Pops With Custom Color Scales šØ
What if I told you beautiful, easy-to-read data is just two minutes away? š
Introducing: Custom Color Scales. With just a few clicks, you can turn your raw numbers into color-coded insights.
Imagine a teacher who needs a lightning-fast way to see high and low scores. Theyād love to create a custom color scale like this: ā¤µ
Easy. Hereās how to make one in under 30 seconds:
1) Select the cells you want to format
2) Home > Conditional Formatting > New Ruleā¦
3) Select a Rule Type > Format All Cells Based on Their Values
4) In the Edit the Rule Description change the Format Style to 3-Color Scale
5) Change the Type to Number and input the Value (in our case, thatās 50 for Minimum, 70 for Midpoint, and 100 for Maximum)
6) Select OK and youāre done!
Now our (fictional) teacher can review test scores at a glance. How will you use custom color scales in your day-to-day? š
Letās Get Back to the (Excel) Basics š¶
Join my free live Excel class and in just one hour Excel will go from a source of overwhelm and confusion to confidence and joy. Iāll be sharing easy-to-understand tools that simplify Excel for you and boost your confidenceājust like it did for these previous students!
If you want to start putting āProficient in Excelā on your rĆ©sumĆ© (and mean it š), take the first step and sign up for class today!
What Kit Kats Can Teach Us About Productivity š«
The projects that move the needle in our lives tend to be major endeavorsāwriting a novel, studying to get into law school, learning a new language. For me? It was creating my first Excel course in 2020. I had to film over 100 training videos and build 50 practice files (all while balancing my 9ā5). š«
If youāre like me, you get overwhelmed when faced with a gargantuan projectāto the point where you throw in the metaphorical towel before even starting. So how do we squash that overwhelm and Get. Things. Done?
Enter: the Kit Kat Framework. š« Writer Amanda Goetz developed this strategy to help her write a book in just three months! Hereās the idea:
Letās use my Excel courses as an example. After identifying the big project, I split it into four main phases: Planning, Prepping (filming, outlining, content), Production, and Promotion.
If the planning phase feels too daunting, Iād break it down into four more parts, starting with something smaller, such as āDefine my course objectives.ā
If that part also feels overwhelming? Iād āKit Katā it again into four smaller tasks until each to-do is bite-sized and manageable.
Eventually, your project (even if itās Everest-sized!) shrinks enough for you to take that first step. And with each step, you get closer and closerāuntil suddenly, the summit is within reach. ā°ļø
Need to move your Pivot Table to a new tab? Hereās how.
I loved this reminder of what the real luxuries in life are. (Hint: ā)
Tired of doing line-by-line edits in PowerPoint? Try this editing tip.
This DJ has been on repeat while Iām in productivity mode. šµ
Try this shortcut next time you have a long formula in Excel. š”
Thanks for being here! And happy (belated) 39th birthday to Excel! š
Excelās age is a big dealāmost software doesnāt last two decades (who else remembers Napster, AOL Instant Messenger, or MySpace?).
Hereās to another 39 years! And if youāre ready to build skills that last just as long as Excel itself has, join my free live Excel class for beginners! Canāt wait to see you there.
Stay Exceling,
Kat