Other
Udemy Excel with Interactive Excel Dashboards
Torrent info
Torrent Files List
01 Introduction (Size: 2.34 GB) (Files: 107)
01 Introduction
001 Course Overview and Introduction to Excel Dashboards.mp4
02 Getting Your Data Ready
002 Ideal Data Formats.mp4
03 Design Principles
003 Getting Your Design Right.mp4
04 Display Principles
004 Charts and Tricks for Trending.mp4
005 Secondary Axis.mp4
006 Smoothing Data.mp4
007 Sparklines.mp4
008 Formatting Tricks.mp4
009 Highlighting Comparisons.mp4
010 Top and Bottom Ranking.mp4
011 Frequency Distribution.mp4
012 Target vs Variance Charts.mp4
013 Performance Against Target Range.mp4
014 Bullet Graphs.mp4
015 WinLossDraw Conditional Format.mp4
016 Dynamic Data Range.mp4
017 Dynamic Labels.mp4
018 Text Formulas.mp4
019 Symbols in Formulas and Charts.mp4
020 Charts Referencing Non-contiguous Ranges.mp4
021 Embedding Graphics in Charts.mp4
022 Dynamic, Dynamic Data Validation Lists.mp4
023 In Cell Charts.mp4
024 Panel Charts.mp4
025 Step Charts.mp4
026 Supplementary Excel Lecture Excel 2013 Chart Formatting.mp4
027 Supplementary Excel Lecture Excel 2013 Chart Labels.mp4
028 Supplementary Excel Lecture Excel 2013 Combo Charts.mp4
05 Interactive Controls
029 Form Controls Introduction.mp4
030 Check Boxes.mp4
031 List Boxes.mp4
032 Option Buttons.mp4
033 Group Boxes.mp4
034 Scroll Bar.mp4
035 Buttons.mp4
036 Combo Box with Macro.mp4
037 Dynamic Date Filters 4 Ways.mp4
038 Dynamic Named Range with OFFSET.mp4
039 Dynamic Named Range with INDEX.mp4
040 Dynamic Ranges for Charts.mp4
041 Animating Charts.mp4
042 INDIRECT Function Tricks.mp4
043 Rollover Technique.mp4
044 Scroll and Sort Table.mp4
045 Supplementary Excel Lecture Inserting Drop Down Lists.mp4
06 Analysing the Data
046 PivotCharts.mp4
047 Slicers.mp4
048 Capture Slicer Selection in Formula.mp4
049 GETPIVOTDATA Function.mp4
050 Slicer PivotChart Olympic Dashboard Overview.mp4
051 Supplementary Excel Lecture Creating PivotTables.mp4
052 Supplementary Excel Lecture Choosing Fields.mp4
053 Supplementary Excel Lecture PivotTable Layout.mp4
054 Supplementary Excel Lecture Filtering PivotTables.mp4
055 Supplementary Excel Lecture Modifying PivotTable Data.mp4
056 Supplementary Excel Lecture Insert a Table and Style Options.mp4
057 Supplementary Excel Lecture Add Rows and Columns to a Table.mp4
058 Supplementary Excel Lecture Perform a Function in a Table.mp4
059 Supplementary Excel Lecture Summarize a Table with a PivotTable.mp4
060 Supplementary Excel Lecture VLOOKUP Formula Sorted List.mp4
061 Supplementary Excel Lecture VLOOKUP Formula Exact Match.mp4
062 Supplementary Excel Lecture HLOOKUP Formula Sorted List.mp4
063 Supplementary Excel Lecture HLOOKUP Formula Exact Match.mp4
064 Supplementary Excel Lecture CHOOSE Function.mp4
065 Supplementary Excel Lecture INDEX and MATCH Formula.mp4
066 Supplementary Excel Lecture IF Function.mp4
067 Supplementary Excel Lecture Nested IF Formula.mp4
068 Supplementary Excel Lecture IF AND Formula.mp4
069 Supplementary Excel Lecture IF OR Formula.mp4
070 Supplementary Excel Lecture IF NOT Formula.mp4
071 Supplementary Excel Lecture IFERROR Function.mp4
072 Supplementary Excel Lecture SUMIF and SUMIFS Formulas.mp4
073 Supplementary Excel Lecture AVERAGEIF and AVERAGEIFS Formulas.mp4
074 Supplementary Excel Lecture COUNTIF and COUNTIFS Formulas.mp4
075 Supplementary Excel Lecture SUMPRODUCT Formula.mp4
07 Automating Your Dashboard
076 Linking to Access.mp4
077 Incorporating New Data Automatically.mp4
078 Auto Refresh PivotTables.mp4
079 Supplementary Excel Lecture Introduction to Macros.mp4
080 Supplementary Excel Lecture Recording a Macro.mp4
081 Supplementary Excel Lecture Assign a Macro to a Button or Shape.mp4
082 Supplementary Excel Lecture Run a Macro Upon Opening a Workbook.mp4
083 Supplementary Excel Lecture How to Inspect and Modify a Macro.mp4
08 Putting It All Together
084 Quick Re-cap.mp4
085 Example Dashboard Tour.mp4
086 Pyramid Chart.mp4
087 Array Formula Alternative to SUMIFS.mp4
088 LARGE and SMALL Array and DAVERAGE.mp4
089 Rank Values with PivotTable.mp4
090 Scatter Chart.mp4
091 DMAX, DMIN, DAVERAGE.mp4
092 Formatting Quickly.mp4
09 Distributing Your Dashboard
093 Checking and Publishing.mp4
094 Excel Web App - Introduction.mp4
095 Preparing Your File for Excel Web App.mp4
096 Publish with Excel Web App.mp4
097 Password Protection.mp4
098 Supplementary Excel Lecture Workbook Passwords.mp4
099 Supplementary Excel Lecture Protecting Workbooks.mp4
100 Supplementary Excel Lecture Unlocking Cells.mp4
10 Bonus Tour de France Dashboard
101 Dashboard Overview.mp4
102 SUMIFS Formula.mp4
103 INDEX, MATCH and OFFSET Formula.mp4
104 INDEX, MATCH Multiple Array Formula.mp4
105 Zoom Images VBA Code.mp4
11 Homework
106 Myndas Homework Dashboard Part 1.mp4
107 Myndas Homework Dashboard Part 2.mp4
Torrent description
Feel free to post any comments about this torrent, including links to Subtitle, samples, screenshots, or any other relevant information, Watch Udemy Excel with Interactive Excel Dashboards Online Free Full Movies Like 123Movies, Putlockers, Fmovies, Netflix or Download Direct via Magnet Link in Torrent Details.
