Data Analysis and Visualization with Microsoft Excel

PT24939
Prerequisites
To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and functions
Duration
2 Days/Lecture & Lab
Audience
This course is designed for students who already have foundational knowledge and skills in Excel and who wish to perform robust and advanced data and statistical analysis with Microsoft Excel using Pivot Tables, use tools such as Power Pivot and the Data Analysis ToolPak to analyze data, and visualize data and insights using advanced visualizations in charts and dashboards in Excel.
Topics
  • Analyzing and Visualizing Data for Business
  • Analyzing Data with Formulas and Functions
  • Creating Conditional Visualizations
  • Creating PivotTables, PivotCharts, and Slicers
  • Presenting Data in an Excel Dashboard
  • Performing Statistical Analysis
  • Getting and Transforming Data
  • Modeling and Analyzing Data with Power Pivot
  • Creating Geospatial Visualizations with Excel

Related Scheduled Courses