View Course Overview for Available CPE and Access Options

Introduction to One-click Reporting

Next Lesson:
Basic: VLOOKUP()
Instructor for this course
  Course Overview CPE
Course Syllabus
  7:47PREVIEW: Introduction to One-click Reporting
Basic
  Basic: VLOOKUP()6:18
  Basic: INDEX() & MATCH()7:35
  Basic: Pivot Table4:37
  Basic: Simple Macro/VBA7:52
Intermediate
  Intermediate: Excel modeling based on system reports – Simple link2:06
  Intermediate: Excel modeling based on system REPORTS – Formula link, Helper Column8:48
Advanced
  Advanced: Excel modeling based on system DATA – Parameters1:10
  Advanced: Excel modeling based on system DATA – Data Processing8:45
  Advanced: Pivot Table, GETPIVOTDATA9:06
  Advanced: VBA, Macro to achieve One-click Reporting4:23
CONCLUSION
  Summary - One-click Reporting1:16
SUPPORTING MATERIALS
  Slides: From Data to Report in ONE ClickPDF
  From Data to Report in ONE Click Glossary/IndexPDF
  Part I WorkbookXLSM
REVIEW & TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam