Analytics & Managerial Decision-Making Excel Lab

excel lab

1. Analytics & Managerial Decision - Making
Session I |Excel Lab Agenda
Parth, Jeason | Mailman School of Public Health | September, 2024

2. Application of Excel in the Workplace

3. Application of Excel in the Workplace
●Data/trend analysis
●Creation of visual representations
●Budgeting
●Forecasting
●Operations management
●Examples from TA’s during their APEx’s

4. Agenda for this Semester
Class 1: Importance of Excel & Common Calculation Functions
Class 2: Basic Excel Functions
Class 3: How to use Pivot Tables
Class 4: How to use Lookup function
Class 5: How to do Data Analysis
Class 6: How to Visualize Data to Tell a Story
Class 7: Data Project Presentation

5. Each Class Briefs
Each class:
●10 - 15min teaching
●20min practice with dataset
●15- 20 min walk through together

6. Dataset Overview

7. Group Project
●Class 1: provide overview of data project presentation & randomly
assign groups
○September 11
●Class 3: deadline for group healthcare/life sciences data set submission
with description of presentation/findings overview
○Submit to Canvas
●Class 6: end of class questions about presentation & set up office hours
during the week for presentation run-throughs
●11:59PM night before Class 7: submit presentation to Canvas

8. Group Members

9. End of overview