Business Data Analysis

Syllabi

• Fall 2024
• Spring 2024

Lecture Notes & Workbooks (Spring 2024)

• Lecture Note #01: Excel Basics Part 1
• Lecture Note #02 & Workbook #02: Excel Basics Part 2
• Lecture Note #03 & Workbook #03: Functions Part 1
• Lecture Note #04 & Workbook #04: Functions Part 2
• Lecture Note #05 & Workbook #05: Functions Part 3
• Lecture Note #06 & Workbook #06: Functions Part 4
• Workbook #07: Recap of Functions
• Lecture Note #08 & Workbook #08: Filtering and Sorting
• Lecture Note #09 & Workbook #09: Conditional Formatting Part 1
• Lecture Note #10 & Workbook #10: Conditional Formatting Part 2
• Lecture Note #11 & Workbook #11: Charts Part 1
• Lecture Note #12 & Workbook #12: Charts Part 2
• Lecture Note #13 & Workbook #13: Charts Part 3
• Lecture Note #14 & Workbook #14: PivotTables Part 1
• Lecture Note #15 & Workbook #15: PivotTables Part 2
• Lecture Note #16 & Workbook #16: PivotTables Part 3
• Lecture Note #17 & Workbook #17: PivotTables Part 4
• Lecture Note #18 & Workbook #18: Data Analysis Tools Part 1
• Lecture Note #19 & Workbook #19: Data Analysis Tools Part 2
• Lecture Note #20 & Workbook #20: Data Analysis Tools Part 3

Quizzes

• Quiz #1: Excel Basics
  • Quiz Booklet: Spring 2024
  • Workbook: Spring 2024
  • Answer Key: Spring 2024
• Quiz #2: Functions #1
  • Quiz Booklet: Spring 2024 (Section #1, Section #2)
  • Workbook: Spring 2024 (Section #1, Section #2)
  • Answer Key: Spring 2024 (Section #1, Section #2)
• Quiz #3: Functions #2
  • Quiz Booklet: Spring 2024 (Section #1, Section #2)
  • Workbook: Spring 2024 (Section #1, Section #2)
  • Answer Key: Spring 2024 (Section #1, Section #2)
• Quiz #4: Filtering and Conditional Formatting
  • Quiz Booklet: Spring 2024 (Section #1, Section #2)
  • Workbook: Spring 2024 (Section #1, Section #2)
  • Answer Key: Spring 2024 (Section #1, Section #2)
• Quiz #5: Charts
  • Quiz Booklet: Spring 2024 (Section #1, Section #2)
  • Workbook: Spring 2024 (Section #1, Section #2)
  • Answer Key: Spring 2024 (Section #1, Section #2)
• Quiz #6: PivotTables and PivotCharts
  • Quiz Booklet: Spring 2024 (Section #1, Section #2)
  • Workbook: Spring 2024 (Section #1, Section #2)
  • Answer Key: Spring 2024 (Section #1, Section #2)

Practice Final Exam

• Booklet:
• Workbook:
• Answer Key:

Final Exam

• Booklet:
• Workbook:
• Answer Key: