Dennis demonstrates how to compare two versions of a workbook with Spreadsheet Compare.
- [Instructor] For this movie we need to have…two files open.…Chapter five A and Chapter five B.…And also, we need to have available…as a ribbon tab the word Inquire.…If you missed the previous movie…you will need to install…what's called the Excel add in Inquire.…Go to the File tab in the ribbon.…Choose Options.…Then Add Ins.…And at the bottom of this dialog box…instead of Excel Add Ins, click the drop arrow,…choose Com Add Ins.…Go.…
And then check the box for Inquire.…Now of course, if it's already checked,…you don't need to go any further, just cancel.…But, check it, click Okay.…And then Inquire will be available…as a tab in the ribbon menu system.…If you over time don't use this feature that often…you don't necessarily have to keep it here.…You can right click,…Customize the ribbon.…And simply turn off the Inquire feature.…It could be something you use often, or maybe not.…But you can certainly activate it from there on in.…The add in concept means we add this once…and we'll just keep it there indefinitely.…
Now, one of the features of Inquire…
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