Microsoft Advanced Excel Dashboard : Zero To Hero (Complete)

  • Course provided by Udemy
  • Study type: Online
  • Starts: Anytime
  • Price: See latest price on Udemy
Udemy

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:

  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

  • 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
  • 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 Show more Show less Course content 5 sections • 64 lectures • 3h 56m total length Expand all sections Introduction to the Course 2 lectures • 3min Introduction to Dashboard Course Preview 03:08 Download the Excel Dashboard Practice Files + Shortcuts 00:02 Learn to make Excel dashboard using Pivot tables 13 lectures • 55min Introduction to 1st Dashboard Preview 01:06 Understanding the data in Excel 01:41 Text Function in Excel Preview 06:30 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 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 • 2hr 4min Brief on 2nd Dashboards Preview 01:36 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 • 52min Brief on 3rd Dashboards Preview 01:24 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 • 3min Conclusion of all 3 Excel dashboards 03:25 Instructor Yoda Learning Data Analyst |MS Office Expert & PMP | Instructor/Programmer 4.4 Instructor Rating 8,870 Reviews 129,399 Students 28 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! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67737ff5af3f06f9',m:'c4adbf8f98ddefab48ac1575a735cd692211b6e7-1627699624-1800-Aej7MVuz097WjR88JqjqfHFG2hxoueSZEVNQvPRlgMk90W/lH1hZ7t/FmukfK8xKZf844Nh/st7vgXbxTWApFbnB68kVU7htCnljRg4U2rwNcRSxq63kVrGjRngXbWjUlq34lelBIpRYJqw9lQIHwiUSD+jJcDkBKi+1ZhYv/AYOwDzbVT0N6VAblY8AQtFLIw==',s:[0xd1b94e706e,0x8edfe117e9],}})();
  • 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 Show more Show less Course content 5 sections • 64 lectures • 3h 56m total length Expand all sections Introduction to the Course 2 lectures • 3min Introduction to Dashboard Course Preview 03:08 Download the Excel Dashboard Practice Files + Shortcuts 00:02 Learn to make Excel dashboard using Pivot tables 13 lectures • 55min Introduction to 1st Dashboard Preview 01:06 Understanding the data in Excel 01:41 Text Function in Excel Preview 06:30 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 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 • 2hr 4min Brief on 2nd Dashboards Preview 01:36 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 • 52min Brief on 3rd Dashboards Preview 01:24 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 • 3min Conclusion of all 3 Excel dashboards 03:25 Instructor Yoda Learning Data Analyst |MS Office Expert & PMP | Instructor/Programmer 4.4 Instructor Rating 8,870 Reviews 129,399 Students 28 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! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67737ff5af3f06f9',m:'c4adbf8f98ddefab48ac1575a735cd692211b6e7-1627699624-1800-Aej7MVuz097WjR88JqjqfHFG2hxoueSZEVNQvPRlgMk90W/lH1hZ7t/FmukfK8xKZf844Nh/st7vgXbxTWApFbnB68kVU7htCnljRg4U2rwNcRSxq63kVrGjRngXbWjUlq34lelBIpRYJqw9lQIHwiUSD+jJcDkBKi+1ZhYv/AYOwDzbVT0N6VAblY8AQtFLIw==',s:[0xd1b94e706e,0x8edfe117e9],}})();
  • 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 Show more Show less Course content 5 sections • 64 lectures • 3h 56m total length Expand all sections Introduction to the Course 2 lectures • 3min Introduction to Dashboard Course Preview 03:08 Download the Excel Dashboard Practice Files + Shortcuts 00:02 Learn to make Excel dashboard using Pivot tables 13 lectures • 55min Introduction to 1st Dashboard Preview 01:06 Understanding the data in Excel 01:41 Text Function in Excel Preview 06:30 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 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 • 2hr 4min Brief on 2nd Dashboards Preview 01:36 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 • 52min Brief on 3rd Dashboards Preview 01:24 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 • 3min Conclusion of all 3 Excel dashboards 03:25 Instructor Yoda Learning Data Analyst |MS Office Expert & PMP | Instructor/Programmer 4.4 Instructor Rating 8,870 Reviews 129,399 Students 28 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! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67737ff5af3f06f9',m:'c4adbf8f98ddefab48ac1575a735cd692211b6e7-1627699624-1800-Aej7MVuz097WjR88JqjqfHFG2hxoueSZEVNQvPRlgMk90W/lH1hZ7t/FmukfK8xKZf844Nh/st7vgXbxTWApFbnB68kVU7htCnljRg4U2rwNcRSxq63kVrGjRngXbWjUlq34lelBIpRYJqw9lQIHwiUSD+jJcDkBKi+1ZhYv/AYOwDzbVT0N6VAblY8AQtFLIw==',s:[0xd1b94e706e,0x8edfe117e9],}})();
  • 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 Show more Show less Course content 5 sections • 64 lectures • 3h 56m total length Expand all sections Introduction to the Course 2 lectures • 3min Introduction to Dashboard Course Preview 03:08 Download the Excel Dashboard Practice Files + Shortcuts 00:02 Learn to make Excel dashboard using Pivot tables 13 lectures • 55min Introduction to 1st Dashboard Preview 01:06 Understanding the data in Excel 01:41 Text Function in Excel Preview 06:30 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 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 • 2hr 4min Brief on 2nd Dashboards Preview 01:36 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 • 52min Brief on 3rd Dashboards Preview 01:24 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 • 3min Conclusion of all 3 Excel dashboards 03:25 Instructor Yoda Learning Data Analyst |MS Office Expert & PMP | Instructor/Programmer 4.4 Instructor Rating 8,870 Reviews 129,399 Students 28 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! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67737ff5af3f06f9',m:'c4adbf8f98ddefab48ac1575a735cd692211b6e7-1627699624-1800-Aej7MVuz097WjR88JqjqfHFG2hxoueSZEVNQvPRlgMk90W/lH1hZ7t/FmukfK8xKZf844Nh/st7vgXbxTWApFbnB68kVU7htCnljRg4U2rwNcRSxq63kVrGjRngXbWjUlq34lelBIpRYJqw9lQIHwiUSD+jJcDkBKi+1ZhYv/AYOwDzbVT0N6VAblY8AQtFLIw==',s:[0xd1b94e706e,0x8edfe117e9],}})();
  • 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 Show more Show less Course content 5 sections • 64 lectures • 3h 56m total length Expand all sections Introduction to the Course 2 lectures • 3min Introduction to Dashboard Course Preview 03:08 Download the Excel Dashboard Practice Files + Shortcuts 00:02 Learn to make Excel dashboard using Pivot tables 13 lectures • 55min Introduction to 1st Dashboard Preview 01:06 Understanding the data in Excel 01:41 Text Function in Excel Preview 06:30 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 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 • 2hr 4min Brief on 2nd Dashboards Preview 01:36 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 • 52min Brief on 3rd Dashboards Preview 01:24 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 • 3min Conclusion of all 3 Excel dashboards 03:25 Instructor Yoda Learning Data Analyst |MS Office Expert & PMP | Instructor/Programmer 4.4 Instructor Rating 8,870 Reviews 129,399 Students 28 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! Show more Show less Udemy Business Teach on Udemy Get the app About us Contact us Careers Blog Help and Support Affiliate Impressum Kontakt Terms Privacy policy Cookie settings Sitemap © 2021 Udemy, Inc. window.handleCSSToggleButtonClick = function (event) { var target = event.currentTarget; var cssToggleId = target && target.dataset && target.dataset.cssToggleId; var input = cssToggleId && document.getElementById(cssToggleId); if (input) { if (input.dataset.type === 'checkbox') { input.dataset.checked = input.dataset.checked ? '' : 'checked'; } else { input.dataset.checked = input.dataset.allowToggle && input.dataset.checked ? '' : 'checked'; var radios = document.querySelectorAll('[name="' + input.dataset.name + '"]'); for (var i = 0; i (function(){window['__CF$cv$params']={r:'67737ff5af3f06f9',m:'c4adbf8f98ddefab48ac1575a735cd692211b6e7-1627699624-1800-Aej7MVuz097WjR88JqjqfHFG2hxoueSZEVNQvPRlgMk90W/lH1hZ7t/FmukfK8xKZf844Nh/st7vgXbxTWApFbnB68kVU7htCnljRg4U2rwNcRSxq63kVrGjRngXbWjUlq34lelBIpRYJqw9lQIHwiUSD+jJcDkBKi+1ZhYv/AYOwDzbVT0N6VAblY8AQtFLIw==',s:[0xd1b94e706e,0x8edfe117e9],}})();
  • 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 Show more Show less Course content 5 sections • 64 lectures • 3h 56m total length Expand all sections Introduction to the Course 2 lectures • 3min Introduction to Dashboard Course Preview 03:08 Download the Excel Dashboard Practice Files + Shortcuts 00:02 Learn to make Excel dashboard using Pivot tables 13 lectures • 55min Introduction to 1st Dashboard Preview 01:06 Understanding the data in Excel 01:41 Text Function in Excel Preview 06:30 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 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 • 2hr 4min Brief on 2nd Dashboards Preview 01:36 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 • 52min Brief on 3rd Dashboards Preview 01:24 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 • 3min Conclusion of all 3 Excel dashboards 03:25 Instructor Yoda Learning Data Analyst |MS Office Expert & PMP | Instructor/Programmer 4.4 Instructor Rating 8,870 Reviews 129,399 Students 28 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 ven