Fall 2019 Advanced Excel for reporting & analytics


Content
  • Week 1 Lecture
  • Week 1 Classwork
  • Week 1 homework
  • Week 2 Lecture
  • Week 2 classwork 1 Sorting & Filtering
  • Week 2 classwork Subif & Sum
  • Week 2 classwork Sumifs
  • Week 2 classwork Sumproduct & Index
  • Week 2 homework
  • Week 3 Lecture
  • Week 3 Classwork
  • Week 3 Classwork solution
  • Week 3 homework
  • Week 4 Classwork 1
  • Week 4 classwork 2
  • Week 4 homework
  • Week 4 Lecture
  • Week 5 Lecture
  • Week 5 Classwork 1
  • Week 5 classwork source 1
  • Week 5 Classwork source 2
  • Week 5 Classwork source 3
  • Week 5 Classwork source 4
  • Week 5 classwork source 5
  • Week 5 shortcuts
  • Week 6 Exercise 1
Completion rules
  • All units must be completed