Microsoft Advanced Excel Dashboard : Zero To Hero (Complete)
What you'll learn
- Analyze data and create reports in a fraction of the time of spreadsheets
- Create new powerful calculations, KPIs and Key Metrics
- Plot data on Map in Advanced Excel Dashboard
- Learn 3 types of Dashboards in this course
- Learn to make Excel Dashboard using Pivot tables
- Learn to create Excel Dashboard using Functions
- Learn to create Excel Dashboard using Macros and Functions
- Get Conclusion of all 3 Excel dashboards
Requirements
- Course works on all Microsoft Excel versions 2003, 2007, 2010, 2013, 2016. Of course the newer the better, but some features works same in all the versions.
- You just need to have Basic understanding of Excel because i'll take you to the advanced level in this Excel Dashboard Course
Description
Microsoft Excel Dashboard help user visualizes complex scenarios and problem better. Manager with the help of Advanced Excel dashboard can make better business decisions.
Our course is meant for professional working at different levels of careers, i.e., From MIS executive to Data Analyst.
MS Excel made it easy to make Dashboards for any Analytics. Business user can easily analyze data to create powerful reports and dashboards in a fraction of the time of traditional spreadsheets.
In this course, you'll learn to make dashboard in Excel in different ways:
Dashboard using Pivot Table like Multiple Pivot, Interlinked Pivot, Slicer buttons to control charts, Advanced Charts, etc.
Text Function in Excel
Naming the dynamic data and the using it in function
Create Chart for comparison from the Pivot table
Create Trend line from the Pivot table
Creating Pie Chart from Slab Report from Pivot table
Inserting Slicer using Chart & Customize Slicer Setting
more..
Dashboard using Excel Functions:
Importing Data from the Internet
Converting Line Item into a Currency Table
Calculation of Currency using INDEX and MATCH
AverageIF for calculating Country Wise Salary
Dynamic Dropdown
List longitude and latitude with plotting data on dashboard
Using REPT Function based on the percentage calculation
Advanced INDEX and MATCH with multiple references
Insert World Map into the chart
Plotting Data on Map Chart and Controlling Map Preview from drop-down
Preparing the base by removing duplicate for Dashboard
more..
Dashboard using Excel Macros & Functions
Implementation of OFFSET for dynamic data
Using macro to update pivot table based on the Job Type
Preparing data for Spiderweb chart and change the graph setting
Use of Array functions like MAXIF and MINIF with single and multiple parameters
Creating Name Range using shortcut
more..
This course is for all business users who want to learn how to create management reports, analyze data and create interactive dashboards using Excel 2010 and later versions.
Important information before you join:
Once enrolled, you have unlimited, lifetime access to the course!
You will have instant and free access to any updates I'll add to the course.
I will give you my full support regarding any issues or suggestions related to the course.
Access to all videos 24 x 7 - learn online from anywhere
A 30-day money back guarantee (we want you to be 100% satisfied)
--------------------------------------------------------------------------------------------------------------------------------
If you have read this far, next action is JOINING this course. Invest 4 hrs. for the benefit of lifetime Ninja status on Advanced Excel Dashboard Course.
Who this course is for:
- People who analyze data and create new insight
- People who do reporting and create dashboards
- Professionals working with large amount of Data
Course content
2 lectures • 3minIntroduction to the Course
- Preview03:08
- 00:02Download the Excel Dashboard Practice Files + Shortcuts
13 lectures • 55minLearn to make Excel dashboard using Pivot tables
34 lectures • 2hr 4minLearn to create Excel Dashboard using Functions
14 lectures • 52minLearn to create Excel Dashboard using Macros and Functions
1 lecture • 3minConclusion
Instructor
![Yoda Learning](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.3 Instructor Rating
- 7,610 Reviews
- 117,560 Students
- 29 Courses
20,000 Classroom Students | 100,000+ Students Online
ex-KPMG, ex-J.P. Morgan | Chartered Accountant
Taught 12k+ participants across PwC, EY and Deloitte over last 10 years
I am a Chartered Accountant from India. I have worked with KPMG (Audit) and J.P. Morgan (Debt Capital Markets) and Futures First (Proprietary Trading Desk) before venturing into Corporate Training (first part-time and then full-time)
After a decade of corporate training and winning multiple accolades in Office Productivity and Financial Modelling, in 2015, I created a mission to help 1 million people by 2020. I started creating high-quality video courses and helped people online to become faster-smarter-better at work. A lot of my students at PwC, EY, Deloitte, Amazon, Uber, Tata Group, Rio Tinto use these video courses to excel at work.
If I’m going to succeed in my mission of helping 1 million professional in the next five years, I NEED YOU to succeed… I can’t reach my goal without helping you reach yours!