SE flag SE
+46 20 109 324
+46 20 109 324

Visual Analytics with Excel

Course 1295 Advantage Plan Course

  • Duration: 2 days
  • Labs: Yes
  • Language: English
  • Level: Foundation

Data doesn’t speak for itself, but with the right visuals, it can tell a story that drives real decisions. This two-day, hands-on course teaches participants how to unlock the full power of Microsoft Excel for visual data analytics. Through practical exercises and real-world examples, learners will explore foundational visualization principles, advanced charting techniques, interactive dashboards, and even AI-supported analysis.

By the end of the course, participants will know how to design clear, accurate, and engaging visuals; build dynamic dashboards; interpret patterns and insights; and confidently present data-driven stories to stakeholders.

Visual Analytics with Excel Delivery Methods

  • In-Person

  • Online

  • Upskill your whole team by bringing Private Team Training to your facility.

Visual Analytics with Excel Course Information

  • Course Benefits

    • Transform raw data into compelling visual narratives using Excel’s full suite of charting, formatting, and dashboarding tools.
    • Learn both the “why” and the “how” by combining strong visualization theory with step-by-step, real-world practice.
    • Build polished dashboards that highlight trends, outliers, and insights for business decision-making.
    • Avoid common visualization mistakes and learn to design visuals that are accurate, intuitive, and trustworthy.
    • Understand how AI fits into Excel workflows and how to structure data for AI-driven analysis and insights.
    • Boost confidence and credibility when presenting charts, dashboards, and data stories to colleagues and leadership. 

    Important Information:

    Prerequisites

    • Basic knowledge of Excel (data entry, formulas) highly recommended but not required.

Visual Analytics with Excel Course Outline

Chapter 1: Understanding Visual Data Analytics

  • Define Data Analytics
  • Discuss the relationship between Data Analytics and decision-making
  • Review the fundamentals of data visualization
  • Identify the data processing chain used in data mining

Chapter 2: Excel and Power Query Clean, Structure, and Use Data

  • Import and transform data with Power Query
  • Structure data with Power Pivot
  • Create queries or data tables in Excel
  • Work with the basics of data manipulation

Chapter 3: Using AI for Data Analysis with MS365 Copilot

  • Introduce AI
  • Discuss the benefits and drawback of using AI
  • Use AI with Excel Dashboards

Chapter 4: Using Excel’s Charting Tools

  • Overview of Excel Charting
  • Discuss Chart types and usage
  • Create Excel charts
  • Edit charts using chart items
  • Modify colors and styles for clarity
  • Work with data series
  • Consider chart templates

Chapter 5: Visual Analytics for Decision Making

  • Highlight use of trends and outliers
  • Create time series visualizations
  • Leverage conditional formatting

Chapter 6: Dashboards in Excel

  • Review principles of dashboard design
  • Integrate multiple charts and data sources
  • Create interactive elements
  • Build a functional dashboard

Chapter 7: Course Summary

Commercial Pricing

14 700 kr

  • 2-Day Instructor-Led Training

  • Hands On Labs

  • After-Course Instructor-Coaching Included

Would you like to take this course as a team?
  • nov. 2 - 3 9:00 - 16:30 CET
    Stockholm or Virtual
  • nov. 2 - 3 10:00 - 17:30 CET
    London or Virtual
  • nov. 30 - dec. 1 15:00 - 22:30 CET
    Virtual
  • dec. 14 - 15 9:00 - 16:30 CET
    Stockholm or Virtual
  • dec. 14 - 15 10:00 - 17:30 CET
    London or Virtual
  • jan. 11 - 12 15:00 - 22:30 CET
    Herndon, VA or Virtual
  • feb. 1 - 2 9:00 - 16:30 CET
    Stockholm or Virtual
  • feb. 1 - 2 10:00 - 17:30 CET
    London or Virtual
  • mars 1 - 2 15:00 - 22:30 CET
    Herndon, VA or Virtual
  • mars 22 - 23 9:00 - 16:30 CET
    Stockholm or Virtual
  • mars 22 - 23 10:00 - 17:30 CET
    London or Virtual
  • apr. 12 - 13 15:00 - 22:30 CEST
    Herndon, VA or Virtual
  • maj 4 - 5 9:00 - 16:30 CEST
    Stockholm or Virtual
  • maj 4 - 5 10:00 - 17:30 CEST
    London or Virtual
  • juni 1 - 2 15:00 - 22:30 CEST
    Herndon, VA or Virtual
  • juni 21 - 22 9:00 - 16:30 CEST
    Stockholm or Virtual
  • juni 21 - 22 10:00 - 17:30 CEST
    London or Virtual
  • juli 12 - 13 15:00 - 22:30 CEST
    Herndon, VA or Virtual
  • aug. 23 - 24 15:00 - 22:30 CEST
    Herndon, VA or Virtual

Scroll to view additional course dates

Speak with a Learning Consultant
* Required Fields

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Contact Us

Visual Analytics with Excel FAQs

Target Audience: Business professionals, analysts, students, and anyone interested in enhancing their data visualization skills.

No. Basic familiarity with Excel—such as entering data or using simple formulas—is helpful but not required. The course starts with foundational concepts and builds progressively.

Yes! Day 2 includes step-by-step guidance on designing and assembling interactive dashboards using charts, slicers, and form controls.

Not at all. The material is ideal for business professionals, managers, students, and anyone who wants to improve how they analyze and communicate data.

Yes. The course introduces how AI can support data analysis, how to prepare your data for AI tools, and how AI can enhance dashboards and insight generation.

Absolutely. Each day includes guided exercises where you’ll work directly with datasets to create charts, visuals, and a completed mini-dashboard.

Related Courses

  • Microsoft
    Excel Data Analysis Course

    Attend this Excel data analysis course and learn advanced Excel techniques including What-If analyses & PivotTables to better analyse your data.

    Intermediate
    2 days
    Online or In-class
    Starts from 12 250 kr
  • Learning Tree
    Introduction to Power BI Training

    In this Introduction to Power BI course, you will gain the basic skills and knowledge to manage and analyse data in Power BI.

    Foundation
    3 days
    Online or In-class
    Starts from 19 530 kr
  • Microsoft
    Microsoft Excel Training Course

    Master Excel basics with Learning Tree's Microsoft training course. Learn to create, edit, format and print spreadsheets in this beginner-friendly course.

    Foundation
    3 days
    Online or In-class
    Starts from 15 330 kr
  • Learning Tree
    Designing Data Models in Excel for Power BI Reports Training

    Learn to design BI Data Models for Power BI or Excel dashboards in our Designing Data Models in Excel for Power BI Reports Training.

    Intermediate
    3 days
    Online or In-class
    Starts from 19 530 kr