Catalog

In this course, participants embark on a journey to master the art of data analysis and visualization utilizing Excel and its associated tools. Through a series of engaging modules, students delve into the fundamentals of data analysis, learning essential techniques to efficiently manipulate and interpret data. From visualizing data using Excel\'s robust features to conducting in-depth statistical analysis, participants gain a thorough understanding of how to extract meaningful insights from raw data. The curriculum covers a wide array of topics, including the utilization of formulas, PivotTables, dashboards, and geospatial visualizations to present data effectively. Additionally, students explore advanced functionalities such as data modeling with Power Pivot and transforming data for improved analysis. By the course\'s conclusion, participants emerge equipped with the skills and knowledge necessary to tackle real-world data challenges and communicate their findings with clarity and precision.

##### Module 1 - Data Analysis Fundamentals - Introduction to Data Science - Create and Modify Tables - Sort and Filter Data ##### Module 2 - Visualizing Data With Excel - Visualize Data with Charts - Modify and Format Charts - Apply Best Practices in Chart Design ##### Module 3 - Analyzing Data With Formulas And Functions - Analyze Data with Formulas and Named Ranges - Analyze Data with Functions - Implement Data Validation, Forms, and Controls - Create Conditional Visualizations with Lookup Functions ##### Module 4 - Analyzing Data With PivotTables - Create a PivotTable - Analyze PivotTable Data ##### Module 5 - Presenting Visual Insights With Dashboards in Excel - Visualize Data with PivotCharts - Filter Data Using Slicers and Timelines - Create a Dashboard in Excel ##### Module 6 - Creating Geospatial Visualizations with Excel - Create Map Charts in Excel - Customize Map Charts in Excel ##### Module 7 - Performing Statistical Analysis - Visualize Trendlines and Sparklines with Excel - Analyze Data with the Data Analysis ToolPack ##### Module 8 - Getting And Transforming Data - Connect to Data with Queries - Clean and Combine Data - Shape and Transform Data ##### Module 9 - Modeling And Analyzing Data with Power Pivot - Install Power Pivot in Excel - Create Data Models with Power Pivot - Create Power Pivots - Perform Advanced Data Analysis and Visualization ##### Module 10 - Presenting Insights with Reports (Optional) - Plan a Report - Create a Report