![]() 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.
0 Comments
Leave a Reply. |