Welcome to Excel Jet Consult blog post and Happy New Year 2020. In this post, we want to learn how to use the new Workbook Statistics made available to Office 365 users. Let’s get started
The Workbook Statistics is in the Proofing group of the Review tab. The Workbook Statistics gives a summary count of cells, formulas, charts, tables, PivotTables, Sheets and many more
In the caption below, when I clicked on Workbook Statistics from SUM, AVE, COUNT-IFS sheet, I have comprehensive statistics.
In the Current Sheet, there are the following:
- 3 Tables
- 296 Cells with data
- 1 Image
- 1 Chart
- 2 Comments
- 2 Objects (Text Box and Rectangle with Home Page link)
- 56 Formulas among others
In the Workbook, we have:
- 15 Sheets
- 5 Tables
- 85576 Cells with data
- 2586 Formulas among others
We encourage all to join thousands global of visitors to our blog who are learning new things in Power BI, Excel and SQL Server. Do subscribe to our Youtube channel: Abiola David Excel Jet Consult