- The Workbook
- Posts
- 3 life-changing books
3 life-changing books
And how to get your zeros to stop ghosting you
Hey, you! đŚ Thanksgiving is around the corner, which means I wonât be in your inbox next Thursday. So, what are you grateful for this year? For me, it's the road trip I took with several pals through Scotland this October. It was truly something else. â¨
Why Your Zeros in Excel Keep Ghosting You
If youâre out and about in the dating world, thereâs a solid chance that someone has ghosted youâor youâve ghosted someone (donât worry, Iâm not judging!).
If you have been ghosted, youâre not alone! A 2018 study found that a quarter of its 1,300 participants had been ghosted by a partner. đ
At least our Excel worksheets would never do that to us, right?
Unfortunately, wrongâthanks to zeros in Excel. đ If youâve ever tried to input leading zeros, you mightâve noticed they vanish in a blink of an eye.
The good news: This annoying problem has an easy two-step fix! Which is far fewer steps than it took to delete all traces of your situationship from your social media. đ
Step 1ď¸âŁ: Add an apostrophe in front of your value in the formula bar. This forces Excel to treat the cell as a text value, cementing your zeros.
Step 2ď¸âŁ: Once you see the green flag, click the upper right hand corner and select 'Ignore Error.' Now, the zeros stay put. (Hereâs a video of this tip in action.)
This solution is best for when youâre logging information such as phone numbers, zip codes, or social security numbers and donât need to perform any calculations.
But letâs say you do need to crank out the calculator. No sweatâyou can use a custom number format! To get there, first navigate to the dropdown in the Number tab on the ribbon and select 'More Number Formats.'
From there, go to 'Custom' and insert how many zeros youâd like your numbers to have.
All done! Now, if you need to make any calculations, Excel will treat the data as numbers (not text), helping you avoid mathematical errors. Phew!
While we canât control who ghosts us in our dating lives, itâs nice to know that when it comes to zeros, we can make âem stick around. đ
Do you have an Excel conundrum weighing you down? Hit me with it! Iâd love to possibly feature the solution in a future workbook.
The 3 Books Thatâve Changed My Life
Whether youâre a voracious reader or more of an â¨"Iâll wait for it to come to streaming"⨠kind of person, Iâm sure you have at least one book thatâs helped shape you into the person you are today.
Thatâs the power of books. They can change our lives in so many ways. They can be a guide, a beacon of inspiration, or a time machine. Books are also proven to improve mental flexibility, deepen empathy, and reduce stress. Boom! đĽ
Whatâs best about reading is that itâs an active rather than passive activity. Iâm sure youâre thinking, âKat, thatâs cute but what do you mean?â I can explain!
According to the NYT, making time for activities that are âeffortfulâ (active) instead of âeffortlessâ (passive) can make your time feel more abundant and expansive. Because reading requires intentionâbut is also enjoyableâit energizes you.
So without further ado, the three books that have changed my lifeâwhich Iâm sharing in the hope that it inspires you to read over Thanksgiving break. đ¤
1) Breaking The Habit of Being Yourself by Dr. Joe Dispenza
When I wanted to upgrade my mindset, I needed some cold, hard facts for my analytical brain to get on board. Cue Dr. Joe Dispenza and his book that explains quantum physics, neuroscience, and brain biology to show us what weâre capable of.
2) You Are a Badass by Jen Sincero
I can summarize the impact this book had on me with this quote: âIf you want to live a life youâve never lived, you have to do things youâve never done.â This book lit the fire under my đ to put myself out there to get the life I always wanted.
3) Dotcom Secrets by Russell Brunson
From a strategy perspective, this book was *chefâs kiss*. I learned about online sales funnels (more fun than it sounds), generating leads, and selling digital products. If youâre thinking about launching your own online business, I highly recommend it!
Although reading has a *bunch* of health benefits, its capacity to change your life rests on you applying your newfound knowledge. So run over to your local libraryâyou never know which book might just change everything.
Dear {FirstName} weâve been trying to reach you about your (investment) vehiclesâ extended warranty losses
Weâre giving you a final courtesy wake-up call. This is one call you donât want to send to voicemail (sorry Grandma, can you text next time?). Because with personal portfolios dropping a whopping 44% this year, this is a call to renew your investing plan.
With Masterworks. This unicorn investment platform lets everyday people invest in museum-quality artworks by names like Picasso and Banksy. Not only has contemporary art outpaced the S&P by 131% over the last 26 years, but it also remained resilient through downturns like the dot-com bubble and Great Financial Crisis.
The only problem? Every offering is limited, and shares can sell out fast. It makes sense when seven of Masterworksâ last eight exits realized a net return of +17.8%.* Seven?! Thatâs even more than the number of spam calls I get dailyâŚ
Fortunately, The Workbook readers can skip the waitlist with this exclusive link.
See important Regulation A disclosures.
This clip of Lili Reinhart on Jay Chettyâs podcast helped me zoom out and see the big picture of this wild experience we call life.
Hereâs why some of the worldâs most confident people (like BeyoncĂŠ) create alter egos.
Add this Microsoft Teams app and youâll never look back. Youâve heard about how much we love Office Otterâthe productivity tool that makes managing your to-do list simple and efficient. With their new app, you can create tasks for yourself directly from Teams conversations. Check it out.*
Speaking of reading, Project Gutenberg is a website with over 60,000 public domain eBooks you can download for free!
If youâre looking to add some flair to your Word document with stylish lines, check out my mini tutorial!
Jay Clouse is projected to earn $300K in 2022 as a creator. đł Here are the revenue streams he uses.
*This is sponsored advertising content.
In the spirit of Thanksgiving, Iâd love to knowâhow do you practice gratitude?
If youâre like most folks, you write down a gratitude list. But according to Dr. Andrew Huberman, the best way to practice gratitude is by receiving or perceiving it.
This could be listening to a kind letter written about you (receiving) or hearing a story about someone getting help (perceiving).
Then, distill the content into bullet pointsâand read your short summary a couple of times a week to stimulate your sense of gratitude.
The benefits of this practice (increased motivation and decreased anxiety, just to name a couple) are almost too good to be true. Now thatâs something to be grateful for. đ
Keep Excelerating,
Kat