- The Workbook
- Posts
- Should you use a filter or slicer? š¤
Should you use a filter or slicer? š¤
Plus: the courage to conserve energy
Hello! š· I was today years old when I learned that the āspring smellā we know and love actually has a name. Itās called geosmin, a compound produced by bacteria in soil that becomes more active as temperatures rise.
As we look ahead to spring and summer, Iād love to know:
What topic would you like us to cover in our next free training? |


Letās Talk Filters vs. Slicers
Itās a Thursday afternoon when your co-worker swings by your desk.
āCheck this out,ā they say, opening their laptop. āIām analyzing sales by region for tomorrowās presentation. Pretty cool how I can filter by North, East, South, and West regions, right?ā
There are two options for your next move š
Nod politely.
Show them something thatāll seriously upgrade their presentation.
Since youāre a good friend, weāre going for option two! Time to introduce your co-worker to slicersāinteractive buttons you can place outside of your Pivot Table, making it easy to toggle through your data.
Hereās how to create a slicer in three easy steps:
Step 1) Select the Pivot Chart
Step 2) Go to Pivot Chart Analyze and select Insert Slicer
Step 3) Because we want to see sales by location, select the Region field before clicking Ok
All thatās left is to move your slicer where it fits best (and to prepare for the inevitable āThank youā once your co-worker sees how much youāve leveled up their spreadsheet š).


Get Ahead Of the AI Curve in 2025!
āThere are too many AI tools and I donāt know where to begin.ā āI donāt have the technical background to learn AI.ā āAI is just advancing too quickly.ā
Sound familiar? Itās not just you! The AI landscape is developing crazy fastāwhich is exactly why I created my course, AI With Miss Excel!
In just a few hours, youāll learn practical skills with ChatGPT, Microsoftās Copilot, and Google Gemini thatāll transform your workflow and position you as the go-to AI expert in your circle.
Ready to stop watching the AI revolution from the sidelines? Use my code WORKBOOK20 for 20% off!


Your Newsletter, Now Exiting the Stratosphere
Meet beehiiv, the newsletter platform built for builders. Every product they drop and feature they create is made with one goal in mind: exponential growth.
If you need a beautiful destination for your content, use the no-code website builder. If you want paid subs, beehiiv doesnāt take a dime. If you want big name sponsors, they connect you with the likes of Nike and Netflix.
In short: Maybe your newsletter is stuck on the ground floor because your newsletter platform is stuck in the last decade.
Level up and get started with beehiiv. Use code WORKBOOK for 20% off your first 3 months.


The Courage to Conserve Your Energy š«
Isnāt it wild how our definition of success is always changing? For years, my version of āsuccessā meant thriving at my 9-5 consulting job.
And I was good at it! I genuinely loved my co-workers and found the work challenging in all the right ways. But after years of the consulting grind, I started to feel energetically depleted.
The problem was that Iād tied my identity to being a consultant, and I was terrified of stepping away from a position that had brought me stability, comfort, and accomplishments.
I had a realization, though: If thereās one thing I fiercely protect, itās my energy. The more you prioritize yourself and your happiness, the more abundance you can hold and share with others.
No matter how āsuccessfulā the job was, if it drained me, it wouldnāt be long before my careerāand other areas of my lifeāstarted to suffer. So I made the leap and bet on myself by launching Miss Excel.
And honestly, it turned out to be one of the best decisions Iāve made. Not only was I able to help more people, but I also recouped my creative energy.
This was my biggest lesson in my 20s: that sometimes, the best decision is letting go of something that no longer serves youāno matter how successful it may be.
Hereās what this could look like for you:
Declining a promotion that would double your stress and halve your free time in favor of preserving your energy to find a new career that better aligns with you.
Holding off on nonstop networking events to focus on more energizing ways to connect (such as posting on LinkedIn or having 1:1 coffees!).
Itās terrifying to say no. But remember, itās your energy that matters mostābecause thatās what fuels your creativity, ability to show up for others, and, ultimately, your future. š¤


How to remove the āGrand Totalā section from your Pivot Table š
Need to hit snooze on your Outlook emails? Iāve got you. š¤
The evidence-backed way to achieve your goals in 2025 š„
This āMinimum Winā productivity strategy is going viral on Reddit. š
āMind blown,ā says a comment on my video on Excelās Quick Navigation feature! š¤Æ


If you find yourself spending too much time on your phone (and letās be realā¦who doesnāt?), try turning it into grayscale for a bit. Iāve found that whenever my phoneās screen is in black and white, the urge to scroll fades pretty quickly.
Stay Exceling,
Kat