Instructor for this course
more

Introduction to 5 Key Questions Every Spreadsheet Should Answer

Course Syllabus
INTRODUCTION AND OVERVIEW
Excel – Why Structure Matters
  4:44Goals and how to achieve them
  7:30Illustrative example 1
Structuring Excel workbooks
  5:41Excel User Groups: What They Need and How to Give It to Them
  5:49Illustrative example 2
Structuring Excel Calculations
  3:26How best to approach calculations
  15:59Illustrative example 3
Excel Rules and Tips
  8:04Ways to make your life a whole lot easier
Conclusion
  1:10Tips Demonstration and Course Conclusion
Continuous Play
  54:54Excel 101: Establishing Structure and the Five Key Questions Every Spreadsheet Should Answer
SUPPORTING MATERIALS
  PDFSlides: Excel 101: Establishing Structure and the Five Key Questions Every Spreadsheet Should Answer
  PDFExcel 101: Establishing Structure and the Five Key Questions Every Spreadsheet Should Answer Glossary/Index
  xlsxCalculation Example
  xlsxSales Incentive Calculation
  xlsxTemplate Base File
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM