Schedule
A tentative schedule is provided below (content may be adjusted as we progress).
Date Topic Reading Items due week 1 (Mon: Sep 08)
Course Introduction, Required Materials, and File Management
Lecture 1 slide
No Project
week 2 (Mon: Sep 15)
Excel Module 1 - Getting Started with Excel
Lecture 2 slide
Mindtap training & Project#1 (released)
Reading: Module 1
week 3 (Mon: Sep 22)
Excel Module 2 - Formatting Workbooks, Text, & Data
Lecture 3 slide
Mindtap training & Project#2 (released)
Reading: Module # 2
Mindtap training & Project#1 (due on 09/21)
week 4 (Mon: Sep 29)
Excel Module 3 - Calculations with Formulas & Functions
Lecture 4 slide
Mindtap training & Project#3 (released)
Reading: Module # 3
Mindtap training & Project#2 (due on 09/28)week 5 (Mon: Oct 06)
Mid-Autumn Festival/National Holiday break: October 1–8, 2025
week 6 (Mon: Oct 13)
Excel Module 4 - Charts & Graphs
Lecture 5 slide
Mindtap training & Project#4 (released)
Reading: Module # 4
Mindtap training & Project#3 (due on 10/12)
week 7 (Mon: Oct 20)
Excel Module 5 - Working with Multiple Worksheets & Workbooks
Lecture 6 slide
Mindtap training & Project#5 (released)
Reading: Module # 5
Mindtap training & Project#4 (due on 10/19) week 8 (Mon: Oct 27)
Excel Module 6 - Managing Data with Tables & Tools
Lecture 7 slide
Mindtap training & Project#6 (released)
Reading: Module # 6
Mindtap training & Project#5 (due on 10/26)
week 9 (Mon: Nov 03)
Excel Module 7 - Summarizing Data with PivotTables
Lecture 8 slide
Mindtap training & Project#7 (released)
Reading: Module # 7
Mindtap training & Project#6 (due on 11/02)
week 10 (Mon: Nov 10)
Excel Module 8 - Performing What-If Analyses
Lecture 8 slide
Mindtap training & Project#8 (released)
Reading: Module # 8
Mindtap training & Project#7 (due on 11/09)
week 11 (Mon: Nov 17)
Excel Module 9 - Financial Functions
Lecture 9 slide
Mindtap training & Project#9 (released)
Reading: Module # 9
Mindtap training & Project#8 (due on 11/16) week 12 (Mon: Nov 24)
Excel Module 10 - Analyzing Data with Business Intelligence Tools
Lecture 10 slide
Mindtap training & Project#10 (released)
Reading: Module # 10
Mindtap training & Project#9 (due on 11/23)
week 13 (Mon: Dec 01)
Excel Module 11 - Exploring PivotTable Desgin
Lecture 11 slide
Mindtap training & Project#11 (released)
Reading: Module # 11
Mindtap training & Project#10 (due on 11/30)
week 14 (Mon: Dec 08)
Excel Module 12 - Developing an Excel Application
Lecture 11 slide
Mindtap training & Project#12 (released)
Reading: Module # 12
Mindtap training & Project#11 (due on 12/08)
week 15 (Mon: Dec 15)
Exam review
Practice Exam
Course Evaluation
Lecture 12 slides
Mindtap training & Project#12 (due on 12/15)
Final Exam (due by 12/23)