| | | 001 Course Overview and Introduction to Excel Dashboards.mp4 | 19.73 MB |
| | | 002 Ideal Data Formats.mp4 | 13.09 MB |
| | | 003 Getting Your Design Right.mp4 | 5.22 MB |
| | | 004 Charts and Tricks for Trending.mp4 | 37.37 MB |
| | | 005 Secondary Axis.mp4 | 4.74 MB |
| | | 006 Smoothing Data.mp4 | 12.25 MB |
| | | 007 Sparklines.mp4 | 49.35 MB |
| | | 008 Formatting Tricks.mp4 | 9.92 MB |
| | | 009 Highlighting Comparisons.mp4 | 13.28 MB |
| | | 010 Top and Bottom Ranking.mp4 | 24.04 MB |
| | | 011 Frequency Distribution.mp4 | 17.15 MB |
| | | 012 Target vs Variance Charts.mp4 | 12.08 MB |
| | | 013 Performance Against Target Range.mp4 | 11.07 MB |
| | | 029 Form Controls Introduction.mp4 | 8.15 MB |
| | | 030 Check Boxes.mp4 | 10.21 MB |
| | | 031 List Boxes.mp4 | 68.22 MB |
| | | 032 Option Buttons.mp4 | 23.63 MB |
| | | 033 Group Boxes.mp4 | 6.8 MB |
| | | 034 Scroll Bar.mp4 | 9.87 MB |
| | | 035 Buttons.mp4 | 7.67 MB |
| | | 036 Combo Box with Macro.mp4 | 23.38 MB |
| | | 037 Dynamic Date Filters 4 Ways.mp4 | 96.51 MB |
| | | 038 Dynamic Named Range with OFFSET.mp4 | 20.37 MB |
| | | 046 PivotCharts.mp4 | 20.73 MB |
| | | 047 Slicers.mp4 | 23.88 MB |
| | | 048 Capture Slicer Selection in Formula.mp4 | 16.18 MB |
| | | 049 GETPIVOTDATA Function.mp4 | 55.41 MB |
| | | 050 Slicer PivotChart Olympic Dashboard Overview.mp4 | 47.19 MB |
| | | 051 Supplementary Excel Lecture Creating PivotTables.mp4 | 6.08 MB |
| | | 052 Supplementary Excel Lecture Choosing Fields.mp4 | 7.56 MB |
| | | 053 Supplementary Excel Lecture PivotTable Layout.mp4 | 7.71 MB |
| | | 054 Supplementary Excel Lecture Filtering PivotTables.mp4 | 3.45 MB |
| | | 055 Supplementary Excel Lecture Modifying PivotTable Data.mp4 | 2.94 MB |
| | | 076 Linking to Access.mp4 | 32.43 MB |
| | | 077 Incorporating New Data Automatically.mp4 | 37.54 MB |
| | | 078 Auto Refresh PivotTables.mp4 | 13.27 MB |
| | | 079 Supplementary Excel Lecture Introduction to Macros.mp4 | 9.6 MB |
| | | 080 Supplementary Excel Lecture Recording a Macro.mp4 | 15.15 MB |
| | | 081 Supplementary Excel Lecture Assign a Macro to a Button or Shape.mp4 | 11.94 MB |
| | | 082 Supplementary Excel Lecture Run a Macro Upon Opening a Workbook.mp4 | 8.06 MB |
| | | 083 Supplementary Excel Lecture How to Inspect and Modify a Macro.mp4 | 11.71 MB |
| | | 084 Quick Re-cap.mp4 | 4.12 MB |
| | | 085 Example Dashboard Tour.mp4 | 12.12 MB |
| | | 086 Pyramid Chart.mp4 | 31.98 MB |
| | | 087 Array Formula Alternative to SUMIFS.mp4 | 33.16 MB |
| | | 088 LARGE and SMALL Array and DAVERAGE.mp4 | 22.76 MB |
| | | 089 Rank Values with PivotTable.mp4 | 14.9 MB |
| | | 090 Scatter Chart.mp4 | 33.39 MB |
| | | 091 DMAX, DMIN, DAVERAGE.mp4 | 22.21 MB |
| | | 092 Formatting Quickly.mp4 | 27.44 MB |
| | | 093 Checking and Publishing.mp4 | 4.41 MB |
| | | 094 Excel Web App - Introduction.mp4 | 11.34 MB |
| | | 095 Preparing Your File for Excel Web App.mp4 | 21.43 MB |
| | | 096 Publish with Excel Web App.mp4 | 34.43 MB |
| | | 097 Password Protection.mp4 | 59.58 MB |
| | | 098 Supplementary Excel Lecture Workbook Passwords.mp4 | 6.32 MB |
| | | 099 Supplementary Excel Lecture Protecting Workbooks.mp4 | 4.58 MB |
| | | 100 Supplementary Excel Lecture Unlocking Cells.mp4 | 7.15 MB |
| | | 101 Dashboard Overview.mp4 | 66.22 MB |
| | | 102 SUMIFS Formula.mp4 | 26.74 MB |
| | | 103 INDEX, MATCH and OFFSET Formula.mp4 | 23.68 MB |
| | | 104 INDEX, MATCH Multiple Array Formula.mp4 | 13.34 MB |
| | | 105 Zoom Images VBA Code.mp4 | 56.98 MB |
| | | 106 Myndas Homework Dashboard Part 1.mp4 | 48.25 MB |
| | | 107 Myndas Homework Dashboard Part 2.mp4 | 106.67 MB |
All Comments