<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1657797781133784&amp;ev=PageView&amp;noscript=1">

Where Marketers Go to Grow

September 28, 2015

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

Written by | @

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

Topics: Office Life

Subscribe to HubSpot's Marketing Blog

Join 300,000+ fellow marketers! Get HubSpot's latest marketing articles straight to your inbox. Enter your email address below:


Sorry we missed you! We close comments for older posts, but we still want to hear from you. Tweet us @HubSpot to continue the discussion.