Failure is a cosmic redirect

Plus, dynamic screenshots šŸ’ƒšŸ¼

Happy Thursday, folks! šŸŒ»These past few days, Iā€™ve been thinking about confidence. Itā€™s a skill, meaning we can harness it with preparation and positivity. Looking for a raise? Prepare by collecting previous praise and successes. It wasnā€™t approved? Thatā€™s okayā€”now, youā€™re aware of your capabilities (and emboldened to apply elsewhere!). With a dash of knowledge and optimism, you can embody confidence. šŸ’«

Lights, Camera, Action šŸ“ø

Excelā€™s Camera feature is a great tool with no negatives (pun intended).

This tool allows us to take a snapshot of any selected graph, table, or range of data and paste it as a linked picture in a worksheet. The coolest part is if you make a change to your main workbook, itā€™ll automatically update the data in the picture, wherever itā€™s pasted.

Think of it as a dynamic screenshot. šŸ’ƒšŸ¼

But most people arenā€™t aware this tool exists because you wonā€™t find it on your Excel ribbon. To use it, youā€™ll have to manually pull this bad boy out. But here's why it's worth the effort:

ā€‹ā€‹āžœ Printing out specific data. Letā€™s say you only want to present the last two quarters of a companyā€™s earnings. You can copy and paste this data into an individual worksheet that fits on one printable page.

ā€‹ā€‹āžœ Working with large data. If your data are spread across several worksheets, the Camera feature helps you screenshot and pin data you want to keep track of.ā€‹ā€‹

āžœ Keeping data unmodified by other users. Because the Camera feature reproduces a live image instead of the actual data, users canā€™t make any changes to the image unless they have access to the original source material.

Hereā€™s how you go about adding the Camera feature to your toolbar on a PC: šŸ§‘ā€šŸ’»

Step 1ļøāƒ£: Right-click near the right-hand bottom of the Excel ribbon and select ā€˜Show Quick Access Toolbar.ā€™ 

P.S. Depending on the version of Excel you have, you might have to left-click ā€˜Fileā€™ > ā€˜Optionsā€™ > ā€˜Quick Access Toolbarā€™ instead! From there, follow the instructions at Step 3.

Step 2ļøāƒ£: Navigate to the left-hand side of the Excel ribbon and click on the downward arrowhead. Then select ā€˜More Commandsā€¦ā€™

Step 3ļøāƒ£: Switch ā€˜Popular Commandsā€™ to ā€˜All Commands.ā€™

Step 4ļøāƒ£: Scroll down to ā€˜Cameraā€™ (the list is alphabetical), click on ā€˜Addā€™ and press ā€˜OK.ā€™ 

Woohoo!

But now that itā€™s downloaded, how do you use it?

Select the cells youā€™d like to copy, click the Camera icon, and then click on wherever youā€™d like the data to appear. Yep, itā€™s that easy.

One last tip: You can use Excelā€™s Camera feature to paste data into Word and PowerPoint documents! Happy snappinā€™ šŸ“ø

Got Excel tips or tricks on your mind? Shoot me a line! Iā€™d love to hear both your questions and hacks. šŸ¤“

Failure is a Cosmic Redirect

ā€œUnfortunately, weā€™ll be delaying all promotions until next year.ā€ 

It was March 2020 and my company had just announced the bad news. I was bummed. Iā€™d been pumped (and working like nuts!) to possibly get promoted.

The bright side? Since I didnā€™t have to learn new skills for a new role, I had lots of extra time.

And this extra time was crucial in inspiring me to create and become Miss Excel. āœØ

When it comes to our defeats, roadblocks, or frustrations, weā€™re quick to label them as ā€œinconveniencesā€ with zero upsides. But as Marie Forleo, entrepreneur extraordinaire, reminds usā€¦

ā€œDonā€™t be so quick to judge your supposed failures. A flop might be a cosmic redirect, guiding you to a better, bigger purpose.ā€ 

Or as your Millennial manager might put it, ā€œItā€™s just one flop. Itā€™s not a flop era.ā€

On a serious note: Whenever I run into the unexpected, I tell myself itā€™s either a lesson or a blessing.

When the possibility of a promotion disappeared, I couldā€™ve sulked. Instead, I convinced myself it could be a good thingā€”I just had to keep my eyes peeled for the silver lining. šŸ‘€

Because to some extent, ā€œbad thingsā€ are subjective. As Shakespeare says, ā€œThere is nothing either good or bad, but thinking makes it so.ā€ Itā€™s our mindset that determines whether an event is an obstacle or an opportunity.

Hereā€™s what I meanā€¦

šŸ’°You lose the promotionā€”but find more time to focus on your passion project. (šŸ‘‹)

šŸ”The place you wanted is takenā€”but three months later, you find your dream home.

šŸ“ˆ You get rejected from a job for the 20th timeā€”but realize youā€™re now one ā€œnoā€ closer to your dream job.

I try to go through life with the mantra that life happens for me, not to me. You get to decide if a disappointment will bog you downā€”or if itā€™s a blessing. 

If you feel like giving up, this quote from author James Clear might help:

ā€œThis moment when you donā€™t feel like doing the work? This is not a moment to be thrown away. This is not a dress rehearsal. This moment is your life as much as any other moment. Spend it in a way that will make you proud.ā€

This moment of your life, reading this newsletter, is just as important as any other. The right time is nowā€”so go out there and make it count. āœØ

Stay Excelent, 

Kat