Excel: Avoiding Common Mistakes (Office 365/Excel 2019)

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.

About the Author

Dennis Taylor is an Excel expert who has 25+ years of experience in spreadsheet authoring and training. Dennis has experience working as an author, speaker, seminar leader, and facilitator. Since the mid-90s, he has been the author/presenter of numerous Excel video and online courses and has traveled throughout the U.S. and Canada presenting over 300 seminars and classes. He has authored or co-authored multiple books on spreadsheet software and has presented over 500 Excel webinars to a diversity of audiences. Dennis has worked with hundreds of different corporations and governmental agencies as well as colleges and universities. He lives in Boulder, Colorado.

Product Details

• Full Video Tutorials
• Video File Format: MP4
• Skill Level: Intermediate
• Video Duration: 45m 23s
• Instructor: Dennis Taylor