View Course Overview for Available CPE and Access Options

Introduction & Place Titles in a Single Row

Instructor for this course
Course Syllabus
INTRODUCTION AND OVERVIEW
Minimizing Errors
  Refer Directly to the Source6:56
  Creating a Setting Table6:30
  Assigning Range Names to Key Inputs6:09
  Custom Views - Multipurpose Worksheet8:44
  Streamlining Custom Views9:41
  Viewing Two Worksheet at once10:04
  Introduction to VLOOKUP7:50
  Introduction to IFERROR9:31
  Self-Updating Headings9:48
  Remove Conditional Formatting8:33
  Create a Template7:08
Continuous Play
  Excel Efficiency: Minimizing Worksheet Errors 1:40:07
SUPPORTING MATERIALS
  Slides: Excel Efficiency: Minimizing ErrorsPDF
  Excel Efficiency: Minimizing Errors Glossary/IndexPDF
  12 Month Income StatementXLSB
  Excel Efficiency Minimizing Errors Bonus Articlesxlsx
REVIEW & TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam