Excel 2016: Tips and Tricks to Make Using the New Microsoft Excel Easier

Written by Laura Schomaker
Published on July 28, 2017

You may be a business analyst, finance or accounting professional or project manager. But, if you’re reading this, you probably spend much of your day working with Excel. To help you do more in less time, I will share with you five time saving tips for the new Microsoft Excel.

Even if you’ve been using Microsoft Excel 2016, the latest version of Excel for a while now, I bet at least one of these tips will teach you something new. If you find these tips helpful, leave us a comment below to let us know which one is your favorite. Now, let’s get to it!

Microsoft Excel 2016 Tip #1: Smart Lookup

With Smart Lookup powered by Bing, you can access all the information available on the World Wide Web without ever having to leave Excel. To use Smart Lookup, all you must do is type a search term in the box at the top of the ribbon that says, “Tell me what you want to do…” Then, a sidebar labeled, “insights” will open with a variety of information and links relevant to your search.  If you decide you want to explore one of them further, just click it.

Microsoft Excel 2016 Tip #2: One-Click Forecasting

With Excel 2016’s forecast sheet button, you can easily use historical data to create charts that predict things like future consumer trends, inventory requirements or sales. Don’t waste time entering all the formulas by hand. Just enter your data, press the forecast sheet button and Microsoft Excel takes care of the rest.

Microsoft Excel 2016 Tip #3: 3-D Maps

With the 3-D maps tool in Microsoft Excel 2016, you can easily make cool 3-D maps and models that help you uncover patterns in your data as they relate to location and time. For example, if you work for an energy company you might use these 3-D maps to show you which of your plants is outputting the most energy. Or, you’re in retail and want to see profitability by store or region.

Microsoft Excel 2016 Tip #4: Ink Equation

Have you ever tried to write an equation in Microsoft Excel, or Word, just by selecting from the available symbols? If you have, you know it can be tough. So, in the latest version of Microsoft Excel, a new feature that makes this much easier. With ink equation, you can use your mouse (on a computer or laptop), or your finger or touch stylist (on a tablet, or other touch device) to write equations by hand. Excel will then convert what you write into text and symbols.

Microsoft Excel 2016 Tip #5: Co-Authoring

How many times have you been collaborating with a coworker on a file and found it very cumbersome and confusing to keep emailing revised copies back and forth? It is easy to lose track of which file is the most recent version. But not anymore. The co-authoring feature introduced with the new Microsoft Excel lets you store your document in the cloud and give a link to it to anyone you would like to have view or edit the file. Even people outside your organization. Thus, you can be confident everyone is working on the same file and has the latest version.
Want to upgrade to Microsoft Excel 2016?  Consider Office 356. It gives you access to the latest and greatest versions of all the Microsoft office tools you already know and love. Plus, a bunch of other cloud applications. Learn more.

Latest Articles

Related Articles

Acumatica Pro Tip: What Is Acumatica Open University and Why Should I Use It?

When you’re new to it, learning new software can be frustrating. But I have great news for Acumatica users. Acumatica Open University takes the stress out of the training process. Whether it’s your first day using the system or you’re a seasoned user looking to learn something new, Acumatica Open University has you covered.

Acumatica Pro Tip: Acumatica Mobile App Setup, a How to Guide

Do you work outside the office, have you ever wished you could take Acumatica with you? Well I have great news there’s a mobile app for Apple and android smartphones and tablets that put the power of Acumatica in your pocket. And the best part is, all it takes is seven simple steps to get started.

Top 10 Technology Blog Posts for 2019

With 2020 quickly approaching, we thought it’d be fun to look back at our top 10 technology blog posts for the past year. This year’s list is a great mixture of tips and tricks for current users of Acumatica and Microsoft software solutions, plus expert advice for people in the market for a new ERP.

Acumatica Pro Tip: Keys for a Successful Acumatica Year End Closing

With any accounting system, there are tasks you must do to close out each year. And while many of the general principles remain the same, each system is a bit different. So, last week we brought you our year end close guide for Dynamics GP users, and this week we bring you one for Acumatica users.

Acumatica Pro Tip: Eight Simple Steps for Acumatica Password Reset

Not being able to remember your password when you need to log into an important system like your bank account or your ERP system can be a very frustrating experience. Luckily, most online services have a streamlined the process for retrieving or resetting a lost password. Acumatica is no different. The Acumatica password reset process is easy.

About the Author

As the head of marketing for Intelligent Technologies, Inc., my goal is to educate our current and prospective customers, helping them to navigate the complex technology buying process. If you have questions about our products and services, or would like to learn more about working with us, let me help you get connected to the right person. Message me via the chat window on our website or call (336) 315-3935 x5007.


Submit a Comment

Your email address will not be published. Required fields are marked *