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!

Warms my heart šŸ„² 

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