Advanced Excel Dashboard with Business Intelligence
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
11 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Advanced Excel Dashboard with Business Intelligence to your Wishlist.

Add to Wishlist

Advanced Excel Dashboard with Business Intelligence

Step by Step Ways to Create Excel Dashboard for Data Analytics with Visual using Excel Tools, Functions and Excel Macros
New
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
11 students enrolled
Last updated 9/2017
English
English [Auto-generated]
Current price: $10 Original price: $50 Discount: 80% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 4 hours on-demand video
  • 1 Article
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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 Excel
View Curriculum
Requirements
  • Need basic understand of MS Excel
Description

Dashboard help user visualizes complex scenarios and problem better. Manager with the help of 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:

  1. 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..
  2. 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..
  3. 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
  • 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 is the target audience?
  • People who analyze data and create new insight
  • People who do reporting and create dashboards
  • Professionals working with large amount of Data
Compare to Other Excel Dashboard Courses
Curriculum For This Course
64 Lectures
03:56:56
+
Introduction to the Course
2 Lectures 03:10

Download the Excel Dashboard Practice Files
00:02
+
Learn to make Excel dashboard using Pivot tables
13 Lectures 55:04

Understanding the data in Excel
01:41


Dynamic Data to Create Table
07:16

Naming the dynamic data and the using it in function
04:21

Preparing 1st Pivot and updating data
05:28

Classic view and Filling blank with zero in Pivot
03:46

Create Chart for comparison from the Pivot Table
01:46

Create Trend line from the Pivot table
08:18

0209 Creating Pie Chart from Slab Report from Pivot
04:50

Preparing Framework for Dashboard
02:14

Inserting Slicer using Chart
03:18

Customize Slicer Setting
04:30
+
Learn to create Excel Dashboard using Functions
34 Lectures 02:03:30

Importing Data from the Internet
04:39

Converting Line Item into a Currency Table
05:35

Calculation of Currency using INDEX and MATCH
03:24

Creating Slabs using Vlookup True Parameter
04:58

Creating Quarters based on Financial or Calendar Selection
04:28

Preparing the base by removing duplicate for Dashboard
02:36

AverageIF for calculating Country Wise Salary
02:23

Substituting ERROR with zero using IFERROR
02:16

Introduction to Function INDIRECT Part 1 and 2
10:13

Using Function INDIRECT to Retrieve AverageIF from relevant sheet
04:03

Using Function CountIf with INDIRECT to calculate Number of Employees
04:18

Calculating Contribution Country wise Number of Employees
02:29

Using NameRange to simplify calculation
02:48

Using NameRange with formula in 2nd Dashboard
05:18

Introduction to Offset Function
02:57

Offset Function in Excel
04:01

Using Offset Function in Dashboard
03:58

Use of MINIF in Dashboard
03:14

Use of MAXIF in Dashboard
02:41

Using Average to get Designation Wise Experience result
03:45

Using MAXIF with multiple conditions
03:26

Using MINIF with multiple conditions
01:28

Dynamic Dropdown List
02:06

Longitude and Latitude with plotting data on Dashboard
03:08

Using REPT Function based on the percentage calculation
02:41

Activation of Developer Tab and creating Scroll Bar
04:04

Inserting Trend chart based on data
04:29

Advance INDEX and MATCH with multiple references
03:47

Inserting Spark Line
02:26

Insert World Map into the chart
01:58

Plotting Data on Map Chart
05:09

Controlling Map Preview from Dropdown
03:39

Summarizing 2nd Dashboard
03:29
+
Learn to create Excel Dashboard using Macros and Functions
14 Lectures 51:47

Implementation of OFFSET for Dynamic Data
03:45

Creating Trend Chart from Two Pivot Tables
03:46

Modifying the Chart Settings for Better View
02:10

Using Macro recording for Trend Chart
03:03

Using macro to update pivot based on the Job Type
07:52

Triggering macros with any change in Spreadsheets
02:42

Creating Name Range using Shortcut
03:28

Use of MAXIF and MINIF with Single and Multiple Parameters
02:38

Create chart to represent multiple parameters effectively - Part 01
02:53

Create chart to represent multiple parameters effectively - Part 02
03:41

Preparing data for Spiderweb chart and change the graph setting
04:39

Using macro to Hide and Unhide working sheets
06:31

Inserting Trendline and formatting for better view
03:15
+
Conclusion
1 Lecture 03:25
Conclusion of all 3 Excel dashboards
03:25
About the Instructor
Yoda Learning
4.4 Average rating
1,605 Reviews
37,105 Students
50 Courses
MS OFFICE & PMP | Join 40K+ Udemy Students Become 4X Faster

Yoda Learning is a team of 12+ industry professionals focused on developing “Project-based" learning solutions, which enable the learners explore real world situations and thus, make the learning process engaging and practical. Our Courses on Technology includes everything including Web Development, Mobile App Development, Data Analytics and Design.

The collective work-experience of 80+ yrs. spans across multiple industries like Manufacturing, IT, Sales, Finance, Marketing, Operations, HR and functional domains such as Office suites, Mobile applications, Digital Marketing, Database Technologies, Networking).

Rishabh Pugalia
4.2 Average rating
566 Reviews
9,872 Students
31 Courses
Excel & P.Point Ninja | Taught 12,000+ professionals (LIVE)

Rishabh Pugalia is a Chartered Accountant from India. He has worked with KPMG and J.P. Morgan before venturing into Corporate Training. He founded ExcelNext in December 2009 and has since trained 12,000+ professionals across various multi-national companies and professionals' forums.

He has delivered training programs on "Advanced Excel" in top Corporate houses. He has co-authored a Technical Guide issued by the Institute of Chartered Accountants of India (ICAI) - "Using Excel for Continuous Controls Monitoring" .

He is a visiting faculty at various premier B-Schools and has shared his knowledge on numerous Professionals' public forums.