From the course: Excel 2016 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
New charts in Excel 2016
- Excel 2016 has six new chart types, and in this workbook called 07 - New Charts, we're seeing those six types represented by different sheets. TreeMap, Sunburst, Histogram, Pareto, Box and Whisker, and Waterfall. Some of these charts you could have created in earlier versions of Excel, some with great difficulty too, I might add, and some are completely new, like TreeMap. In this worksheet, we've got data in columns A, B, and C, going down to row 34. And there's similar data over in columns P, Q, and R, in fact, it's simply restructuring of the data, columns moved around, and so on. The titles in column A are all filled in, but they don't need to be. Excel will recognize the hierarchical relationship of the data here as it looks at the data. And we'd like to get a broad picture of how much Compensation is being spent for each of these Departments broken out by Status. A quick look through the data and you would recognize that the Manufacturing department here is by far the largest…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.