All Training Courses

Data and Office

Microsoft Excel for Office 365/2019/2021: Dashboards

Turn spreadsheet data into dashboards that help colleagues spot patterns and make decisions.

1 Day · Live instructor-led training

What you will work on

  • Prepare tables and filter data
  • Design clear charts
  • Analyze with formulas and PivotTables
  • Combine visual insights into a dashboard

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

Who this course is for

Excel users beginning to build analytical dashboards.

Before you attend

Basic Excel 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.

Microsoft Excel for Office 365/2019/2021: Dashboards | Altvina Training | Altvina