- 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.
Fun fact: I send one āshoot your shotā email or DM a day.
Make your own luck.
ā Amanda Goetz (@AmandaMGoetz)
3:44 PM ⢠Sep 8, 2023
Stay Exceling,
Kat