"> Excel 2016 - Top 10 New Features (Part 1) - IAB | International Association of Bookkeepers

Excel 2016 – Top 10 New Features (Part 1)

This article has been provided by Filtered which is an online education platform which customises learning material for each user. The platform offers courses in essential business disciplines from leadership and management to strategy, spreadsheeting and project management.  Filtered provides discounts for IAB members on a range of courses.  To find out more about this offer please login to the restricted area of the IAB website here

Today we’re presenting a run-down of our favourite new features of Microsoft Excel 2016. It’s a two-part update so watch out for five more features next week 🙂

Before we start, we’d like to invite you to our next webinar:

10 insights for engaging with learners

Join Filtered Head of Marketing Paolo Lenotti and Towards Maturity Head of Advisory Services Marnie Threapleton, and discover what motivates today’s learners and how to support self-directed learning amongst your staff.


1. Tell me what you want to do?

The tell me box is a late arrival to the Excel party and it’s a shame it wasn’t around in 2007 when the menu ribbon was introduced (remember how hard it was to find our favourite tools?). The tell me box is essentially a search function that gets you where you want to go, quickly.

2. Forecasting

Excel 2016 has seen the addition of one-click statistical forecasting for data that has a time element associated with it. It is able to forecast past your last data point into the future, as well as showing levels of confidence at each end of the spectrum. It can also see trends due to seasonality, factoring them into the forecast. Pretty smart!

3. Search field (PivotTables)

PivotTables have been revitalised with a handy search bar – simply type in what you’re looking for and up it pops for you to select.

4. Date grouping (PivotTables)

In the last versions of Excel, PivotTables would always register dates individually, meaning that your charts would have hundreds of fields along the date axis. Now dates are automatically grouped into Years, Quarters and Months. To delve deeper use the + option next to the date segment, which will expand the next level of grouping.

5. Histograms and Pareto charts

Histograms show you frequencies, for example how much one product has sold against another. They’re not based on categories but on values which are allocated into different bins, though it’s possible to alter this to show categories. Pareto charts go one step further by sorting these frequencies and adding a cumulative percentage line to give you a trend through the data.

Take a look at these new features in our online Excel course. We guarantee they will save you time and improve the way you display your data analysis. See you next week for Part 2.

In the meantime if you have any questions regarding Excel 2016 please contact us.

Comments are closed.

Latest News