Microsoft Excel Training - Interactive Dashboards
Learn how to create Interactive Charts and Dashboard Designing in Excel, Which is in lot of demand these days.
4.30 (163 reviews)
1,349
students
10.5 hours
content
Sep 2020
last update
$69.99
regular price
What you will learn
How to create Dynamic and Interactive Charts in Excel from basics
How to create Form Controls
Create Interactive Charts in Excel with Form Controls
Learn Excel techniques by creating dashboards
Create your own Sales Dashboard
Understand how to use Vlookup, Hlookup, Index, Match and Offset functions
Understand how to use SUMIFS function
Streamline your own reports and reports of others.
This course will help you create dynamic, interactive charts in microsoft excel using excel form controls. On each exercise you will learn how to create customize charts in excel and create awesome reports in excel.
Why take this course?
This course will help you to create dynamic, interactive charts in excel using excel form controls. In each exercise you will learn how to create customize charts in excel and create awesome reports in excel.
You will get one course workbook and sample dashboard to do practice in this course. In my sample workbook, you will also get the step by step guide to create the Interactive and dynamic charts in excel.
These tutorials will give you career-building skills that you can use to become better in making chart reports and more efficient at your job.
Topics which we will cover in our exercise are:
1) How to create Chart in Excel
2) Tips about Chart Formatting
3) Form controls
4) Interactive Charts in Excel
5) How to Design Dashboard
So go ahead and learn from the following in depth Interactive Charts in excel.
Screenshots
Reviews
Rahul
June 15, 2023
One of the best Excel trainings I have attended. Request the trainer to provide some training on Power BI and Interactive Dashboard similar to this.
May be a comparison and difference between creating a dashboard through excel and Power BI would be great.
Daniel
December 12, 2022
The presenter appears very knowledgeable and has provided some quality examples. Explanations are thorough and easy to follow from start to finish.
I wish they had spent a bit more time on the polish and professionalism side of things. Some things were very distracting: not turning phones silent while recording, recording audio at the same level every time or adjusting it after recording, half of a video is just a black screen with the presenter talking, one of the quizzes' correct answers is wrong when you select it.
Rashmi
April 14, 2022
Course Material is really good and data covered from various industries. That's really good. Only problem with voice ..in few videos voice is very low.
you are really doing good job. Be confident.
Shamain
October 26, 2020
The course has been great so far. I am enjoying the step by step procedure and also loving the love the hands on experience using the downloaded file.
Jarrett
May 2, 2019
I really enjoyed the breakdown of how to generate the dashboards, and learned a few tricks I was not privy to before taking the course.
Davinder
January 17, 2019
Thanks Lokesh for creating such a wonderful course!
The course is meticulously designed and covers most of the professionally useful concepts-tips-tricks of Excel.
Specifically, I liked the 2nd half of the course which provided in-depth view of formatting charts and creating dashboards, which are must have skills in reporting jobs.
I am sure that like me, other learners must have gained confidence in creating summaries of tons of (quarterly and yearly) data, after going through cases described in the tutorial.
All the best!
Martin
October 15, 2017
Great examples to follow which are specific to the lesson being taught. Attempt made to exhaust all features that are possible in the dialogue boxes.
Ramakrishna
September 20, 2017
Fantastic.......really awesome. He made so much easy with Excel charts and formatting. Simply superb!!!!!
Abraão
August 18, 2017
Awesome course to remember some information. I've made an excel course but i did not practice that anymore. But now i can reach my goals at my job using excel.
Deborah
March 24, 2017
I like that you can look at the video then try doing it on your own. Instructor provides clear explanations of what he is doing.
Sharanya
June 16, 2016
Excellent! The author is very clear, pace is just right and very applicable to use at work right away.
Rod
November 18, 2015
I highly recommend this course for someone attempting to move from an intermediate range to a more advanced range in Excel which includes Dashboard design. I had some questions which I emailed to the instructor and he was quire prompt and professional with his answers..This course is an exceptional value for the cost!
Ricardo
June 24, 2015
Great course on how to create charts in excel. I thought that at the beginning it was going to be hard to understand the instructor because of the language but after the first set of videos and following with the excel examples I was able to understand perfectly. I really enjoyed this course as I have not found courses that explain how to work in excel as this one.
Sakshi
April 20, 2015
This course is very helpful in preparing charts in our Metrics file and also in reporting work in office.
Divya
April 3, 2015
Really liked the efforts put by Lokesh:) He's done a great job in explaining the topics, simple and easy learning which a fresher like me would not find it tough to grasp. I really liked the Exercise Excel Sheet put after each session so that one can practise side by side and excel learning the Formatting Charts.
Wish to have more such sessions like this in near future..!!
Charts
Price
Rating
Enrollment distribution
Related Topics
445916
udemy ID
3/12/2015
course created date
2/25/2020
course indexed date
Bot
course submited by