Family Encyclopedia >> Work

3 awesome Excel 2016 tricks you overlooked

With each round of major updates to the Microsoft Office suite. Automatic Updates in Microsoft Office 2016 Automatic Updates in Microsoft Office 2016 Explained Microsoft Office 2016 will run an automatic update feature and a number of different branch services similar to Windows 10. Let's explore what that means for your Office 2016 installation. Read More 3 File Extension Tips Every Microsoft Office User Should Know 3 File Extension Tips Every Microsoft Office User Should Know There's a lot to know about Microsoft Office, but these basic tips are simple and helpful. and must be learned by all. Without exceptions. Read more . Sometimes you get attacked so thick and fast that it's hard to keep up.

Even People Who Thought They Knew Every Trick in the Book Be the Smartest Person at Work With These Excel Tricks Be the Smartest Person at Work With These Excel Tricks Excel is a powerful tool. At first glance, it looks like a bunch of boxes you type numbers into, but it does so much more. Read More Here are three awesome Excel 2016 tricks that you'll definitely (ok, probably) ) ignored.

1. Tell me how...

Excel is a sprawling behemoth of an application. Sometimes you'll see a shared file at work, college, or online, and you can't believe it was created using a spreadsheet application. How can you, an Excel noob, expect to achieve such impressive results?

The answer is simple:make use of the Tell me box.

It will save you searching through the ribbon for hours and will even keep a list of previous tasks you have searched for. You find the box on top of the tape. Just start typing your query to find results.

3 awesome Excel 2016 tricks you overlooked

2. Smart Search

When you're trying to do research while working in Excel, the need to constantly switch windows can be annoying. Sure, it might not matter if you're on a 40-inch screen, but it's incredibly frustrating for laptop users.

To search for inside information Excel, right click on a populated cell and choose Smart Find from the context menu. On the right side of the app, you'll see a list of search results from Bing, including definitions and Wikipedia entries.

3 awesome Excel 2016 tricks you overlooked

3. New graphics

The ability to make charts in Excel is nothing new, but did you know that the 2016 version included six new types of charts? 6 New Excel Charts And How To Use Them 6 New Excel Charts And How To Use Them Need to get the most out of your Excel charts? Here's a complete guide to some of the new charts introduced in the latest version of Excel. Read more ?

  1. Route map (hierarchical data views)
  2. Sunburst (a multilevel pie chart)
  3. Waterfall (to view financial statements)
  4. Histogram (Shows the frequencies within a data set)
  5. Pareto (a histogram using bar graphs and line graphs)
  6. Box and Mustache (displays quartiles in a histogram)

What are your favorite features in Excel 2016? Let us know in the comments below.