Instructor for this course
more

Introduction to One-click Reporting

Next Lesson:
Course Syllabus
Basic
  6:18Basic: VLOOKUP()
  7:35Basic: INDEX() & MATCH()
  4:37Basic: Pivot Table
  7:52Basic: Simple Macro/VBA
Intermediate
  2:06Intermediate: Excel modeling based on system reports – Simple link
  8:48Intermediate: Excel modeling based on system REPORTS – Formula link, Helper Column
Advanced
  1:10Advanced: Excel modeling based on system DATA – Parameters
  8:45Advanced: Excel modeling based on system DATA – Data Processing
  9:06Advanced: Pivot Table, GETPIVOTDATA
  4:23Advanced: VBA, Macro to achieve One-click Reporting
CONCLUSION
  1:16Summary - One-click Reporting
SUPPORTING MATERIALS
  PDFSlides: From Data to Report in ONE Click
  PDFFrom Data to Report in ONE Click Glossary/Index
  XLSMPart I Workbook
REVIEW & TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM