Download link
File List
-
01 Introduction/001 Course Overview and Introduction to Excel Dashboards.mp4 19.73 MB
02 Getting Your Data Ready/002 Ideal Data Formats.mp4 13.09 MB
03 Design Principles/003 Getting Your Design Right.mp4 5.22 MB
04 Display Principles/004 Charts and Tricks for Trending.mp4 37.37 MB
04 Display Principles/005 Secondary Axis.mp4 4.74 MB
04 Display Principles/006 Smoothing Data.mp4 12.25 MB
04 Display Principles/007 Sparklines.mp4 49.35 MB
04 Display Principles/008 Formatting Tricks.mp4 9.92 MB
04 Display Principles/009 Highlighting Comparisons.mp4 13.28 MB
04 Display Principles/010 Top and Bottom Ranking.mp4 24.04 MB
04 Display Principles/011 Frequency Distribution.mp4 17.15 MB
04 Display Principles/012 Target vs Variance Charts.mp4 12.08 MB
04 Display Principles/013 Performance Against Target Range.mp4 11.07 MB
04 Display Principles/014 Bullet Graphs.mp4 41.49 MB
04 Display Principles/015 WinLossDraw Conditional Format.mp4 22.34 MB
04 Display Principles/016 Dynamic Data Range.mp4 46.18 MB
04 Display Principles/017 Dynamic Labels.mp4 6.39 MB
04 Display Principles/018 Text Formulas.mp4 31.76 MB
04 Display Principles/019 Symbols in Formulas and Charts.mp4 19.99 MB
04 Display Principles/020 Charts Referencing Non-contiguous Ranges.mp4 5.81 MB
04 Display Principles/021 Embedding Graphics in Charts.mp4 14.48 MB
04 Display Principles/022 Dynamic, Dynamic Data Validation Lists.mp4 36.05 MB
04 Display Principles/023 In Cell Charts.mp4 29.18 MB
04 Display Principles/024 Panel Charts.mp4 31.92 MB
04 Display Principles/025 Step Charts.mp4 29.38 MB
04 Display Principles/026 Supplementary Excel Lecture Excel 2013 Chart Formatting.mp4 25.07 MB
04 Display Principles/027 Supplementary Excel Lecture Excel 2013 Chart Labels.mp4 22.86 MB
04 Display Principles/028 Supplementary Excel Lecture Excel 2013 Combo Charts.mp4 7.54 MB
05 Interactive Controls/029 Form Controls Introduction.mp4 8.15 MB
05 Interactive Controls/030 Check Boxes.mp4 10.21 MB
05 Interactive Controls/031 List Boxes.mp4 68.22 MB
05 Interactive Controls/032 Option Buttons.mp4 23.63 MB
05 Interactive Controls/033 Group Boxes.mp4 6.8 MB
05 Interactive Controls/034 Scroll Bar.mp4 9.87 MB
05 Interactive Controls/035 Buttons.mp4 7.67 MB
05 Interactive Controls/036 Combo Box with Macro.mp4 23.38 MB
05 Interactive Controls/037 Dynamic Date Filters 4 Ways.mp4 96.51 MB
05 Interactive Controls/038 Dynamic Named Range with OFFSET.mp4 20.37 MB
05 Interactive Controls/039 Dynamic Named Range with INDEX.mp4 27.2 MB
05 Interactive Controls/040 Dynamic Ranges for Charts.mp4 25.93 MB
05 Interactive Controls/041 Animating Charts.mp4 57.74 MB
05 Interactive Controls/042 INDIRECT Function Tricks.mp4 35.39 MB
05 Interactive Controls/043 Rollover Technique.mp4 43.83 MB
05 Interactive Controls/044 Scroll and Sort Table.mp4 77.13 MB
05 Interactive Controls/045 Supplementary Excel Lecture Inserting Drop Down Lists.mp4 7.17 MB
06 Analysing the Data/046 PivotCharts.mp4 20.73 MB
06 Analysing the Data/047 Slicers.mp4 23.88 MB
06 Analysing the Data/048 Capture Slicer Selection in Formula.mp4 16.18 MB
06 Analysing the Data/049 GETPIVOTDATA Function.mp4 55.41 MB
06 Analysing the Data/050 Slicer PivotChart Olympic Dashboard Overview.mp4 47.19 MB
06 Analysing the Data/051 Supplementary Excel Lecture Creating PivotTables.mp4 6.08 MB
06 Analysing the Data/052 Supplementary Excel Lecture Choosing Fields.mp4 7.56 MB
06 Analysing the Data/053 Supplementary Excel Lecture PivotTable Layout.mp4 7.71 MB
06 Analysing the Data/054 Supplementary Excel Lecture Filtering PivotTables.mp4 3.45 MB
06 Analysing the Data/055 Supplementary Excel Lecture Modifying PivotTable Data.mp4 2.94 MB
06 Analysing the Data/056 Supplementary Excel Lecture Insert a Table and Style Options.mp4 6.1 MB
06 Analysing the Data/057 Supplementary Excel Lecture Add Rows and Columns to a Table.mp4 4.91 MB
06 Analysing the Data/058 Supplementary Excel Lecture Perform a Function in a Table.mp4 7.99 MB
06 Analysing the Data/059 Supplementary Excel Lecture Summarize a Table with a PivotTable.mp4 6.08 MB
06 Analysing the Data/060 Supplementary Excel Lecture VLOOKUP Formula Sorted List.mp4 8.6 MB
06 Analysing the Data/061 Supplementary Excel Lecture VLOOKUP Formula Exact Match.mp4 21.53 MB
06 Analysing the Data/062 Supplementary Excel Lecture HLOOKUP Formula Sorted List.mp4 6.27 MB
06 Analysing the Data/063 Supplementary Excel Lecture HLOOKUP Formula Exact Match.mp4 2.61 MB
06 Analysing the Data/064 Supplementary Excel Lecture CHOOSE Function.mp4 12.83 MB
06 Analysing the Data/065 Supplementary Excel Lecture INDEX and MATCH Formula.mp4 13.97 MB
06 Analysing the Data/066 Supplementary Excel Lecture IF Function.mp4 17 MB
06 Analysing the Data/067 Supplementary Excel Lecture Nested IF Formula.mp4 15.04 MB
06 Analysing the Data/068 Supplementary Excel Lecture IF AND Formula.mp4 6.72 MB
06 Analysing the Data/069 Supplementary Excel Lecture IF OR Formula.mp4 6.1 MB
06 Analysing the Data/070 Supplementary Excel Lecture IF NOT Formula.mp4 4.7 MB
06 Analysing the Data/071 Supplementary Excel Lecture IFERROR Function.mp4 5.28 MB
06 Analysing the Data/072 Supplementary Excel Lecture SUMIF and SUMIFS Formulas.mp4 9.82 MB
06 Analysing the Data/073 Supplementary Excel Lecture AVERAGEIF and AVERAGEIFS Formulas.mp4 11.44 MB
06 Analysing the Data/074 Supplementary Excel Lecture COUNTIF and COUNTIFS Formulas.mp4 21.68 MB
06 Analysing the Data/075 Supplementary Excel Lecture SUMPRODUCT Formula.mp4 29.52 MB
07 Automating Your Dashboard/076 Linking to Access.mp4 32.43 MB
07 Automating Your Dashboard/077 Incorporating New Data Automatically.mp4 37.54 MB
07 Automating Your Dashboard/078 Auto Refresh PivotTables.mp4 13.27 MB
07 Automating Your Dashboard/079 Supplementary Excel Lecture Introduction to Macros.mp4 9.6 MB
07 Automating Your Dashboard/080 Supplementary Excel Lecture Recording a Macro.mp4 15.15 MB
07 Automating Your Dashboard/081 Supplementary Excel Lecture Assign a Macro to a Button or Shape.mp4 11.94 MB
07 Automating Your Dashboard/082 Supplementary Excel Lecture Run a Macro Upon Opening a Workbook.mp4 8.06 MB
07 Automating Your Dashboard/083 Supplementary Excel Lecture How to Inspect and Modify a Macro.mp4 11.71 MB
08 Putting It All Together/084 Quick Re-cap.mp4 4.12 MB
08 Putting It All Together/085 Example Dashboard Tour.mp4 12.12 MB
08 Putting It All Together/086 Pyramid Chart.mp4 31.98 MB
08 Putting It All Together/087 Array Formula Alternative to SUMIFS.mp4 33.16 MB
08 Putting It All Together/088 LARGE and SMALL Array and DAVERAGE.mp4 22.76 MB
08 Putting It All Together/089 Rank Values with PivotTable.mp4 14.9 MB
08 Putting It All Together/090 Scatter Chart.mp4 33.39 MB
08 Putting It All Together/091 DMAX, DMIN, DAVERAGE.mp4 22.21 MB
08 Putting It All Together/092 Formatting Quickly.mp4 27.44 MB
09 Distributing Your Dashboard/093 Checking and Publishing.mp4 4.41 MB
09 Distributing Your Dashboard/094 Excel Web App - Introduction.mp4 11.34 MB
09 Distributing Your Dashboard/095 Preparing Your File for Excel Web App.mp4 21.43 MB
09 Distributing Your Dashboard/096 Publish with Excel Web App.mp4 34.43 MB
09 Distributing Your Dashboard/097 Password Protection.mp4 59.58 MB
09 Distributing Your Dashboard/098 Supplementary Excel Lecture Workbook Passwords.mp4 6.32 MB
09 Distributing Your Dashboard/099 Supplementary Excel Lecture Protecting Workbooks.mp4 4.58 MB
09 Distributing Your Dashboard/100 Supplementary Excel Lecture Unlocking Cells.mp4 7.15 MB
10 Bonus Tour de France Dashboard/101 Dashboard Overview.mp4 66.22 MB
10 Bonus Tour de France Dashboard/102 SUMIFS Formula.mp4 26.74 MB
10 Bonus Tour de France Dashboard/103 INDEX, MATCH and OFFSET Formula.mp4 23.68 MB
10 Bonus Tour de France Dashboard/104 INDEX, MATCH Multiple Array Formula.mp4 13.34 MB
10 Bonus Tour de France Dashboard/105 Zoom Images VBA Code.mp4 56.98 MB
11 Homework/106 Myndas Homework Dashboard Part 1.mp4 48.25 MB
11 Homework/107 Myndas Homework Dashboard Part 2.mp4 106.67 MB
Download Info
-
Tips
“Udemy Excel with Interactive Excel Dashboards” Its related downloads are collected from the DHT sharing network, the site will be 24 hours of real-time updates, to ensure that you get the latest resources.This site is not responsible for the authenticity of the resources, please pay attention to screening.If found bad resources, please send a report below the right, we will be the first time shielding.
-
DMCA Notice and Takedown Procedure
If this resource infringes your copyright, please email([email protected]) us or leave your message here ! we will block the download link as soon as possiable.