The 7 Excel Tricks Every Office Worker Should Know [Infographic]

September 28, 2015

Computer technology moves fast -- which is why it's so hard to believe that a computer program that's been around for 30 years is still one of the most popular programs in the world. And yet, I'm willing to bet every single one of you has had to use Microsoft Excel at some point in your life.

Nowadays, most office workers are simply expected to know basic Excel functions -- so much so that many recruiters suggest you shouldn't even bother listing it on your resume. "I swap 'Proficient in Word, Excel and PowerPoint' for 'Proficient in Breathing Oxygen,'" quipped the founder of Mergers & Inquisitions.

Beyond creating basic charts and graphs, there are a few other Excel tricks that everyone working in an office should know. For instance, it's really helpful to at least have a basic understanding of how to create pivot tables and VLOOKUPs. (Don't worry -- it's easier than it sounds.)

From charting to conditional formatting to pivot tables, check out the infographic below from Microsoft Training to learn the top seven most useful Excel tricks everyone working in an office environment should be familiar with. (And read this blog post to learn these tricks and others in more detail.)

What other Excel tricks do you find handy? Share with us in the comments.

free excel templates for marketing

Read more...

Previous Article
The Beginner's Guide to Retargeting Campaigns [Free Ebook]
The Beginner's Guide to Retargeting Campaigns [Free Ebook]

For those of you who have heard of retargeting and think it's something you want to try, you're ...

Next Article
From HBR to Mashable: How to Be a Guest Writer on 11 Popular Sites
From HBR to Mashable: How to Be a Guest Writer on 11 Popular Sites

Guest blogging is a wonderful and mutually beneficial relationship between writer and publicatio...

×

Join the Phoenix HubSpot User Group

First Name
Company Name
Thank you!
Error - something went wrong!