From the course: Excel Online Tips and Tricks (Microsoft 365)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Find out even more with Workbook Statistics
From the course: Excel Online Tips and Tricks (Microsoft 365)
Find out even more with Workbook Statistics
- [Instructor] It's amazing how often I get asked all sorts of weird and wonderful questions about my Excel workbooks, such as how many worksheets are there? How many cells containing data? And that kind of thing. Well, did you know that many of these questions can be answered at the click of a button? Just make sure you have a file open. I'm using the exercise file "Excel Stats". All you need to do now is head over to review and then select workbook statistics. And there you go, Excel for the web returns some rather interesting insights on both the workbook and also the tab that you have selected. The one that I like the most is cells with data. As this can be a bit of a guide as to how complex a workbook might be to maintain. So why not try running workbook statistics on some of your own work? It might give you some rather interesting results.
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.