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

first_img12K+SaveWhat other Excel tricks do you find handy? Share with us in the comments. Originally published Sep 28, 2015 12:00:00 PM, updated December 10 2018 Topics: Excelcenter_img 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.)Download 9 Free Excel Templates for MarketersFrom 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.)12K+Save Don’t forget to share this post! AddThis Sharing ButtonsShare to TwitterTwitterShare to FacebookFacebookShare to Email AppEmail AppShare to LinkedInLinkedInShare to MessengerMessengerShare to SlackSlacklast_img

Leave a Reply

(*) Required, Your email will not be published