Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Excel Interactive Dashboards and Data Analysis

via Udemy

Overview

Learn to create POWERFUL DATA ANALYSIS and INTERACTIVE dashboards in minutes with no coding, using Excel Pivot Tables

What you'll learn:
  • Enjoy CLEAR and CONCISE step by step lessons from a best selling Udemy instructor in FULL HD 1080 P
  • Discover the most POWERFUL tool in Excel to transform your Data into Insight and intelligence
  • LIFETIME access to course materials and practice activities
  • Learn POWERFUL data analysis techniques using comparison, trend, contribution, ranking, frequency, variance and pareto analysis
  • In this course you will learn how to create Sales, Human Resource and Finance interactive dashboards
  • Learn BEST PRACTICES for dashboard development, table and graph design
  • Learn powerful methods to easily GROUP and FILTER your data with a few clicks of the mouse

If you are new to Excel dashboards or data analysis or want to fill in some gaps in your knowledge, THIS is the course for you. We've focused on providing you with the fundamentals you need to work with Excel effectively!

Don't sit through days of boring training to understand how to create powerful interactive dashboards and data analysis that work! This course will get you up to speed and working in half the time, giving you the crucial foundation to start you on the journey to becoming an Excel dashboard and data analysis expert!


This course has been updated for 2023 in full HD video quality, so you will learn on the latest Excel interface. Students who have taken this course have this to say:

  • "I thought i know Pivot tables, report and dashboards, but i was shocked to see one can do so much in reports, pivot tables and dashboards...Thanks Ian For this amazing course. I am glad i found it...Thanks once again. "

  • "Im really excited to use this tools, all the information was very clear and easy to understand, thank you!!"

  • "Nice pace. Instructor knew the material and delivered it in a clear and understandable way"

  • "A very well structured course , taking the student from A to Z of Pivot tables , theory and practical aspects of Interactive Dashboards . A must for a foundation for other data analysis courses"

Lifetime access to course materials and practice activities

This course is lead by Ian Littlejohn - an international trainer, consultant and data analyst with over 200 000 enrollments & 150 000 students on Udemy. Ian specializes in teaching data analysis techniques, Excel Pivot Tables, Power Pivot, Microsoft Power BI, Google Data Studio & Amazon Quicksight & his courses average over 4.5 stars out of 5


In this course you will learn the following key outcomes:

  • How to STRUCTUREyour data for dashboards and data analysis

  • Create PIVOTTABLESto easily summarize and aggregate your data

  • Use Excel SLICERSto filter tables and graphs

  • Create INTERACTIVEdashboards combining Key Metrics, Trend Graphs, Top 10 analysis, comparisons, Pie graphs and more

  • Understand how to EASILYcreate time / trend analysis using a few clicks of the mouse

  • Filter and create Top 10 analysis

  • Learn how to use comparison, trend, ranking, contribution, variance, frequency and pareto analysis

  • Create a Sales, Human Resource and Finance dashboard

  • Use Conditional Formatting to highlight key data and trends

This course will teach you the best practices and principles for dashboard design and creating graphs.

Comparison Analysis

  • Trend Analysis

  • Ranking Analysis

  • Contribution Analysis

  • Variance Analysis

  • Pareto Analysis

Taught by

Ian Littlejohn

Reviews

4.6 rating at Udemy based on 5330 ratings

Start your review of Excel Interactive Dashboards and Data Analysis

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.