• 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ā€¦

  1. Let them continue tediously typing ā€œunitsā€ into every single cell? 

  2. 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: 

  1. 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

  2. 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). 

  3. 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