Data Analysis and Visualization with Microsoft Excel
Program Overview
This program focuses on using Excel and Power Pivot to clean data with tables and formulas, analyze trends with PivotTables and geospatial/statistical tools, and build interactive dashboards. The intended outcome is to develop strong data-prep, analysis, and modeling skills for creating connected, insightful reports. In this program you will learn to:
- Clean and transform data to improve accuracy, consistency, and usability for analysis.
- Create and analyze PivotTables to identify trends, patterns, and key business insights.
- Create meaningful charts and visualizations that communicate data clearly.
- Design interactive dashboards that allow users to explore and monitor key information.
- Connect multiple data sources to create efficient, repeatable reporting solutions.
We can tailor this program and deliver it on-site for your employees and leaders.
Cheryl Welch
Cheryl Welch has over 15 years of experience as an instructor. Her entertaining style of teaching helps keep students interested and focused on the subject being taught and was recognized by the American Society for Training and Development as an…