- The Workbook
- Posts
- What dessert taught me about confidence š«
What dessert taught me about confidence š«
Plus: Never lose your active cell again
Hey there! Meet Cindy. She dreads work because when her boss asks her to clean up messy data and create organized spreadsheets in Excel, she has no idea where to begin.
The result? Cindy gets overwhelmed and nervous about her job security.
That āļø is why Iām hosting another free live Excel class on optimizing your spreadsheets with Data Cleaning and VBA Macros! Because Cindy shouldnāt feel like this (and neither should you).
Hereās the class schedule:
Wednesday, March 20 at 3 PM ET
Thursday, March 21 at 12 PM ET
Friday, March 22 at 12 PM ET
If you canāt attend live, youāll get the automatic 48-hour replay once you register!
Create Your Own Excel Legend in Microsoft Designer
Who is your Microsoft Excel legend? š¦øāāļø
Is it the Macro Maverick, who creates and manipulates macros at lightning speed? Or maybe itās the Pivot Pro, who can be found dominating the PivotTables?
Whether you consider yourself a Never-Mouser or a Table Titan, you can now create your very own Microsoft Excel Legend to represent your Excel superpowers with Microsoft Designer.
To get started, simply click on the suggested prompt of the legend that best aligns with your Excel superpowers and sign into Microsoft Designer to customize. Itās fast, free, and easy to get creative and customize your own!
Who will your Microsoft Excel Legend be? š
Sign up for Microsoft Designer and find out today!
Never Lose Your Cell Again With VBA Macros
WiFi dropping out mid-Zoom call. Forgetting to cancel your subscription after that 30-day free trial. Losing your active cell in a large and complex Excel spreadsheet. Itās the little things that drive us nuts. š
While I canāt help with those first two, Iāve got you covered for that last one. Hereās how to never lose your active cell in Excel again (with the help of VBA!):
Step 1) Right-click on your sheet tab and select View Code.
Step 2) In the dropdown, select Worksheet. Then, copy and paste the following code:
Cells.Interior.ColorIndex = xlColorIndexNone Target.EntireColumn.Interior.ColorIndex = 42 Target.EntireRow.Interior.ColorIndex = 43 Target.Interior.ColorIndex = xlColorIndexNone |
Step 3) Watch as your rows and columns light up. Your cursor is now a breeze to find!
This tip wonāt just save you tons of timeāitāll prevent you from the common mistake of entering data in the wrong place because you lost your cursor in the spreadsheet (the worst).
š” P.S. āIāll be sharing more game-changing VBA tips in my upcoming Excel class! To sign up, save your seat right here.
What Brownies Taught Me About Confidence
Itās 2016 and Iām on a group skiing trip with Mike, my boyfriend of six months. Weāre playing one of those āHow well do you know your partner?ā games when someone asks him:
š¬ āWhatās Katās favorite dessert?ā
I have no clue what my favorite dessert is. But Mike says, without an ounce of hesitation, āBrownie a la mode.ā
I donāt even know what ābrownie a la modeā is. But the sheer amount of confidence this man is exuding had me wondering, āWait, maybe that is my favorite dessertā¦ā
This is where I learned the power of saying things with confidence. If it could influence something as silly as dessert preferences, imagine how it could impact the bigger areas of our lives.
So, I started practicing this verbal confidence in micro situations:
ā I requested a 15% raiseāwithout apologizing or second-guessing myself.
ā I led a team meetingāeven though I thought I wasnāt ready.
ā I interviewed for a job at a big-shot companyādespite not meeting every qualification.
The habit eventually became second nature. I stopped underplaying what I believed to be trueāand even gained the confidence to leave the corporate world to launch Miss Excel!
So hereās my challenge to you: Take a tip from the Mikes of the world and try saying something with full, unquestionable confidence. It could be as simple as reciting your coffee order or telling someone about your job.
It seems insignificant, but those small acts of confidence can add up to some big life changes.
Hereās how to duplicate your screen on Excel (and save money on a second monitor!).
āThis is a game-changer š„ā says a comment under my video on reversing Excel data.
If youāre about to go OOO and donāt want to be bothered on Outlook, Iāve got you.
I love this subreddit on all the best productivity apps!
I was featured on the Bossy Podcast with icons Tara Reed and Katie Gatti Tassin! Tune into our episode to learn how to go viral on social media, which top trends to leverage for your business, and how I work just 15 hours a week.
Stay Excelent,
Kat