From the course: Microsoft 365 New Features

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Get statistics about your workbook

Get statistics about your workbook

From the course: Microsoft 365 New Features

Start my 1-month free trial

Get statistics about your workbook

“

- [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…

Contents