MICROSOFT OFFICE EXCEL 2013 VS 2016 HOW TO
MICROSOFT OFFICE EXCEL 2013 VS 2016 SERIES

In the dialog box set the Forecast end date and click Create. To create the sheet, click a cell in the table data and select: Suppose you have monthly sales pivot data for two years and wish to predict the next 12 months taking into account seasonal patterns if there are any. This automatically creates formulas to make a forecast of your existing data. New to Excel 2016 on the Data tab is Forecast Sheet.

MICROSOFT OFFICE EXCEL 2013 VS 2016 SERIES

With Power Map you can even create a video to show a series of changes to a map over time. The maps are initially inserted onto a new sheet but can be copied back to an Excel worksheet by selecting a copy image button. The pie charts represent the number of events broken down by each course. Tip: To hide cells in an Excel worksheet Select the range of cells Right Click, Format Cells Select Custom and type ”” This UK map shows the location of training events based on post codes which have been hidden on this sheet. The following graph can be created from data shown.Ĭlick Layer Options to control bar thickness and height. Click the Add field button and Add Category to represent the data graphically. Click inside some data containing locations and a map is inserted onto a separate sheet as a new scene. Now available on the Insert tab is Power Map. To create a Pareto chart, click in the data and select This will influence your decision on where to assign your resources. This highlights which Bars have the biggest impact/return. Right clicking on the axis and choosing Format Axis allow you to change the number of bars (bins) or the bin width.Ī Pareto chart displays a series of figures as a combination of a cumulative line chart and columns chart sorted in descending order. The lines extending vertically (whiskers) shows the spread of data outside this range.įrom the same data you can now easily create a Histogram chart. The line in the middle indicates the median value (middle value) while the bottom and top of the boxes represent the spread of the data from the first to the third quartile (25 thpercentile to the 75 th percentile). The Box & Whisker chart is used to show statistical information about a set of data.

Now click in the data and choose Insert, Hierarchy Chart, TreemapĪnother way to display this type of data is with a Sunburst chart. A Treemap can’t be created directly from a PivotTable so you will have to copy as values to another location. Suppose you have PivotTable data based on car sales. This is a brand new chart type and a great way to visualize hierarchies of data.

MICROSOFT OFFICE EXCEL 2013 VS 2016 HOW TO

See How to create a waterfall chart with Excel 2010 Some formatting is needed but most of the work is done. With Excel 2016 you click in the data and choose Insert, Waterfall from the Waterfall and Stock Chart button. Suppose you have the following data and wish to display it in a Waterfall Chart: The bars appear to fly or float between the start and end columns giving the impression of a waterfall or a bridge. Recap: A Waterfall Chart, sometimes called a ‘flying brick chart’ is a way of visualizing a series of positive and negative data such as monthly cash flows. It would have involved a lengthy work around using formulas, recolouring bars, white boxs and adjusting the scale. On the Insert tab there are several new Chart Types available only in Excel 2016.īeing able to create a Waterfall chart with one click will amaze anyone who has attempted to create such a chart in previous versions of Excel. ‘Tell Me’ remembers what you have asked and further actions to try. Type what action you would like to take and you get some useful tips to help you get started. ‘Tell Me what you want to do’ on the Home ribbon is now available across Office 2016. There is also a new Get & Transform section for creating and working with queries. They can be located on the Insert and Data tabs and include several new chart types, a Power Maps tool and a Forecast Sheet feature. The main changes between Excel 20 are associated with the Business Intelligence (BI) features. To learn more about that, please take a look at our Excel courses. We have compared the different versions of Excel and come up with a quick overview of What’s New in Excel 2016. With Excel at the core of many businesses, it would help to have all of the new features explained. With the launch of Office 2016 in the Autumn of 2015, you may be wondering about the new features in 2016 and what’s changed.

Microsoft office excel 2013 vs 2016