View Course Overview for Available CPE and Access Options

Introduction to 5 Key Questions Every Spreadsheet Should Answer

Instructor for this course
  Course Overview CPE
Course Syllabus
INTRODUCTION AND OVERVIEW
  2:31PREVIEW: Introduction to 5 Key Questions Every Spreadsheet Should Answer
Excel – Why Structure Matters
  Goals and how to achieve them4:44
  Illustrative example 17:30
Structuring Excel workbooks
  Excel User Groups: What They Need and How to Give It to Them5:41
  Illustrative example 25:49
Structuring Excel Calculations
  How best to approach calculations3:26
  Illustrative example 315:59
Excel Rules and Tips
  Ways to make your life a whole lot easier8:04
Conclusion
  Tips Demonstration and Course Conclusion1:10
Continuous Play
  Excel 101: Establishing Structure and the Five Key Questions Every Spreadsheet Should Answer 54:54
SUPPORTING MATERIALS
  Slides: Excel 101: Establishing Structure and the Five Key Questions Every Spreadsheet Should AnswerPDF
  Excel 101: Establishing Structure and the Five Key Questions Every Spreadsheet Should Answer Glossary/IndexPDF
  Calculation Examplexlsx
  Sales Incentive Calculationxlsx
  Template Base Filexlsx
REVIEW & TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam