Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
10 Hour(s) 21 Minute(s)
Language
English
Taught by
Lokesh Paliwal
Rating
3 views
Course Overview
Learn how to create Interactive Charts and Dashboard Designing in Excel, Which is in lot of demand these days.
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.
Course Content
- 14 section(s)
- 57 lecture(s)
- Section 1 Getting Started
- Section 2 Custom Formatting
- Section 3 Section 3: Advanced Formulas and Functions
- Section 4 Section 4: Data Validation
- Section 5 Pivot Tables
- Section 6 WHAT IF ANALYSIS
- Section 7 Text Functions
- Section 8 Lookup and Reference Functions
- Section 9 Charting and Custom Charts
- Section 10 Interactive chart with Form Controls
- Section 11 Dashboard Designing
- Section 12 SALES DASHBOARD
- Section 13 CALL CENTER: HOURLY CALL VOLUME ANALYSIS DASHBOARD
- Section 14 PRODUCT DASHBOARD
What You’ll 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.
Reviews
-
SSteve Simchen
Just started but great so far
-
KKhatiejah Yusof
really help me in step by step to do the dashboard.
-
RRahul Upadhyay
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.
-
DDaniel DaSilva
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.
