Excel: Avoiding Common Mistakes (Microsoft 365)

If you work in Excel, you know that even a small error can have big consequences, throwing off important calculations or transmitting incorrect information to your team. In this concise course, Excel expert Dennis Taylor provides quick and easy tips to help you avoid common mistakes. Dennis begins with the basics—how to display data so that errors can be easily spotted, enter data correctly the first time, and apply shortcuts for frequent entries. Dennis provides easy ways to protect worksheets and validate your data—techniques that are particularly helpful when multiple team members are contributing to the same spreadsheet. He also shows how to correctly use row and column references and avoid mistakes in formulas.

Topics include:
Describe methods for entering values into multiple cells at once.
Describe procedures for using and inputting pick lists.
Enumerate steps for and consequences of locking worksheets and workbooks.
Demonstrate the correct use of the Data Validation menu.
Be able to use column references in formulas in order to simplify their appearance.
Identify where to change the rules for formula error checking.