- The Workbook
- Posts
- Should you do an annual review? đ
Should you do an annual review? đ
No need for 20/20 vision with Excel
Hey there! Imagine this: Itâs December 2025. The past year was your yearâyou landed that promotion youâve wanted for months, you led bigger and better projects, and you wrapped up work early almost every day.
And where it all started? You signed up for my free Excel class on Pivot Tables and Data Visualization.
Save your spot and letâs make next year the best one yet! â¨
Is Your Vision 20/20? đď¸
Hereâs a wild factâonly 35% of adults have 20/20 vision without glasses, contacts, or surgery. That means that if your boss asks you to find the latest transaction from the training department below â¤ľď¸ your eyes will likely work overtime to spot the right data.
Letâs simplify that search (and save your eyeballs in the process đ).
Step 1) Type =XLOOKUP and select the lookup value
Step 2) Select the column the lookup value is in
Step 3) Select the column the return value is in
Step 4) Skip if_not_found and match_mode. Then, enter -1 for search_mode
Excel Tip: đĄThe -1 tells Excel to search from bottom to top so you can find the last occurrence of a specific value in a column. Alternatively, 1 (default) searches top to bottom and is used to find the first occurrence of a value.
Step 5) Close parentheses and press enter. All done!
Donât Forget to Join Our Free Excel Class!
I know what you might be thinking: âIs a free one-hour Excel class worth it?â
Let me put it this way: This class will give you the tools to simplify Excel so you can save a minimum of three hours a week at the office. If you multiply those saved hours with the average of 52 work weeks? Thatâs nearly 156 hours you get back. đŽ
So donât forget to join our class on Pivot Tables and Data Visualization! As Mitchell will tell you, itâs a great time:
Snag your spot today!
Is an Annual Review Worth It? đ
With only 14 days left of 2024 (wild right?), youâve likely seen journaling advice everywhere. âReflect on 2024! Plan for 2025! Write it all down!â
And you might be wondering: Is it worth it? Will sitting down, reflecting on the past, and planning for the future actually change anything?
My two cents? Yes. Iâve been doing annual reviews for years and know a ton of my personal and professional growth is thanks to this single activity. Here are three reasons why I love giving myself an annual review:
1. đ Deeper gratitude
When you reflect on the past yearâwhat you accomplished, what you overcameâyou realize just how far youâve come. Itâs a moment to feel grateful for exactly where you are, which is rare when weâre always chasing the next thing.
And gratitude is a powerful feeling. It comes with a ton of positive side effects, from reduced stress to improved sleep (just to name a few!).
2. âď¸ Better encoding
When you write down your goals, youâre tapping into encoding, a biological process in which your brain decides whatâs worth storing in your long-term memory and whatâs worth forgetting.
Writing strengthens the encoding process. In other words? Writing down your goals makes you more likely to remember and then act on them.
3. 𫧠Forced clarity
The wildest part about an annual review? Answering why you want what you want next year might make you realizeâŚyou donât actually want it. This clarity can save you months (even years!) of heading down the wrong path.
Thatâs the power of a great question: It reveals what truly matters to you. And speaking of great questions, here are my favorite three to answer in my annual review:
1ď¸âŁ Based on your experiences in 2024, what do you want to do differently in 2025? New areas you want to explore or changes you want to make?
2ď¸âŁ What are you most grateful for in 2024? Is there anything you want more of that in 2025?
3ď¸âŁ What would you do if you knew you couldnât fail? Andâjust as importantâwhat would you still want to do, even if you knew youâd fail?
Happy journaling (and Happy New Year! đ).
Tired: A to-do list. Wired: Turning your to-do list into a video game with levels. đ°
Need to see all of your flagged emails? This new Outlook tip can help!
Three smart ways to hide your zeros in your Excel spreadsheet.
Forecasting in Excel doesnât require a bajillion hours. Try this instead. đ
This person on Reddit shared the morning routine that changed their life. âď¸
Thanks for reading! Scrambling to find a gift for your friends and family? Gift them a Miss Excel course! Itâs the perfect present for someone ready to level up their career in 2025 (and land that promotion theyâve wanted for months đ). Plus, you donât have to wrap it!
While weâre here, I wonât be in your inbox next week. Enjoy your holidays and see you in the new year! đ
Stay Exceling,
Kat