Udemy - Visually Effective Excel Dashboards (9.2025)
File List
| File | Size |
|---|---|
| 01. A Foundation in Dashboards/01. Introduction to Excel Dashboard Course.mp4 | 21.97 MB |
| 01. A Foundation in Dashboards/01. Introduction to Excel Dashboard Course.vtt | 6.71 KB |
| 01. A Foundation in Dashboards/02. Get the Most from the Course.mp4 | 10.36 MB |
| 01. A Foundation in Dashboards/02. Get the Most from the Course.vtt | 4.02 KB |
| 01. A Foundation in Dashboards/03. Download Course Files Here (Excel Dashboards & Practice Files).html | 2.5 KB |
| 01. A Foundation in Dashboards/04. Course Outline for Quick Reference.html | 535 B |
| 01. A Foundation in Dashboards/05. A Dashboard Primer.mp4 | 7.23 MB |
| 01. A Foundation in Dashboards/05. A Dashboard Primer.vtt | 3.17 KB |
| 01. A Foundation in Dashboards/06. New Excel Dashboard Project This is Your Checklist.mp4 | 12.92 MB |
| 01. A Foundation in Dashboards/06. New Excel Dashboard Project This is Your Checklist.vtt | 6.3 KB |
| 01. A Foundation in Dashboards/assets/03. Demo-WorkBook-Dashboard.xlsx | 379.98 KB |
| 01. A Foundation in Dashboards/assets/03. KPI-Dashboard.xlsx | 103.58 KB |
| 01. A Foundation in Dashboards/assets/03. KPISampleData-Access.zip | 33.67 KB |
| 01. A Foundation in Dashboards/assets/03. Practice-Demo-WorkBook-Dashboard-Empty.xlsx | 101.28 KB |
| 01. A Foundation in Dashboards/assets/03. Slicer-Regional-Dashboard.xlsm | 138.88 KB |
| 01. A Foundation in Dashboards/assets/03. Source-Data-Examples-Workbook.xlsx | 22.32 KB |
| 01. A Foundation in Dashboards/assets/03. Tabular-data-set-csv.csv | 8.94 KB |
| 01. A Foundation in Dashboards/assets/04. Detailed-Dashboard-Course-Outline.xlsx | 18.28 KB |
| 01. A Foundation in Dashboards/assets/06. Dashboard-Starting-Checklist.pdf | 40.27 KB |
| 01. A Foundation in Dashboards/external-links/06. Excel-Online-Compatibility.url | 47 B |
| 02. Dashboards - Before You Start/01. First Steps for your Excel Dashboard Project.mp4 | 17.99 MB |
| 02. Dashboards - Before You Start/01. First Steps for your Excel Dashboard Project.vtt | 4.78 KB |
| 02. Dashboards - Before You Start/02. Create a Mockup (Wireframe) in Excel.html | 1.76 KB |
| 02. Dashboards - Before You Start/03. Useful Excel Keyboard Shortcuts.mp4 | 108.21 MB |
| 02. Dashboards - Before You Start/03. Useful Excel Keyboard Shortcuts.vtt | 14.03 KB |
| 02. Dashboards - Before You Start/04. 4 Time-Saving Tips for Excel.mp4 | 79.31 MB |
| 02. Dashboards - Before You Start/04. 4 Time-Saving Tips for Excel.vtt | 9.96 KB |
| 02. Dashboards - Before You Start/05. Proper Spreadsheet Architecture & Workflow.mp4 | 45.55 MB |
| 02. Dashboards - Before You Start/05. Proper Spreadsheet Architecture & Workflow.vtt | 3.54 KB |
| 02. Dashboards - Before You Start/assets/01. Dashboard-First-Steps.pdf | 128.28 KB |
| 02. Dashboards - Before You Start/assets/02. Excel-Dashboard-Report-Vector-Elements.xlsx | 21.58 KB |
| 03. Report Design Principles/01. Layout - Best Practice for Excel Dashboard Design.mp4 | 41.71 MB |
| 03. Report Design Principles/01. Layout - Best Practice for Excel Dashboard Design.vtt | 4.4 KB |
| 03. Report Design Principles/02. Color - Best Practice for Excel Dashboard Design.mp4 | 14.3 MB |
| 03. Report Design Principles/02. Color - Best Practice for Excel Dashboard Design.vtt | 4.05 KB |
| 03. Report Design Principles/03. A Color Scheme that fits with your Excel Report.mp4 | 28.46 MB |
| 03. Report Design Principles/03. A Color Scheme that fits with your Excel Report.vtt | 5.06 KB |
| 03. Report Design Principles/04. 10 Concrete Design Tips for Better Excel Reports.mp4 | 48.41 MB |
| 03. Report Design Principles/04. 10 Concrete Design Tips for Better Excel Reports.vtt | 7.25 KB |
| 03. Report Design Principles/05. Bonus Setting a Default Theme for New Workbooks in Excel.mp4 | 41.81 MB |
| 03. Report Design Principles/05. Bonus Setting a Default Theme for New Workbooks in Excel.vtt | 6.46 KB |
| 03. Report Design Principles/006 Quiz Excel Report Design - Test Your Knowledge.html | 20.34 KB |
| 03. Report Design Principles/assets/01. Dashboard-Design-Layout.pdf | 821.94 KB |
| 03. Report Design Principles/assets/02. Dashboard-Design-Color.pdf | 698.71 KB |
| 03. Report Design Principles/assets/03. Dashboard-Color-Palettes.xlsx | 45.69 KB |
| 04. Dashboard Source Data & Formats/01. Where is Your Source Data.mp4 | 3.99 MB |
| 04. Dashboard Source Data & Formats/01. Where is Your Source Data.vtt | 2.43 KB |
| 04. Dashboard Source Data & Formats/02. Source Excel Spreadsheet.mp4 | 48.19 MB |
| 04. Dashboard Source Data & Formats/02. Source Excel Spreadsheet.vtt | 7.78 KB |
| 04. Dashboard Source Data & Formats/03. Source Microsoft Access.mp4 | 21.85 MB |
| 04. Dashboard Source Data & Formats/03. Source Microsoft Access.vtt | 5.55 KB |
| 04. Dashboard Source Data & Formats/04. Source Text Data CSV File.mp4 | 54.15 MB |
| 04. Dashboard Source Data & Formats/04. Source Text Data CSV File.vtt | 8.37 KB |
| 04. Dashboard Source Data & Formats/05. Source Excel Add-ins.mp4 | 18.98 MB |
| 04. Dashboard Source Data & Formats/05. Source Excel Add-ins.vtt | 2.88 KB |
| 05. Dashboard Formula Toolbox/01. Excel Formulas You_ll Need for Impressive Dashboards.mp4 | 36.32 MB |
| 05. Dashboard Formula Toolbox/01. Excel Formulas You_ll Need for Impressive Dashboards.vtt | 1.8 KB |
| 05. Dashboard Formula Toolbox/02. Index Match for Complex Lookups - Basics.mp4 | 95.2 MB |
| 05. Dashboard Formula Toolbox/02. Index Match for Complex Lookups - Basics.vtt | 13.43 KB |
| 05. Dashboard Formula Toolbox/03. Index Match for Complex Lookups - Advanced.mp4 | 87.78 MB |
| 05. Dashboard Formula Toolbox/03. Index Match for Complex Lookups - Advanced.vtt | 11.83 KB |
| 05. Dashboard Formula Toolbox/04. Index for Dynamic Drop-down List Selection.mp4 | 44.04 MB |
| 05. Dashboard Formula Toolbox/04. Index for Dynamic Drop-down List Selection.vtt | 9.41 KB |
| 05. Dashboard Formula Toolbox/05. Realistic Case Index for Dependent Drop-down Lists in Excel.mp4 | 62.94 MB |
| 05. Dashboard Formula Toolbox/05. Realistic Case Index for Dependent Drop-down Lists in Excel.vtt | 8.35 KB |
| 05. Dashboard Formula Toolbox/06. SUMIFS, COUNTIFS, AVERAGEIFS to Handle Multiple Criteria.mp4 | 55.41 MB |
| 05. Dashboard Formula Toolbox/06. SUMIFS, COUNTIFS, AVERAGEIFS to Handle Multiple Criteria.vtt | 12.34 KB |
| 05. Dashboard Formula Toolbox/07. LARGE and SMALL for Sorting Excel Data.mp4 | 10.16 MB |
| 05. Dashboard Formula Toolbox/07. LARGE and SMALL for Sorting Excel Data.vtt | 3.41 KB |
| 05. Dashboard Formula Toolbox/08. ROW(S), COLUMN(S) for Indexing.mp4 | 37.11 MB |
| 05. Dashboard Formula Toolbox/08. ROW(S), COLUMN(S) for Indexing.vtt | 7.7 KB |
| 05. Dashboard Formula Toolbox/09. ROW as Unique Identifier for Lookups.mp4 | 44.35 MB |
| 05. Dashboard Formula Toolbox/09. ROW as Unique Identifier for Lookups.vtt | 8 KB |
| 05. Dashboard Formula Toolbox/10. CHOOSE for Flexibility.mp4 | 55.65 MB |
| 05. Dashboard Formula Toolbox/10. CHOOSE for Flexibility.vtt | 10.79 KB |
| 05. Dashboard Formula Toolbox/11. Excel Text Function for Formatting.mp4 | 69.36 MB |
| 05. Dashboard Formula Toolbox/11. Excel Text Function for Formatting.vtt | 16.68 KB |
| 05. Dashboard Formula Toolbox/12. Excel N Function for Tracking.mp4 | 16.09 MB |
| 05. Dashboard Formula Toolbox/12. Excel N Function for Tracking.vtt | 4.23 KB |
| 05. Dashboard Formula Toolbox/13. GetPivotData Extract data Efficiently from Pivot Tables.mp4 | 79.65 MB |
| 05. Dashboard Formula Toolbox/13. GetPivotData Extract data Efficiently from Pivot Tables.vtt | 12.78 KB |
| 05. Dashboard Formula Toolbox/14. INDIRECT for Flexible References in Excel.mp4 | 69.11 MB |
| 05. Dashboard Formula Toolbox/14. INDIRECT for Flexible References in Excel.vtt | 12.43 KB |
| 05. Dashboard Formula Toolbox/15. Choose & Excel Name Manager for Flexible Ranges (Alternative to Indirect).mp4 | 40.76 MB |
| 05. Dashboard Formula Toolbox/15. Choose & Excel Name Manager for Flexible Ranges (Alternative to Indirect).vtt | 6.29 KB |
| 06. Form Controls for Interactive Excel Dashboards/01. Introduction to Form Controls - Active X vs. Form Controls.mp4 | 16.93 MB |
| 06. Form Controls for Interactive Excel Dashboards/01. Introduction to Form Controls - Active X vs. Form Controls.vtt | 1.36 KB |
| 06. Form Controls for Interactive Excel Dashboards/02. Combo Box - Select From a Drop Down List in Excel.mp4 | 19.21 MB |
| 06. Form Controls for Interactive Excel Dashboards/02. Combo Box - Select From a Drop Down List in Excel.vtt | 6.05 KB |
| 06. Form Controls for Interactive Excel Dashboards/03. Check Box - Check Uncheck Option in Excel.mp4 | 22.23 MB |
| 06. Form Controls for Interactive Excel Dashboards/03. Check Box - Check Uncheck Option in Excel.vtt | 5.92 KB |
| 06. Form Controls for Interactive Excel Dashboards/04. Spin Button - Move Up & Down Lists in Excel.mp4 | 8.69 MB |
| 06. Form Controls for Interactive Excel Dashboards/04. Spin Button - Move Up & Down Lists in Excel.vtt | 2.75 KB |
| 06. Form Controls for Interactive Excel Dashboards/05. Option Button - Choose One Option Only.mp4 | 19.65 MB |
| 06. Form Controls for Interactive Excel Dashboards/05. Option Button - Choose One Option Only.vtt | 5.38 KB |
| 06. Form Controls for Interactive Excel Dashboards/06. List Box - Select From a List of Options in Excel.mp4 | 15.14 MB |
| 06. Form Controls for Interactive Excel Dashboards/06. List Box - Select From a List of Options in Excel.vtt | 3.62 KB |
| 06. Form Controls for Interactive Excel Dashboards/07. Scroll Bar - Scroll Through Excel Graphs & Tables.mp4 | 24.33 MB |
| 06. Form Controls for Interactive Excel Dashboards/07. Scroll Bar - Scroll Through Excel Graphs & Tables.vtt | 7.04 KB |
| 06. Form Controls for Interactive Excel Dashboards/08. Bonus Dependent Combo Boxes (2nd list automatically resets).mp4 | 69.74 MB |
Trackers
No trackers found.