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
Section 2: Dashboard fundamentals
0101 Introduction to Dashboard - Why, When and How (4:12)
0102 Design Tips and Ideal Data Formats (6:32)
0103 Drawing Excel Charts (4:09)
0104 Building Up and Down Indicators on Charts (2:06)
0105 Formatting cells and tables in Excel (5:53)
0201 Trend Sparkline with variations (5:40)
0202 Bar Sparkline an Win and Loss Sparkline (6:09)
0203 Pie chart and formatting tips (4:04)
0204 Two-axis charts (3:55)
0205 Thermometer chart (2:39)
0206 Stacked Chart (4:39)
0207 Spider chart (2:48)
0208 Bubble chart (1:42)
0209 Bullet chart (3:41)
0210 Showing forecasting with line charts (3:27)
0211 Waterfall - New Charts in 2016 (3:18)
0212 Format Specific Period, Data Point, Marker, XY, Positive and Negative (3:45)
0213 Conditional Formatting in Graphs (2:14)
0214 Histogram Chart (4:32)
0301 VLOOKUP and HLOOKUP (8:59)
0302 MATCH and CHOOSE (3:06)
0303 INDEX Function (2:45)
0304 Indirect Function (3:09)
0305 Pivot tables basics (6:11)
0306 Pivot charts basics (7:03)
0401 Form Control with example (6:13)
0402 Check box controlled graph (2:58)
0403 List controlled graph (2:53)
0404 Chart with interactive legend (2:44)
0405 Graph using Macro (3:05)
0501 Overview of Dashboard (2:06)
0502 Identifying of Unique items for a dashboard (3:35)
0503 How to make lists in a dashboard (2:47)
0504 Building dashboard basic layout and formatting tips (4:14)
0505 Linking values in dashboard (5:34)
0506 Using Dynamic functions (4:08)
0507 Calculating values based on criteria (13:04)
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