Workbook Statistics in Excel for Microsoft 365

Posted on:  05/09/2020
Workbook Statistics in Excel for Microsoft 365

Excel for Microsoft 365 subscribers now have Workbook Statistics. Workbook Statistics is a window that shows a summary of the workbook statistics, including the number of sheets, tables, formulas, charts, and pivottables.

You access Workbook Statistics by going to the Review tab - Proofing group - Workbook Statistics in Excel 365 for Windows or Mac.

Microsoft 365 support article

https://support.office.com/en-us/article/what-s-new-in-microsoft-365-95c8d81d-08ba-42c1-914f-bca4603e1426?ui=en-US&rs=en-US&ad=US

Keyboard shortcuts used in this video:

  1. ATL + = autosum
  2. CTRL + ' copy the formula above
  3. ALT + F1 - make a chart in the current worksheet
  4. CTRL + T make a table from a range

Chris Menard's Free class on Excel Tables:

https://chrismenardtraining.teachable.com/p/excel-tables Ten reasons to use Tables in Excel by Chris Menard

Chris Menard

Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.

Categories