Register Now
All classes are taught LIVE by seasoned instructors. * 9.6 of 10 (over 22 k student survey results - 2023)

Find A Class in Your City:

MS Excel Analysis-Visualization

Email this page | Print this page
 

Data Analysis and Visualization with Microsoft Excel 


To View Class Dates: Please use the pull-down options on the upper left of this page to select your course and city. You can then navigate to other classes in that same city, view class descriptions and register for the class or you call us and register now, 877-760-0078.

 

Effective March 12, 2020, all instructor-led classes at our offices can be taken LIVE ONLINE.  Same trainers, same outlines and same small classes (7 or less) and you can always take the in-person version at no added cost when the "coast is clear" (for classes offered at our physical offices only).

Want custom training for yourself or a group via live online medium? We can do that and have done that for over a decade now. For a quote, call 877 760 0078, email us at info@sonictraining.com or send us a note


Popular Collaborative Software Training Classes


 

To View Class Dates: Please use the pull down options on the upper left of this page to select your course and city. You can then navigate to other classes in that same city, view class descriptions and register for the class or you call us and register now, 877-760-0078.

  • Our Excel Introduction course is held before this course. It is a one-day class.
  • Want Excel training at your company site? (group or 1on1) -- click here.
  • We have taught thousands of business professionals throughout the years. Read what our students say
  • Free repeats! You are allowed to repeat your class for free within 6 months for any reason whatsoever! Classes are 9am to 4pm and come with courseware and CD to practice afterward.
  • Are you signing up for more MS Office classes? See our package discounts page

    •  

Excel Training

 

 

Data Analysis and Visualization with Microsoft Excel 

 

Course Description


Target Student:

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.

Prerequisites:

To ensure success, you should have baseline skill using Microsoft Excel worksheets, particularly in creating workbooks with formulas and functions. You can obtain this level of knowledge and skill by taking the following or any similar equivalent Sonic Training course:

Microsoft® Excel® Introduction

 

Course Content

Lesson 1: Data Analysis Fundamentals

Topic A: Data Analysis Scenarios

Topic B: 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: Best Practices for Selecting Charts

Lesson 3: Analyzing Data with Formulas and Functions

Topic A: Analyze Data with Formulas

Topic B: Analyze Data with Functions

Topic C: Analyze Data with Data Validation, Forms, and Controls

Topic D: Create Conditional Visualization 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

Topic C: Create a Dashboard in Excel

Lesson 6: Creating Geospatial Visualizations with Excel

Topic A: Create Map Charts in Excel

Topic B: Format and Customize Map Charts in Excel

Lesson 7: Performing Statistical Analysis

Topic A: Visualize Trendlines and Sparklines with Excel

Topic B: Analyze Data with the Data Analysis ToolPak

Lesson 8: Getting and Transforming Data

Topic A: Connect to Data with Queries

Topic B: Clean and Combine

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: Planning a Report

Topic B: Creating a Report