Udemy Excel with Interactive Excel Dashboards | B78557731E96FCBCAC67B020C4A57339058A7FE5

Udemy Excel with Interactive Excel Dashboards

Name	Udemy Excel with Interactive Excel Dashboards	DOWNLOAD Copy Link
Total Size	2.5 GB
Total Files	107
Hash	B78557731E96FCBCAC67B020C4A57339058A7FE5

/01 Introduction/
001 Course Overview and Introduction to Excel Dashboards.mp4	20.7 MB
/02 Getting Your Data Ready/
002 Ideal Data Formats.mp4	13.7 MB
/03 Design Principles/
003 Getting Your Design Right.mp4	5.5 MB
/04 Display Principles/
004 Charts and Tricks for Trending.mp4	39.2 MB
005 Secondary Axis.mp4	5.0 MB
006 Smoothing Data.mp4	12.8 MB
007 Sparklines.mp4	51.8 MB
008 Formatting Tricks.mp4	10.4 MB
009 Highlighting Comparisons.mp4	13.9 MB
010 Top and Bottom Ranking.mp4	25.2 MB
011 Frequency Distribution.mp4	18.0 MB
012 Target vs Variance Charts.mp4	12.7 MB
013 Performance Against Target Range.mp4	11.6 MB
014 Bullet Graphs.mp4	43.5 MB
015 WinLossDraw Conditional Format.mp4	23.4 MB
016 Dynamic Data Range.mp4	48.4 MB
017 Dynamic Labels.mp4	6.7 MB
018 Text Formulas.mp4	33.3 MB
019 Symbols in Formulas and Charts.mp4	21.0 MB
020 Charts Referencing Non-contiguous Ranges.mp4	6.1 MB
021 Embedding Graphics in Charts.mp4	15.2 MB
022 Dynamic, Dynamic Data Validation Lists.mp4	37.8 MB
023 In Cell Charts.mp4	30.6 MB
024 Panel Charts.mp4	33.5 MB
025 Step Charts.mp4	30.8 MB
026 Supplementary Excel Lecture Excel 2013 Chart Formatting.mp4	26.3 MB
027 Supplementary Excel Lecture Excel 2013 Chart Labels.mp4	24.0 MB
028 Supplementary Excel Lecture Excel 2013 Combo Charts.mp4	7.9 MB
/05 Interactive Controls/
029 Form Controls Introduction.mp4	8.5 MB
030 Check Boxes.mp4	10.7 MB
031 List Boxes.mp4	71.5 MB
032 Option Buttons.mp4	24.8 MB
033 Group Boxes.mp4	7.1 MB
034 Scroll Bar.mp4	10.4 MB
035 Buttons.mp4	8.0 MB
036 Combo Box with Macro.mp4	24.5 MB
037 Dynamic Date Filters 4 Ways.mp4	101.2 MB
038 Dynamic Named Range with OFFSET.mp4	21.4 MB
039 Dynamic Named Range with INDEX.mp4	28.5 MB
040 Dynamic Ranges for Charts.mp4	27.2 MB
041 Animating Charts.mp4	60.5 MB
042 INDIRECT Function Tricks.mp4	37.1 MB
043 Rollover Technique.mp4	46.0 MB
044 Scroll and Sort Table.mp4	80.9 MB
045 Supplementary Excel Lecture Inserting Drop Down Lists.mp4	7.5 MB
/06 Analysing the Data/
046 PivotCharts.mp4	21.7 MB
047 Slicers.mp4	25.0 MB
048 Capture Slicer Selection in Formula.mp4	17.0 MB
049 GETPIVOTDATA Function.mp4	58.1 MB
050 Slicer PivotChart Olympic Dashboard Overview.mp4	49.5 MB
051 Supplementary Excel Lecture Creating PivotTables.mp4	6.4 MB
052 Supplementary Excel Lecture Choosing Fields.mp4	7.9 MB
053 Supplementary Excel Lecture PivotTable Layout.mp4	8.1 MB
054 Supplementary Excel Lecture Filtering PivotTables.mp4	3.6 MB
055 Supplementary Excel Lecture Modifying PivotTable Data.mp4	3.1 MB
056 Supplementary Excel Lecture Insert a Table and Style Options.mp4	6.4 MB
057 Supplementary Excel Lecture Add Rows and Columns to a Table.mp4	5.1 MB
058 Supplementary Excel Lecture Perform a Function in a Table.mp4	8.4 MB
059 Supplementary Excel Lecture Summarize a Table with a PivotTable.mp4	6.4 MB
060 Supplementary Excel Lecture VLOOKUP Formula Sorted List.mp4	9.0 MB
061 Supplementary Excel Lecture VLOOKUP Formula Exact Match.mp4	22.6 MB
062 Supplementary Excel Lecture HLOOKUP Formula Sorted List.mp4	6.6 MB
063 Supplementary Excel Lecture HLOOKUP Formula Exact Match.mp4	2.7 MB
064 Supplementary Excel Lecture CHOOSE Function.mp4	13.5 MB
065 Supplementary Excel Lecture INDEX and MATCH Formula.mp4	14.6 MB
066 Supplementary Excel Lecture IF Function.mp4	17.8 MB
067 Supplementary Excel Lecture Nested IF Formula.mp4	15.8 MB
068 Supplementary Excel Lecture IF AND Formula.mp4	7.1 MB
069 Supplementary Excel Lecture IF OR Formula.mp4	6.4 MB
070 Supplementary Excel Lecture IF NOT Formula.mp4	4.9 MB
071 Supplementary Excel Lecture IFERROR Function.mp4	5.5 MB
072 Supplementary Excel Lecture SUMIF and SUMIFS Formulas.mp4	10.3 MB
073 Supplementary Excel Lecture AVERAGEIF and AVERAGEIFS Formulas.mp4	12.0 MB
074 Supplementary Excel Lecture COUNTIF and COUNTIFS Formulas.mp4	22.7 MB
075 Supplementary Excel Lecture SUMPRODUCT Formula.mp4	31.0 MB
/07 Automating Your Dashboard/
076 Linking to Access.mp4	34.0 MB
077 Incorporating New Data Automatically.mp4	39.4 MB
078 Auto Refresh PivotTables.mp4	13.9 MB
079 Supplementary Excel Lecture Introduction to Macros.mp4	10.1 MB
080 Supplementary Excel Lecture Recording a Macro.mp4	15.9 MB
081 Supplementary Excel Lecture Assign a Macro to a Button or Shape.mp4	12.5 MB
082 Supplementary Excel Lecture Run a Macro Upon Opening a Workbook.mp4	8.5 MB
083 Supplementary Excel Lecture How to Inspect and Modify a Macro.mp4	12.3 MB
/08 Putting It All Together/
084 Quick Re-cap.mp4	4.3 MB
085 Example Dashboard Tour.mp4	12.7 MB
086 Pyramid Chart.mp4	33.5 MB
087 Array Formula Alternative to SUMIFS.mp4	34.8 MB
088 LARGE and SMALL Array and DAVERAGE.mp4	23.9 MB
089 Rank Values with PivotTable.mp4	15.6 MB
090 Scatter Chart.mp4	35.0 MB
091 DMAX, DMIN, DAVERAGE.mp4	23.3 MB
092 Formatting Quickly.mp4	28.8 MB
/09 Distributing Your Dashboard/
093 Checking and Publishing.mp4	4.6 MB
094 Excel Web App - Introduction.mp4	11.9 MB
095 Preparing Your File for Excel Web App.mp4	22.5 MB
096 Publish with Excel Web App.mp4	36.1 MB
097 Password Protection.mp4	62.5 MB
098 Supplementary Excel Lecture Workbook Passwords.mp4	6.6 MB
099 Supplementary Excel Lecture Protecting Workbooks.mp4	4.8 MB
100 Supplementary Excel Lecture Unlocking Cells.mp4	7.5 MB
/10 Bonus Tour de France Dashboard/
101 Dashboard Overview.mp4	69.4 MB
102 SUMIFS Formula.mp4	28.0 MB
103 INDEX, MATCH and OFFSET Formula.mp4	24.8 MB
104 INDEX, MATCH Multiple Array Formula.mp4	14.0 MB
105 Zoom Images VBA Code.mp4	59.7 MB
/11 Homework/
106 Myndas Homework Dashboard Part 1.mp4	50.6 MB
107 Myndas Homework Dashboard Part 2.mp4	111.9 MB
Total files 107