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

9.30.15 Excel Tips

Story provided by Hubspot

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.)

9.30.15 Excel Infographic

Tags: Excel tips, excel tricks, HubSpot, Lindsay Kolowich. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s