Autoplay
Autocomplete
HTML5
Flash
Player
Speed
Previous Lecture
Complete and continue
Excel Dashboard Tutorial From Basic to Advanced
Download Working files for Section 1 & 2
Download Practice FIles
Section 1: Single sheet tracker
MRTS Sales Dashboard Question (2:22)
MRTS Sales Dashboard Solution 01 (3:24)
MRTS Sales Dashboard Solution 02 (3:00)
MRTS Sales Dashboard Solution 03 (2:29)
MRTS Sales Dashboard Solution 04 (3:46)
MRTS Sales Dashboard Solution 05 (5:18)
MRTS Sales Dashboard Solution 06 (6:40)
Power Generation Tracker Question (2:30)
Power Generation Tracker Solution (6:03)
Download Practice Files for SIngle Sheet Tracker
Download Working files for Section 3, 4 & 5
Download working files
Section 3: Pivot Table Dashboard
0101 Introduction to Dashboard Course (3:08)
0102 Introduction to 1st Dashboard (1:06)
0201 Understanding the data (1:41)
0202 Text Function (6:30)
0203 Dynamic data Create Table (7:16)
0204 Naming the dynamic data and the using it in function (4:21)
0205 Preparing 1st Pivot and updating data (5:28)
0206 Classic view and Filling blank with zero in Pivot (3:46)
0207 Create Chart for comparison from the Pivot (1:46)
0208 Create Trend line from the Pivot (8:18)
0209 Creating Pie Chart from Slab Report from Pivot (4:50)
0210 Preparing Framework for DashBoard (2:14)
0211 Inserting Slicer using Chart (3:18)
0212 Customize Slicer Setting (4:30)
Section 4: Map chart dashboard using Advanced Excel functions
0301 Brief on 2nd Dashboards (1:36)
0302 Importing Data from the Internet (4:39)
0303 Converting Line Item into a Currency Table (5:35)
0304 Calculation of Currency using INDEX and MATCH (3:24)
0305 Creating Slabs using Vlookup True Parameter (4:58)
0306 Creating Qtrs based on Financial or Calendar Selection (4:28)
0307 Preparing the base by removing duplicate for Dashboard (2:36)
0308 AverageIF for calculating Country Wise Salary (2:23)
0309 Substituting ERROR with zero using IFERROR (2:16)
0310 Introduction to Function INDIRECT Part 1 and 2 (10:13)
0311 Using Function INDIRECT to Retrieve AverageIF from relevant sheet (4:03)
0312 Using Function CountIf with INDIRECT to calculate No OF Emp (4:18)
0313 Calculating Contribution Country wise No Of Emp (2:29)
0314 Using NameRange to simplify calculation (2:48)
0315 Using NameRange with formula in 2nd Dashboard (5:18)
0316 Introduction to Offset Function (2:57)
0317 Offset Function in Excel (4:01)
0318 Using Offset Function in Dashboard (3:58)
0319 Use of MINIF in Dashboard (3:14)
0320 Use of MAXIF in Dashboard (2:41)
0321 Using Average to get Designation Wise Experience result (3:45)
0322 Using MAXIF with multiple conditions (3:26)
0323 Using MINIF with multiple conditions (1:28)
0324 Dynamic Dropdown List (2:06)
0325 longitude and latitude with plotting data on dashboard (3:08)
0326 Using REPT Function based on the percentage calculation (2:41)
0327 Activation of Developer Tab and creating Scroll Bar (4:04)
0328 Inserting Trend chart based on data (4:29)
0329 Advance INDEX and MATCH with multiple references (3:47)
0330 Inserting Spark Line (2:26)
0331 Insert World Map into the chart (1:58)
0332 Plotting Data on Map Chart (5:09)
0333 Controlling Map Preview from dropdown (3:39)
0334 Summarising 2nd Dashboard (3:29)
Section 5: Dynamic Dashboards using Excel Macros
Brief understanding on Dynamic Dashboards using Excel Macros (1:24)
Implementation of OFFSET for dynamic data (3:45)
Creating Trend Chart from 2 Pivot Table (3:46)
Modifying the Chart Settings for better view (2:10)
Using Macro recording for Trend Chart 01 (3:03)
Using macro to update pivot based on the Job Type (7:52)
Triggering macro with any change in sheets (2:42)
Creating Name Range using shortcut
Use of MAXIF and MINIF with single and multiple parameters (2:38)
Create chart to represent multiple parameters effectively 01 (2:53)
Create chart to represent multiple parameters effectively 02 (3:41)
Preparing data for Spiderweb chart and change the graph setting (4:39)
Using macro to Hide and Unhide working sheets (6:31)
Inserting Trendline and formatting for better view (3:15)
Conclusion of all 3 dashboard (3:25)
0324 Dynamic Dropdown List
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock