Data Analysis and Visualization with Microsoft Excel

2 Days | Price: $590

Description

In this course, you will analyze and visualize data using Excel and associated tools. You will:

  • Perform data analysis fundamentals.
  • Visualize data with Excel.
  • Analyze data with formulas and functions.
  • Analyze data with PivotTables.
  • Present visual insights with dashboards in Excel.
  • Create geospatial visualizations with Excel.
  • Perform statistical analysis.
  • Get and transform data.
  • Model and analyze data with Power Pivot.
  • Present insights with reports.
Lesson 1: Data Analysis Fundamentals
  • Topic A: Introduction to Data Science
  • Topic B: Create and Modify Tables
  • Topic C: Sort and Filter Data
Lesson 2: Visualizing Data with Excel
  • Topic A: Visualize Data with Charts
  • Topic B: Modify and Format Charts
  • Topic C: Apply Best Practices in Chart Design
Lesson 3: Analyzing Data with Formulas and Functions
  • Topic A: Analyze Data with Formulas and Named Ranges
  • Topic B: Analyze Data with Functions
  • Topic C: Implement Data Validation, Forms, and Controls
  • Topic D: Create Conditional Visualizations with Lookup Functions
Lesson 4: Analyzing Data with PivotTables
  • Topic A: Create a PivotTable
  • Topic B: Analyze PivotTable Data
Lesson 5: Presenting Visual Insights with Dashboards in Excel
  • Topic A: Visualize Data with PivotCharts
  • Topic B: Filter Data Using Slicers and Timelines
  • Topic C: Create a Dashboard in Excel
Lesson 6: Creating Geospatial Visualizations with Excel
  • Topic A: Create Map Charts in Excel
  • Topic B: Customize Map Charts in Excel
Lesson 7: Performing Statistical Analysis
  • Topic A: Visualize Trendlines and Sparklines with Excel
  • Topic B: Analyze Data with the Analysis ToolPak
Lesson 8: Getting and Transforming Data
  • Topic A: Connect to Data with Queries
  • Topic B: Clean and Combine Data
  • Topic C: Shape and Transform Data
Lesson 9: Modeling and Analyzing Data with Power Pivot
  • Topic A: Install Power Pivot in Excel
  • Topic B: Create Data Models with Power Pivot
  • Topic C: Create Power Pivots
  • Topic D: Perform Advanced Data Analysis and Visualization
Lesson 10: Presenting Insights with Reports
  • Topic A: Plan a Report
  • Topic B: Create a Report
StartsRegister
Jul 22, 2024 9:00AM

Register