- The Workbook
- Posts
- Celebrate your screw-ups đ
Celebrate your screw-ups đ
And how to calculate percentages in Excel
Hey! In last weekâs newsletter I asked, âWhatâs your worst Excel advice?â and some of your responses were scary good. Here are some honorable mentions:
âCSV files are super reliableâ
âThe more tabs open, the betterâ
âYour boss wonât mind if you send them a file named âSheet 1ââ
Iâll let this GIF sum up how I feel about you doing any of these things đ
Calculate Percentages in Excel
Are you still calculating percentages like this? đ
If so, Iâve got a little-known Excel tip for calculating percentages thatâll make your life much easier. I posted a video on this and one person commented, âI swear as soon as I start feeling good about Excel, someone shows me I know nothing.â LOL. I am here to help!
Step 1) Highlight the numbers you want to do a percentage of and select the âQuick Analysisâ pop-up.
Step 2) Navigate to the âTotalsâ tab.
Step 3) Scroll all the way to the right and select the next-to-last option to add âPercent Totalâ in another column.
There you have it. Now youâre one step closer to mastering Excel đ (and it only took two minutes to learn!).
Celebrating Your Screw Ups
So, you messed up.
Maybe you accidentally deleted your companyâs confidential files (calling myself out here đ« ). Maybe you got fired. Or maybe during your HBO Max internship, you sent a rogue email to a sizable portion of the customer base (true story).
Whatever it was, failure is almost never a warm and fuzzy feeling. The last thing you want to do is crawl out from under your rock to celebrate. But trust meâthereâs value in honoring your screw-ups.
My perspective on this shifted when I learned how Sara Blakely, the founder of Spanx, approaches her failures.
She said, âMy dad used to encourage my brother and me to fail growing up. He would ask us at the dinner table, âWhat did you fail at this week?â And if I didnât have something to tell him, heâd be disappointedâŠfailure became about not trying, versus the outcome.â
Thatâs when I realized: Failure means you went for itâand thatâs worth celebrating.
After all, if you knew that accomplishing [insert dream here] would require at least 99 failures, wouldnât each one inspire you?
And heyâthis doesnât mean failure wonât sting (it most certainly did when someone corrected my Excel presentation live in 2018). Instead, this is just a reminder that a screw-up is not a setback.
Because hereâs the truth: The journey to reaching your goal isnât all up and to the right. Itâs more like a spiral upwards full of wins and losses, where each failure and success compounds.
And as long as youâre moving forwardâfailures and all!âthatâs what counts.
To quit or not to quit. If youâre contemplating leaving your job, this guide will help you navigate the decision. đŒ
Loved this article on how to build an online presence that works for you instead of against you!
Ever wonder which day of the week youâre most productive? What about how many checklist items you complete week over week? Office Otter tracks these metrics (and more!) automatically. Start taking stock of your tasks and your time here.*
This thread is packed with great tips on how to be more creative (definitely going to try out âThe Evil Twinâ technique đ).
Few things are as life-changing as knowing how to color-code your Outlook inbox.
Are you in your budgeting era? đž Here are four (free) Google Sheets budget templates.
The Hustle is a daily newsletter on a mission to tell you about the growth, trends, and innovation driving business and tech news. Want to stay informed and have some fun? Get The Hustle in your inbox.
*This is sponsored advertising content.
If you type âdoc.newâ into your browser, Google Docs will automatically create a new document for you in seconds. đ Who doesnât love a shortcut?!
Stay Excelent,
Kat