Udemy Excel with Interactive Excel Dashboards
File List
| File | Size |
|---|---|
| 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 |
Trackers
No trackers found.