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

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

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s