HARTMANN software group

Data Analysis and Visualization with Microsoft Excel Training in Tinley Park

Enroll in or hire us to teach our Data Analysis and Visualization with Microsoft Excel class in Tinley Park, Illinois by calling us @303.377.6176. Like all HSG classes, Data Analysis and Visualization with Microsoft Excel may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it is scheduled: Public Training Classes
Provided there are enough attendees, Data Analysis and Visualization with Microsoft Excel may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.
get pricing information

Course Description

  

Technology and the data that it both collects and makes accessible is now interwoven with businesses and lives. The era of "big data" has exploded due to the rise of cloud computing, which provides an abundance of computational power and storage, enabling organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantage.

Course Length: 2 Days
Course Tuition: $690 (US)

Prerequisites
To ensure success, you should have baseline skill using Excel worksheets, particularly in creating workbooks with formulas and functions.

Course Outline

  
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

Course Directory [training on all levels]

Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.

Interesting Reads Take a class with us and receive a book of your choosing for 50% off MSRP.