- The Workbook
- Posts
- Higher-ups are intimidating đ«Ł
Higher-ups are intimidating đ«Ł
Plus: Save your boss' day
Hey there! Tomorrow is a special day: Itâs my birthday! đ Where my fellow Capricorns at?! To celebrate, Iâm doing a 50% OFF flash sale on ALL Miss Excel courses and bundles to help you level up on everything Microsoft Office! Hereâs the âš birthday surprise âš: Newsletter subscribers (thatâs you!) get exclusive early access! The sale officially starts Friday but you can grab it now with the discount code BIRTHDAY50.
Donât waitâthis deal wonât last long (and neither will my cake đ ).
Become Your Bossâs Favorite Person đ€©
Imagine youâre at the office when you overhear your boss saying âThereâs so much data, but I only need four columns. Can anyone help?â
Will youâŠ
A) Say nothing. I donât know how to fix that! đ€·
B) Become their new favorite person and show them a better way. đ
Personally? Iâm all for Option B (thatâs why youâre reading this newsletter, after all!). Hereâs how youâd fix your bossâs problem in seconds:
Step 1) Start with =XLOOKUP
Step 2) Select Lookup Value and Lookup Array.
Step 3) Type CHOOSECOLS(
Step 4) Highlight table
Step 5) Select desired columns
Our formula is now =XLOOKUP(B20,B1:B15,CHOOSECOLS(A1:I15,1,7,9,5))
đĄ Excel Tip: The CHOOSECOLS function does exactly what it sounds likeâit extracts specific columns from an array or range.
Step 6) Drag down and youâre all set!
BOOM! You just solved your bossâ problem. đ„
Just Getting Started With Excel?
Have you heard of the â20-Hour Rule?â
It says that with just 20 hours of focused practice, you can go from a beginner to competent in almost any skill. And that includes mastering Excel!
Thatâs where the Excelerator Course comes in. This course is full of bite-sized, easy-to-understand lessons that are actually fun and make those 20 hours fly by. đš
And if you already have some Excel skills? This course is for you, too! As Amanda will tell you, youâll definitely learn something new:
Even better? The Excelerator Course is part of the birthday sale! đ„ł Be sure to use the code BIRTHDAY50 at checkout.
How to Talk to Higher-Ups đŒ
Talking to people in charge can feel intimidating, especially early in your career. Something about the âChiefâ or âSeniorâ in someoneâs title makes us second guess everything we say. đ«
POV: Youâre having âsmall talkâ with the VP đ«
But youâre going to have to interact with higher-ups at some point, whether it be in interviews, meetings, or performance reviews.
And thatâs a good thing! These people can teach you, inspire you, and change the trajectory of your career. So here are my three best tips to connect with your higher-ups:
đ Remember theyâre human, too. The bigger someoneâs title, the easier it is to put them on a pedestal. But strip away that fancy LinkedIn header and youâll find a human being who has hopes, fears, and a favorite Netflix show.
âïž Do your research. Review their work history on LinkedIn, see if they have a website or portfolio, andâdepending on the industryâthey may have op-eds or podcasts to check out. This research will help you ask them thoughtful, non-generic questionsâswapping the surface-level chit-chat for meaningful conversations.
đ Share a laugh (when appropriate). Laughter is a shortcut to building strong relationships. But be sure to avoid self-deprecating humor (âIâm just an intern!â).
One last thing: Although you might not have the years of experience that your superiors do, there are other things you bring to the table. Warmth, attentiveness, and tenacity are all strengths that can leave a lasting impressionâproving you belong in the room no matter whoâs sitting across from you. âš
How to add a signature to your Excel spreadsheet in 30 seconds!
Did you know you could add watermarks to your Word document?
âWow,â says a comment on my Dynamic Time Functions tip! đ
Iâm obsessed with this immersive sound bath on Spotify. đ§
This Reddit list of 10 Excel tips was upvoted 945 times. đ
We want to better understand how we can support you in 2025!
Would a paid service to help you troubleshoot and/or build your spreadsheets be something youâre interested in? |
Stay Exceling,
Kat