• The Workbook
  • Posts
  • You should quit more often šŸ™‡ā€ā™‚ļø

You should quit more often šŸ™‡ā€ā™‚ļø

Plus: The IMPORTRANGE function

Hello and happy fall! šŸ‚ It’s Q4, which means we’re heads-down here at Miss Excel HQ to hit all our goals before the year wraps up (can you believe it’s only 88 days away?!) I won’t share everything just yet, but we’re revamping the Excelerator course and I cannot wait to get it in your hands. Stay tuned!

A Round of Applause for IMPORTRANGE šŸ‘

šŸ—£ Please give it up for Google Sheets’ IMPORTRANGE function! This function lets you import a range of data from a different spreadsheet. Give yourself a preemptive round of applause for all the time you’re about to save.

Let’s dive into an example:

Say you’re a data analyst and you have access to the Q1 sales data of another company (let’s call it Cali Sunshine Real Estate ā˜€ļø). Your goal is to import all of the information below (cells A1 to D20) into your centrally aggregated spreadsheet.

However, you don’t want to copy-paste the data manually. This method is prone to errors, tedious, and a waste of your expertise. That’s when the IMPORTRANGE function comes into play. It’ll pull this data for you in a cinch—here’s how!

Step 1ļøāƒ£ Select any cell. This is where you will be importing the range (let’s go for B7 for our example!).

Step 2ļøāƒ£ Type =IMPORTRANGE and the spreadsheet URL. In our case, the spreadsheet URL is in cell B5, so our function is =IMPORTRANGE(B5

Step 3ļøāƒ£ Enter the range of the data you want to import. Because we’re doing the entire dataset, our formula is =IMPORTRANGE(B5,ā€œSheet1!A1:D20

Step 4ļøāƒ£ Close the parentheses. Our final formula is =IMPORTRANGE(B5,ā€Sheet1!A1:D20ā€)

Important to Note: āš ļø  The formatting isn’t perfect. The function sometimes won't transfer certain fonts or merged cells, so just be aware!

However, IMPORTRANGE redeems itself with this special quality: ✨ It updates in live-time āœØ. For example, if Cali Sunshine revised Katherine Gomez’s sales from $75,000 to $200,000, our spreadsheet would automatically reflect that change.

No need for the team at Cali Sunshine to give you a heads-up! Now that’s what I call efficient communication. šŸ˜Ž

FYI: This tip came straight from my Sheets Smart course! Use the code SHEETS20 for a 20% discount if you’re ready to spend less time fumbling with spreadsheets and more time doing what you love. šŸ“ˆ

You Should Quit More Often

For most of my life, I saw quitting as a last (and I mean last) resort option. 🫠

Whether it was taekwondo, Irish step dance (I was an…interesting child), or a full-time job, the idea of quitting has always filled me with uneasy emotions. I ended up holding onto a lot of goals, projects, and relationships that no longer served me.

Then in January 2021, I had to challenge my beliefs on quitting. Miss Excel was starting to earn more money than my 9–5. While I loved my company and invested countless hours into my career, keeping the role didn’t align with my future priorities.

Instead of quitting being a ā€œbadā€ thing, it was exactly what I needed to do to grow.

That’s when I realized: There’s power in quitting. To find that power, it’s up to us to flip our internal scripts from quitting being a ā€œnegativeā€ thing to a ā€œpositiveā€ one. Here’s what I mean:

Quitting as a Negative: šŸ“‰

  • āžœ Scarcity: ā€œIf I let go of [XYZ], I might not ever get it again.ā€

  • āžœ Ego: ā€œI can’t quit! My identity is tied to [insert job, project, relationship, etc, here]ā€.

  • āžœ Fear: ā€œI’ve heard the saying ā€˜quitters never win’ and don’t want to be seen as a failure.ā€

Quitting as a Positive: šŸ“ˆ

  • āžœ Growth. ā€œMy values have shifted and this doesn’t align with me anymore. I’m growing!ā€

  • āžœ Abundance. ā€œThere are more opportunities out there, and I’ll find what’s right for me.ā€

  • āžœ Knowledge. ā€œI tried [XYZ], and realized it’s not for me. I’ve learned a lot!ā€

Ultimately, quitting is a neutral event—and we have the power to give it either a positive or negative charge. When you view it as a positive, you’re more likely to actually ask productive, meaningful questions: How have I grown? Is there something better out there for me? Is this giving up or moving on?

This lets you see quitting for what it can be: A force that propels you in the right direction, rather than a fear that holds you down. šŸ’«

  • What do the most productive people in the world have in common? šŸ™‡ā€ā™‚ļø This video finds out.

  • How to share your Outlook calendar availability in 17 seconds flat.

  • Three ways to boost your efficiency at work using OneNote. šŸ§‘ā€šŸ’»

  • You want to apply for a job…but you don’t meet the requirements. 😬 Here’s why you should apply anyway.

  • Do you know how to add the Developer tab to your Word document? Now you do.

Thanks for being here! Now here’s a reminder to go and get ā€˜em from this amazing fellow entrepreneur.

Stay Exceling,

Kat