- The Workbook
- Posts
- How to be more creative at work š©āšØ
How to be more creative at work š©āšØ
Plus: The shortcut your boss will *love*
Hey! Stop me if this sounds familiar: ā Itās typical for you to waste dozens of hours in Excel on something that you know could take minutesā¦if only you knew the right shortcuts and functions.
Letās stop that cycle now, shall we?
Come to my free live Excel class! In just 60 minutes, youāll learn how to optimize your spreadsheets (and save your sanity) with Lookup Functions and Shortcuts.
By the end, youāll become the Excel wizard you know you can be. Best part? Excel will go from a time-sucker to a time-saver. Save the date:
Tuesday, May 21 at 3 PM ET
Wednesday, May 22 at 12 PM ET
If you canāt attend live, no sweatāyouāll get access to a 48-hour replay when you register. See you soon!
Simplify Your Businessās Financial Workflows
Financial operations for businesses are needlessly complex. Not only do founders need to use multiple tools to manage their financial workflows, then those tools have to integrate with your banking.*
Mercury solves this broken system by combining it all: software that powers your critical financial workflows all housed within your business bank account! Having these workflows powered by banking allows you to:
Get complete and accurate visibility into all money movements
Control how and when money flows in and out of your business
Close the books faster
Ready to join the over 200k startups (like yours truly šš¼āāļø) that simplified their finances with Mercury? Apply in minutes.
*Mercury is a financial technology company, not a bank. Banking services provided by Choice Financial Group and Evolve Bank & Trust; Members FDIC.
The Time-Saving Excel Shortcut Hardly Anyone Knows
POV: You glance over your bossā shoulder and see them doing this: š
Are you going toā¦
Let them continue tediously typing āunitsā into every single cell?
Become their new favorite person by showing them a handy Excel shortcut?
Now, you wouldnāt be reading this newsletter if you didnāt want to choose option two. š So let me show you how itās done with the Format Cells dialog box.
Ready? Letās go:
Step 1) Select your data (in our case, thatās C2:C26).
Step 2) Press CTRL + 1. This shortcut displays the Format Cells dialog box.
š” Excel Tip: The Format Cells dialog box sets the formatting options (font color and size, background, borders, alignment, etc) for your cells.
Step 3) Go to Custom
Step 4) Next to General type āUnitsā
Step 5) Press āOkā and youāre done!
Looking for more time-saving Excel tips like this one? I got you!
Weāll cover tons more in my free live Excel class happening later this month. Save your spot today!
3 Steps to Be More Creative (So You Can Crush It at Work)
āI have no creative outlet.ā This was the lie Iād been telling myself for years ever since joining the corporate world, keeping me in my comfort zone and allowing me to justify the more conventional career path.
But one day, I realized that justā¦wasnāt true. Creativity is always with youāitās not just something that disappears once you have a 9ā5. And with that realization? I built a seven-figure business, amassed millions of followers, and created thousands of pieces of content.
I can say it from experience: Creativity. Changes. Lives.
As Lady Gaga will tell you: THIS is how it feels to get in touch with your creativity
āBut Kat, Iām not an entrepreneur. Iām in Microsoft all day!ā youāre thinking. Listen, you still need creative thinking at your day job! It can help you:
ā Brainstorm that perfect Excel formula for intricate spreadsheets.
ā Determine which co-workers are best suited for a particular task.
ā Create drop-dead gorgeous PowerPoints to impress your boss.
On board? Great! Hereās my three-step process to unleash your creativity:
Schedule Your Creative Blocks šļø When did you last clear your calendar for creative thinking? I regularly schedule āLeft-Brain Daysā in my calendar (best for creative flow states) to let the ideas flow through. I give myself at least 2ā3 hours!
Clear the Gunk. š° When you sit down to brainstorm, youāll need to āturn onā what writer Julian Shapiro calls your creativity faucet. This means first clearing out āgunkā of bad ideas (AKA brain-dumping) before you can eventually get clear water (i.e. brilliant ideas).
Messy Action. š Your creative idea wonāt be perfectāand thatās okay. Take messy action by getting it out into the world before youāre ready. There have been so many times I wasnāt sure about my ideaā¦only to see it resonate with thousands.
Just remember: Creativity is a skillānot a trait. That means, like any skill, it can be learned with a bit of practice and determination. Now go out there and let your ideas flow.
Did you know you could schedule alarms in your PowerPoints? Now you do.
The OFFSET function is ideal for those who have tons of data in their spreadsheets.
The two life hacks this person has used over the past 25 yearsāand swears by.
If your attention span is this š¤ short you need these 11 tools to double your focus.
Four XLOOKUP tricks I bet youāve never heard of before.
Thanks for being here! I just got back from Palm Beach after celebrating my partner Mikeās birthday! It was such a blast but Iām so glad to be homeāIām buzzing with tons of new ideas for you all.
Stay Exceling,
Kat