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
