New Workbook Statistics in Office 365

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

Posted in Blog and tagged , .

Leave a Reply

Your email address will not be published. Required fields are marked *