Microsoft will keep track of your workbook tables, charts, formulas, cells, and more. In this video, learn how to display workbook statistics to gain a snapshot of your workbook contents.
- [Instructor] Some Excel workbooks can become quite large and cumbersome, making it difficult to know it's makeup. Well, now you can get a snapshot of your workbooks' cells, tables, charts, tabs, formulas, and more, all with a new feature called Workbook Statistics. Let's explore this with this somewhat large workbook here. You can see I have many tabs across the bottom, several different sheets, all containing different types of content. To get a grasp of what I'm looking at here, we can go up to the review tab on the ribbon and in the proofing section, we find access to the new feature Workbook Statistics. Go ahead and give that a click, and it opens up this dialogue with information on the current sheet, as well as the entire workbook. In this current sheet, I can see the last cell in the sheet where that's located, how many cells actually contain data. There are no tables. There's only one formula, one chart, and one image. If I look at the workbook, however, I can see there's a total of nine sheets, even though I can't see them all across the bottom here, many more cells with data, over 1,200, no tables used in any of these sheets. There is a pivot table, 340 formulas altogether, and a couple of charts. So this gives me a nice little snapshot of what's going on in my fairly large workbook here in Excel, thanks to this new feature called Workbook Statistics.
- Using natural language queries in Excel
- Getting writing assistance from Editor
- Using the Resume Assistant in Word
- Turning data into maps in Excel
- Setting access to linked files right within Outlook
- Creating better PowerPoint lists with Designer
- Using the math assistant in OneNote
- Working with Microsoft To-Do and Forms