BLOG
CATALOG
Menu
Business Signing a Contract Buy - sell house. - Agile Scrum
a stack of orange and white books with text overlay of different training topics related to the professional workforce.
Browse hundreds of training topics to elevate team performance.
a laptop and phone with course training text on the screen.

Learn about PTR’s interactive course workbook for different learning styles.

Professional African-American woman training instructor smiling with overlay text.

PTR instructors are experts at delivering engaging, professional training.

Data Analysis and Visualization with Microsoft Excel

Formats ⟩  Live Virtual: 4 hrs./day, 2 Days  |  In-Person: 6 hrs./day, 2 Days

This course is designed for students who already have foundational knowledge and skills in Microsoft Excel and who wish to perform robust and advanced data and statistical analysis with Excel. You will learn to use tools such as Power Pivot and the Data Analysis ToolPak to analyze and visualize data and insights.

Learning Objectives »

  • Perform data analysis fundamentals.
  • Visualize data with Excel.
  • Analyze data with formulas, functions & PivotTables.
  • Present visual insights with dashboards in Excel.
  • Create geospatial visualization with Excel.
  • Perform statistical analysis and transform data.
  • Model and analyze data with Power Pivot.

Course Agenda

Data Analysis Fundamentals 

  1. Introduction to Data Science
  2. Create and Modify Tables
  3. Sort and Filter Data

Visualizing Data with Excel

  1. Visualize Data with Charts
  2. Modify and Format Charts
  3. Best Practices in Chart Design

Analyzing with Formulas & Functions

  1. Formulas and Named Ranges
  2. Functions
  3. Data Validation, Forms, and Controls
  4. Conditional Visualizations with Lookup

Analyzing Data with PivotTables

  1. Create a PivotTable
  2. Analyze PivotTable Data

Visual Insights with Dashboards

  1. Visualize Data with PivotCharts
  2. Filter Data Using Slicers and Timelines
  3. Create a Dashboard in Excel

Creating Geospatial Visualizations

  1. Create Map Charts in Excel
  2. Customize Map Charts in Excel

Performing Statistical Analysis

  1. Visualize Trendlines and Sparklines
  2. Analyze Data with the Data Analysis ToolPak

Getting and Transforming Data

  1. Connect to Data with Queries
  2. Clean and Combine Data
  3. Shape and Transform Data

Modeling & Analyzing with Power Pivot

  1. Install Power Pivot in Excel
  2. Create Data Models with Power Pivot
  3. Create Power Pivots
  4. Advanced-Data Analysis and Visualization

Presenting Insights with Reports

  1. Plan a Report
  2. Create a Report
Business Signing a Contract Buy - sell house. - Agile Scrum

Data Analysis and Visualization with Microsoft Excel

Formats ⟩  Live Virtual: 4 hrs./day, 2 Days  |  In-Person: 6 hrs./day, 2 Days

This course is designed for students who already have foundational knowledge and skills in Microsoft Excel and who wish to perform robust and advanced data and statistical analysis with Excel. You will learn to use tools such as Power Pivot and the Data Analysis ToolPak to analyze and visualize data and insights.

Learning Objectives »

  • Perform data analysis fundamentals.
  • Visualize data with Excel.
  • Analyze data with formulas, functions & PivotTables.
  • Present visual insights with dashboards in Excel.
  • Create geospatial visualization with Excel.
  • Perform statistical analysis and transform data.
  • Model and analyze data with Power Pivot.

Course Agenda

Data Analysis Fundamentals 

  1. Introduction to Data Science
  2. Create and Modify Tables
  3. Sort and Filter Data

Visualizing Data with Excel

  1. Visualize Data with Charts
  2. Modify and Format Charts
  3. Best Practices in Chart Design

Analyzing with Formulas & Functions

  1. Formulas and Named Ranges
  2. Functions
  3. Data Validation, Forms, and Controls
  4. Conditional Visualizations with Lookup

Analyzing Data with PivotTables

  1. Create a PivotTable
  2. Analyze PivotTable Data

Visual Insights with Dashboards

  1. Visualize Data with PivotCharts
  2. Filter Data Using Slicers and Timelines
  3. Create a Dashboard in Excel

Creating Geospatial Visualizations

  1. Create Map Charts in Excel
  2. Customize Map Charts in Excel

Performing Statistical Analysis

  1. Visualize Trendlines and Sparklines
  2. Analyze Data with the Data Analysis ToolPak

Getting and Transforming Data

  1. Connect to Data with Queries
  2. Clean and Combine Data
  3. Shape and Transform Data

Modeling & Analyzing with Power Pivot

  1. Install Power Pivot in Excel
  2. Create Data Models with Power Pivot
  3. Create Power Pivots
  4. Advanced-Data Analysis and Visualization

Presenting Insights with Reports

  1. Plan a Report
  2. Create a Report
PTR Training uses 'cookies' to improve your website experience. View our Privacy Policy for details. By continuing, you agree to accept and adhere to our Terms of Use.