Dennis demonstrates how to analyze a workbook with Spreadsheet Inquire.
- [Instructor] For this movie,…you need to open the file Chapter 5A.…And as you do, you will see a message…like we're seeing on the screen here.…We can choose to update or don't update.…There is a link here to the chapter 4 file.…A relatively new feature in Excel,…and available only to people…who have Office 2016 Professional Plus,…or Office 365 Professional Plus,…is called Inquire.…Initially you don't see this.…This is an add-in.…In order to get to it, go to the File tab in the ribbon.…
Choose options.…And then add-ins and at the bottom of this dialog box,…manage excel add-ins, click the drop arrow to the right,…choose COM add-ins,…Go.…And the first choice is Inquire.…Click okay.…Inquire is immediately added to the tabs in the ribbon.…We don't see anything until we click the Inquire tab.…And what do we see here?…Inquire gives us a number of tools for discovering potential…and actual problems in workbooks.…
The certain sense is more an auditing tool.…It doesn't prevent errors, but it certainly can reveal them.…Let's click on workbook analysis.…
Dennis begins with the basics—how to display data so that errors can be easily spotted. Next, he offers handy tips to ensure data is entered correctly the first time, using the AutoFill feature and using AutoCorrect shortcut codes for frequently used entries. Dennis provides easy ways to validate your data, which is particularly helpful when multiple team members are contributing to the same spreadsheet. This includes restricting the data that can appear in a spreadsheet by setting value limits, pre-populating data with drop-down lists, and other methods. He also shows how to avoid mistakes in formulas, how to hide data that doesn't need to be seen, and how to use workbook protection to prevent errors, and more.
- Streamlining data entry steps
- Using Excel shortcuts and automation features
- Protecting worksheets and workbooks
- Validating data
- Basing entries on formulas
- Detecting errors in formulas
- Using Range Names
- Finding mistakes in large, complex spreadsheets