Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Excel Interactive Dashboards and Data Analysis

Learn to create POWERFUL, INTERACTIVE dashboards in Excel in minutes with no coding
4.6
4.6/5
(2,011 reviews)
5,350 students
Created by

10.0

CourseMarks Score®

10.0

Freshness

10.0

Feedback

9.4

Content

Platform: Udemy
Video: 4h 50m
Language: English
Next start: On Demand

Top Excel Dashboard courses:

Detailed Analysis

CourseMarks Score®

10.0 / 10

CourseMarks Score® helps students to find the best classes. We aggregate 18 factors, including freshness, student feedback and content diversity.

Freshness Score

10.0 / 10
This course was last updated on 6/2021 .

Course content can become outdated quite quickly. After analysing 71,530 courses, we found that the highest rated courses are updated every year. If a course has not been updated for more than 2 years, you should carefully evaluate the course before enrolling.

Student Feedback

10.0 / 10
We analyzed factors such as the rating (4.6/5) and the ratio between the number of reviews and the number of students, which is a great signal of student commitment.

New courses are hard to evaluate because there are no or just a few student ratings, but Student Feedback Score helps you find great courses even with fewer reviews.

Content Score

9.4 / 10
Video Score: 8.3 / 10
The course includes 4h 50m video content. Courses with more videos usually have a higher average rating. We have found that the sweet spot is 16 hours of video, which is long enough to teach a topic comprehensively, but not overwhelming. Courses over 16 hours of video gets the maximum score.
The average video length is 4 hours 19 minutes of 49 Excel Dashboard courses on Udemy.
Detail Score: 10.0 / 10

The top online course contains a detailed description of the course, what you will learn and also a detailed description about the instructor.

Extra Content Score: 9.9 / 10

Tests, exercises, articles and other resources help students to better understand and deepen their understanding of the topic.

This course contains:

13 articles.
2 resources.
0 exercise.
0 test.

Table of contents

Description

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 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 2021 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 125 000 enrollments & 100 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. 
Excel is the most commonly used data analysis tools available on the market today. In this course we show you how to create POWERFUL INTERACTIVE dashboards in minutes using standard Excel tools and techniques. (No coding or complicated methods required!)
We also discuss how to create and use BEST PRACTICE for your dashboards.
•How to configure a dashboard
•What graphs you should use to display what types of data
•What questions you should ask of the data
•What methods of analysis you can use in the data
In this course we answer these questions and more! We GUARANTEE that you will be able to EASILY create interactive dashboards and understand the most powerful methods of data analysis.
In the course you will learn the following key outcomes:
•How to STRUCTURE your data for dashboards and data analysis
•Create PIVOT TABLES to easily summarize and aggregate your data
•Use Excel SLICERS to create filter tables and graphs
•Create INTERACTIVE dashboards combining Key Metrics, Trend Graphs, Top 10 reports, Comparisons, Pie graphs and more
•Understand how to EASILY create time / trend analysis using a few clicks of the mouse
•Filter data and create Top 10 analysis
•Learn how to do 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. In addition you will learn the following forms of data analysis:
•Comparison Analysis
•Trend Analysis
•Ranking Analysis
•Contribution Analysis
•Variance Analysis
•Pareto Analysis

You will 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

Requirements

• You should know how to work with spreadsheets with Excel 2013 or 2016You will require Excel 2013 or 2016

This course is for

• Excel users who want to learn reporting, data analysis and dashboards
• Excel users who want to learn the power of Pivot Tables and Pivot Charts

How much does the Excel Interactive Dashboards and Data Analysis course cost? Is it worth it?

The course costs $16.99. And currently there is a 82% discount on the original price of the course, which was $94.99. So you save $78 if you enroll the course now.
The average price is $18.7 of 49 Excel Dashboard courses on Udemy.

Does the Excel Interactive Dashboards and Data Analysis course have a money back guarantee or refund policy?

YES, Excel Interactive Dashboards and Data Analysis has a 30-day money back guarantee. The 30-day refund policy is designed to allow students to study without risk.

Are there any SCHOLARSHIPS for this course?

Currently we could not find a scholarship for the Excel Interactive Dashboards and Data Analysis course, but there is a $78 discount from the original price ($94.99). So the current price is just $16.99.

Who is the instructor? Is Ian Littlejohn a SCAM or a TRUSTED instructor?

Ian Littlejohn has created 17 courses that got 44,687 reviews which are generally positive. Ian Littlejohn has taught 137,830 students and received a 4.6 average review out of 44,687 reviews. Depending on the information available, Ian Littlejohn is a TRUSTED instructor.
Excel Power Tools, Power BI and Google Data Studio Trainer
Ian is a trainer that specializes in Microsoft Power BI, Excel Pivot Tables, Power Pivot, Power Query, Google Data Studio and AWS QuickSight.

 Ian is an experienced trainer that teaches techniques and tools making it easy for learners to harness the power of business intelligence tools to easily turn data into insight and intelligence.

Ian has been training learners on these powerful technologies for over 10 years making it easy for business users to easily create management reports, develop interactive dashboards and generate new insight and intelligence from business data. 

Ian has over 10 years of Management Consulting experience and he brings this knowledge and skills to his training course showing Excel and Google Data Studio users how to easily create sophisticated management reports, perform data analysis and create amazing interactive dashboards without using any complex programming or specialized tools. 

Ian has consulted and worked with major organizations in the Banking, Insurance, Manufacturing, Telecommunications and Logistics industries across a number of countries and continents. 

10.0

CourseMarks Score®

10.0

Freshness

10.0

Feedback

9.4

Content

Platform: Udemy
Video: 4h 50m
Language: English
Next start: On Demand

Students are also interested in

Review widget (for course creators):

Excel Interactive Dashboards and Data Analysis rating
Code for the widget (just copy and paste it to your site):
<a href="https://coursemarks.com/course/excel-interactive-dashboards-and-data-analysis/" target="_blank" title="Excel Interactive Dashboards and Data Analysis on Coursemarks.com"><img border="0" src="https://coursemarks.com/widget/100.svg" width="200px" alt="Excel Interactive Dashboards and Data Analysis rating"/></a>