Presenter: Jonathan Gardner, Network Administrator and ScreeND Program Data Analyst at Quality Health Associates of North Dakota (QHA)
Join us for two lunch & learn sessions designed to help you quickly clean, summarize, and analyze data using Excel. In these sessions, you’ll gain practical skills to transform raw data into meaningful information.
Objectives:
- Format and Organize Data: Learn how to convert raw data into structured Excel Tables for easier analysis.
- Efficient Data Manipulation: Master filtering, sorting, and counting techniques to quickly find and summarize key information.
-
Basic Functions for Analysis: Use essential Excel functions to stratify data.
- PivotTables and PivotCharts: Understand the fundamentals of PivotTables and PivotCharts to aggregate and visualize data effectively.
- PowerPivot Tools: Explore PowerPivot to clean, pivot, filter, and merge datasets for more comprehensive data analysis.