This is the sixth and final part of Simon Hurst’s series looking at the changes and new features in Excel 2016.
Following the success of their 20 Principles for Good Spreadsheet Practice in
Excel 2016 has introduced some useful new chart types. In this article Simon Hurst looks at the new hierarchy charts – Treemap and Sunburst and the long-awaited Waterfall chart.
Simon Hurst investigates the three new Excel 2016 charts: Histograms, Pareto charts and Box and Whisker charts, which are all in the Statistical Charts section.
Simon Hurst has a quick look at Excel’s existing forecasting capabilities before looking in detail at what the new Forecast Sheet feature, and new forecast functions, add.
Simon Hurst reports from the ModelOff spreadsheet competition and award ceremony. The event demonstrated just how important spreadsheets are to modern life.
Last year the ICAEW launched its twenty principles for good spreadsheet pra
Simon Hurst concludes his series on ways to improve management reporting with a lo
Simon Hurst continues his series on ways to improve management reporting with a look at Sparklines.
Simon Hurst continues his series exploring ways to improve reporting with a look at conditional formatting.
- New Range Name features in Excel 2007. By Simon Hurst 464,142 6
- Excel 2007 SUMIFS(): The accountant's favourite Excel function gets an overhaul. By Simon Hurst 60,280 4
- Excel 2010 KPI tutorial 3: PivotTable dashboards 30,900 5
- Build your own Excel Net to Gross function - Tutorial by Simon Hurst 26,643 4
- Tutorial: Create a flexible P&L in Excel 2010/2013 22,778 13