All Training Courses

Data and Office

Data Analysis and Visualization with Microsoft Excel

Develop a practical Excel analysis workflow, from preparing data to presenting a useful visual story.

2 Days · Live instructor-led training

What you will work on

  • Prepare data with Power Query
  • Explore data with charts and PivotTables
  • Use statistics and data models
  • Present analysis through dashboards

What the course covers

Explore the curriculum to see how it fits the work you want to do.

Lesson 1: Data Analysis Fundamentals
  • Introduction to Data Science
  • Create and Modify Tables
  • Sort and Filter Data
Lesson 2: Visualizing Data with Excel
  • Visualize Data with Charts
  • Modify and Format Charts
  • Apply Best Practices in Chart Design
Lesson 3: Analyzing Data with Formulas and Functions
  • Analyze Data with Formulas and Named Ranges
  • Analyze Data with Functions
  • Implement Data Validation, Forms, and Controls
  • Create Conditional Visualizations with Lookup Functions
Lesson 4: Analyzing Data with PivotTables
  • Create a PivotTable
  • Analyze PivotTable Data
Lesson 5: Presenting Visual Insights with Dashboards in Excel
  • Visualize Data with PivotCharts
  • Filter Data Using Slicers and Timelines
  • Create a Dashboard in Excel
Lesson 6: Creating Geospatial Visualizations with Excel
  • Create Map Charts in Excel
  • Customize Map Charts in Excel
Lesson 7: Performing Statistical Analysis
  • Visualize Trendlines and Sparklines with Excel
  • Analyze Data with the Analysis ToolPak
Lesson 8: Getting and Transforming Data
  • Connect to Data with Queries
  • Clean and Combine Data
  • Shape and Transform Data
Lesson 9: Modeling and Analyzing Data with Power Pivot
  • Install Power Pivot in Excel
  • Create Data Models with Power Pivot
  • Create Power Pivots
  • Perform Advanced Data Analysis and Visualization
Lesson 10: Presenting Insights with Reports
  • Plan a Report
  • Create a Report

Who this course is for

Excel users ready to produce more capable analyses and reports.

Before you attend

Basic workbook, formula and function skills; Excel Part 1 or equivalent.

Included with this course

  • Live instructor-led class
  • A preparation checklist for prerequisites, class access and setup
  • Altvina support for questions, concerns and next-step guidance

Ongoing mentorship is a separate paid service.

Support from Altvina

Have a question about course fit, learner details or access? Our team is your contact for enrollment support.

Ask a Course Question

Payments, refunds and class changes

Clear payment dates

Pay a $50 deposit per learner or full tuition. With your explicit agreement, the remaining balance is charged seven days before class. You receive an advance reminder.

Flexible before the cutoff

Class payments are refundable until seven days before the start. After that they are non-refundable; contact Altvina if an issue arises.

If the scheduled class changes

If Altvina or the training provider cancels or materially changes your class, you can choose a refund or an alternative date. We will contact you to arrange your choice.

Training instruction is delivered by Logical Operations or the provider listed for the class. Altvina handles enrollment and customer support.

Data Analysis and Visualization with Microsoft Excel | Altvina Training | Altvina