Data Analysis and Visualization with Excel (PH-0292)

Fall 2024 · PH 0292 · Tufts University · 3 credits · Undergraduate

This online course introduces the use of Microsoft Excel to manage, analyze, and present data. Every week, participants will learn new topics through watching asynchronous videos and working on practice projects prior to attending the live sessions. The online live sessions will focus on solving project-based challenges, reinforcing the application of the learned topics. Sample data will be drawn from various public health areas. Upon finishing the course, participants will be able to apply basic to intermediate Excel skills to their data, specifically in four domains: i) performing basic operations in Excel, ii) creating interactive pivot tables, iii) making default and advanced data visualization, and iv) optimizing workflow using macro and basic Visual Basic for Applications (VBA) coding. No prior experience in coding is needed; experience in using Microsoft products and basic statistics is helpful but not required. While this course would cover some inferential statistical analysis capability using Excel add-in, it does not serve as a substitute for fundamental statistics and biostatistics courses. Asynchronous videos feature Windows operating system; Mac users may find their interface looking slightly different.

Course codes: PH-0292, PH 0292, PH0292, PH-292, PH 292, PH292

Course Discovery