Workbook Statistics in Excel for Microsoft 365

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 is a Microsoft Office Master. He trains corporate clients in Microsoft Excel, PowerPoint, Word, and Outlook. Menard is a speaker for the Georgia Society of CPAs and a senior lecturer at the University of Georgia Terry College of Business. Menard's YouTube channel has over 600 technology videos. Chris works full-time as a Training Specialist for a global law firm. His office is in midtown, Atlanta.

Categories