Microsoft Excel Dashboards Data Visualization Mastery | 2D4703582291902F042A422818C750CDCA25CD74

Microsoft Excel Dashboards Data Visualization Mastery

Name	Microsoft Excel Dashboards & Data Visualization Mastery	DOWNLOAD Copy Link
Total Size	3.1 GB
Total Files	191
Last Seen	2024-07-22 23:56
Hash	2D4703582291902F042A422818C750CDCA25CD74

/.../8. 8 - Formula-driven Development/
2. 8.2 The Information-Transformation-Presentation Dynamic.mp4	243.8 MB
1. 8.1 Introduction to Formula-driven Development.mp4	16.4 MB
1. 8.1 Introduction to Formula-driven Development.srt	8.2 KB
2. 8.2 The Information-Transformation-Presentation Dynamic.srt	46.9 KB
3. Section 8 Quiz.html	0.1 KB
/
TutsNode.com.txt	0.1 KB
[TGx]Downloaded from torrentgalaxy.to .txt	0.6 KB
/1. 1 - Introduction/
1. 1.1 Introduction.mp4	1.9 MB
1. 1.1 Introduction.srt	1.4 KB
2. 1.2 Why Even Use Excel.mp4	34.3 MB
2. 1.2 Why Even Use Excel.srt	11.7 KB
3. 1.3 Why Dashboards + Datavis.mp4	21.4 MB
3. 1.3 Why Dashboards + Datavis.srt	8.1 KB
4. 1.4 Interactive Dashboards in Excel.mp4	85.5 MB
4. 1.4 Interactive Dashboards in Excel.srt	17.6 KB
5. Section 1 Quiz.html	0.1 KB
/.../2. 2 - Thinking outside the cell/
1. 2.1 Thinking outside the cell.mp4	23.6 MB
1. 2.1 Thinking outside the cell.srt	10.9 KB
2. 2.2 Why develop differently.mp4	17.8 MB
2. 2.2 Why develop differently.srt	5.9 KB
3. 2.3 Inserting the camera tool.mp4	28.2 MB
3. 2.3 Inserting the camera tool.srt	4.8 KB
4. 2.4 How to use the camera tool.mp4	82.8 MB
4. 2.4 How to use the camera tool.srt	12.9 KB
5. 2.5 Development Principles.mp4	48.4 MB
5. 2.5 Development Principles.srt	22.0 KB
6. Section 2 Quiz.html	0.1 KB
/.../3. 3 - Working with Formulas/
1. 3.1 Formula Editing Tips.mp4	140.5 MB
1. 3.1 Formula Editing Tips.srt	19.5 KB
1.1 Mod3-PracticeData.xlsx	14.7 KB
2. 3.2 Excel Calculation Engine.mp4	39.3 MB
2. 3.2 Excel Calculation Engine.srt	14.7 KB
3. 3.3 Writing Better Formulas.mp4	49.5 MB
3. 3.3 Writing Better Formulas.srt	17.3 KB
4. Section 3 Quiz.html	0.1 KB
/.../4. 4 - Advanced Formulas for Dashboards & Decisions/
1. 4.1 Lookup Functions.mp4	10.9 MB
1. 4.1 Lookup Functions.srt	4.1 KB
2. 4.2 How to use VLOOKUP.mp4	23.1 MB
2. 4.2 How to use VLOOKUP.srt	4.9 KB
2.1 Mod-4-2-VLOOKUP-INDEX-MATCH-DEMO.xlsx	20.3 KB
3. 4.3 How to use INDEXMATCH.mp4	41.0 MB
3. 4.3 How to use INDEXMATCH.srt	9.8 KB
4. 4.4 Combining formulas.mp4	26.7 MB
4. 4.4 Combining formulas.srt	6.1 KB
5. 4.5 How to use Array Formulas.mp4	12.1 MB
5. 4.5 How to use Array Formulas.srt	4.2 KB
6. 4.6 Array Formulas Demo.mp4	164.7 MB
6. 4.6 Array Formulas Demo.srt	33.3 KB
6.1 Mod-4-6-Array-Formula-Demo.xlsx	20.4 KB
7. Homework Array Formulas.html	0.1 KB
7.1 Module-4-Lab-Notes - revised 11-15-2020.pdf	252.8 KB
7.2 Mod-4-6-Array-Formula-Lab.xlsx	19.1 KB
8. 4.7 Section Review.mp4	9.0 MB
8. 4.7 Section Review.srt	3.5 KB
9. Section 4 Quiz.html	0.1 KB
/.../5. 5 - Excel Tables are the Best!/
1. 5.1 Introduction to Excel Tables.mp4	22.2 MB
1. 5.1 Introduction to Excel Tables.srt	5.6 KB
2. 5.2 Inserting a New Excel Table.mp4	114.1 MB
2. 5.2 Inserting a New Excel Table.srt	14.3 KB
2.1 Mod5-2InsertExcelTable.xlsx	18.5 KB
3. 5.3 Working with Tables.mp4	101.3 MB
3. 5.3 Working with Tables.srt	12.6 KB
3.1 Mod5-3WorkingwithExcelTables.xlsx	23.0 KB
4. 5.4 Excel Tables Demo.mp4	41.2 MB
4. 5.4 Excel Tables Demo.srt	7.7 KB
4.1 Module5-4ExcelTableChartExample.xlsx	9.5 KB
5. 5.5 Rules for using Excel Tables.mp4	9.2 MB
5. 5.5 Rules for using Excel Tables.srt	4.3 KB
6. Homework Excel Tables.html	0.0 KB
6.1 Module-5-Lab-Notes - revised 11-15-2020.pdf	259.1 KB
6.2 Module5-4ExcelTableChartExample.xlsx	9.5 KB
7. Section 5 Quiz.html	0.1 KB
/.../6. 6 - Sorting and Decision Functions/
1. 6.1 Introduction to Sorting Functions.mp4	161.7 MB
1. 6.1 Introduction to Sorting Functions.srt	27.7 KB
1.1 Module-6-1-Lab-Notes - revised 11-15-2020.pdf	249.5 KB
1.2 Module6-1TableSorting.xlsx	20.1 KB
2. 6.2 Creating Filters with SUMPRODUCT.mp4	6.9 MB
2. 6.2 Creating Filters with SUMPRODUCT.srt	2.4 KB
2.1 Module6-2FilteringonExcelTables.xlsx	20.5 KB
3. 6.3 Filtering on Excel Tables.mp4	175.8 MB
3. 6.3 Filtering on Excel Tables.srt	27.7 KB
4. 6.4 Data Aggregation.mp4	96.9 MB
4. 6.4 Data Aggregation.srt	19.5 KB
5. 6.5 Section Summary.mp4	8.1 MB
5. 6.5 Section Summary.srt	3.9 KB
6. Homework Table Sorting.html	0.1 KB
6.1 Module6-1TableSorting.xlsx	20.1 KB
6.2 Module-6-1-Lab-Notes+-+revised+11-15-2020.pdf	249.5 KB
7. Section 6 Quiz.html	0.1 KB
/.../7. 7 - Form Controls for Interactivity/
1. 7.1 The DEVELOPER Tab.mp4	10.3 MB
1. 7.1 The DEVELOPER Tab.srt	2.5 KB
2. 7.2 Excel Form Controls.mp4	19.4 MB
2. 7.2 Excel Form Controls.srt	7.0 KB
3. 7.3 Form Controls Demo.mp4	117.3 MB
3. 7.3 Form Controls Demo.srt	25.2 KB
3.1 Module7-3FormControls.xlsx	11.6 KB
4. 7.4 Form Control Basics.mp4	7.3 MB
4. 7.4 Form Control Basics.srt	3.7 KB
4.1 Module7-4FormControlsDEMO.xlsx	25.7 KB
5. 7.5 Creating a Scrollable Table.mp4	61.7 MB
5. 7.5 Creating a Scrollable Table.srt	12.8 KB
5.1 Module7-5ScrollableTableDemo.xlsx	19.6 KB
6. Homework Creating a Scrollable Table.html	0.1 KB
6.1 Module-7-1-Lab-Notes+-+revised+11-15-2020 (1).pdf	192.9 KB
6.2 Module7-5ScrollableTableDemo (1).xlsx	19.6 KB
7. Section 7 Quiz.html	0.1 KB
/.../9. 9 - Creating an Interactive Legend Dashboard/
1. 9.1 Section Introduction.mp4	6.2 MB
1. 9.1 Section Introduction.srt	2.9 KB
2. 9.2 Creating an Interactive Legend.mp4	65.6 MB
2. 9.2 Creating an Interactive Legend.srt	11.7 KB
2.1 Mod-9-Interactive-Legend.xlsx	29.9 KB
3. 9.3 Perfecting the Interactive Legend.mp4	148.4 MB
3. 9.3 Perfecting the Interactive Legend.srt	26.5 KB
4. 9.4 Maintaining the Interactive Legend.mp4	24.3 MB
4. 9.4 Maintaining the Interactive Legend.srt	5.5 KB
5. Homework Creating an Interactive Legend.html	0.1 KB
5.1 Mod-9-Interactive-Legend.xlsx	29.9 KB
5.2 Module-9-1-Lab-Notes+-+revised+11-15-2020.pdf	250.7 KB
/.../10. 10 - Creating an Interactive Chart Dashboard/
1. 10.1 Section Introduction.mp4	2.0 MB
1. 10.1 Section Introduction.srt	1.0 KB
2. 10.2 Setting up an Interactive Chart.mp4	53.2 MB
2. 10.2 Setting up an Interactive Chart.srt	10.7 KB
2.1 Module10-CheckboxExample.xlsx	24.4 KB
3. 10.3 Formatting the Interactive Chart.mp4	46.7 MB
3. 10.3 Formatting the Interactive Chart.srt	8.1 KB
4. 10.4 Maintaining the Interactive Chart.mp4	27.4 MB
4. 10.4 Maintaining the Interactive Chart.srt	4.8 KB
5. Assignment Creating an Interactive Chart.html	0.1 KB
5.1 Module10-1LabCreatinganInteractiveChart.pdf	634.7 KB
5.2 Module10-CheckboxExample.xlsx	24.4 KB
/.../11. 11 - Interactive Tornado Dashboard with Drill Downs/
1. 11.1 Section Introduction.mp4	4.0 MB
1. 11.1 Section Introduction.srt	1.2 KB
2. 11.2 Setting up the Interactive Dashboard.mp4	125.2 MB
2. 11.2 Setting up the Interactive Dashboard.srt	24.2 KB
2.1 Module-11-Tornado-Example.xlsx	31.2 KB
3. 11.3 Formatting the Interactive Dashboard.mp4	16.1 MB
3. 11.3 Formatting the Interactive Dashboard.srt	3.0 KB
4. 11.4 Maintaining the Interactive Dashboard.mp4	27.2 MB
4. 11.4 Maintaining the Interactive Dashboard.srt	4.3 KB
5. Assignment In Cell Spark Lines.html	0.1 KB
5.1 Module11SparklinesLab2.xlsx	10.8 KB
5.2 Module11-1LabCreatingSparkLines - revised 11-15-2020.pdf	105.7 KB
6. Assignment Tornado Dashboard.html	0.1 KB
6.1 Module11-1LabTornadoScatterPlot revised 11-15-2020.pdf	412.1 KB
6.2 Module11TornadoLab1.xlsx	29.1 KB
/.../12. 12 - Data Visualization/
1. 12.1 Introduction to Visual Perception.mp4	25.8 MB
1. 12.1 Introduction to Visual Perception.srt	13.3 KB
2. 12.2 The Gestalt Laws of Grouping.mp4	14.7 MB
2. 12.2 The Gestalt Laws of Grouping.srt	7.3 KB
3. 12.3 Preattentive Attributes.mp4	8.1 MB
3. 12.3 Preattentive Attributes.srt	4.3 KB
4. 12.4 The Problem with Pie Charts.mp4	4.4 MB
4. 12.4 The Problem with Pie Charts.srt	2.7 KB
5. 12.5 Introduction to Infographics.mp4	7.0 MB
5. 12.5 Introduction to Infographics.srt	3.4 KB
6. Section 12 Quiz.html	0.1 KB
/.../13. 13 - Special Charts/
1. 13.1 Expanding the Chart Library.mp4	1.7 MB
1. 13.1 Expanding the Chart Library.srt	0.8 KB
2. 13.2 Dual Axis Band Chart.mp4	43.6 MB
2. 13.2 Dual Axis Band Chart.srt	6.0 KB
2.1 Mod 13 - Special Charts.xlsx	36.4 KB
3. 13.3 Shaded Area Banded Chart.mp4	52.5 MB
3. 13.3 Shaded Area Banded Chart.srt	7.0 KB
4. 13.4 Limit and Control Charts.mp4	33.1 MB
4. 13.4 Limit and Control Charts.srt	5.7 KB
/.../14. 14 - Bullet Charts/
1. 14.1 Introduction to Bullet Charts in Excel.mp4	4.7 MB
1. 14.1 Introduction to Bullet Charts in Excel.srt	2.6 KB
2. 14.2 Bullet Chart Demo.mp4	67.2 MB
2. 14.2 Bullet Chart Demo.srt	12.5 KB
2.1 Bullet-Charts2.xlsx	34.6 KB
3. 14.3 Horizontal Bullet Chart Trick.mp4	36.2 MB
3. 14.3 Horizontal Bullet Chart Trick.srt	5.9 KB
4. Assignment Create a Bullet Chart.html	0.1 KB
4.1 Bullet-Charts2.xlsx	34.6 KB
4.2 Module14LabCreatingaBulletChart revised 11-15-2020.pdf	588.2 KB
/.../15. 15 - Infographics in Excel/
1. 15.1 Introduction to Infographics in Excel.mp4	3.6 MB
1. 15.1 Introduction to Infographics in Excel.srt	2.4 KB
2. 15.2 Progress Meter Chart.mp4	66.7 MB
2. 15.2 Progress Meter Chart.srt	15.1 KB
2.1 Module-15-Infographics.xlsx	93.9 KB
3. 15.3 Donut Chart.mp4	47.0 MB
3. 15.3 Donut Chart.srt	9.3 KB
4. 15.4 Waffle Chart.mp4	57.1 MB
4. 15.4 Waffle Chart.srt	10.2 KB
5. 15.5 Bringing it all together with the CAMERA.mp4	19.4 MB
5. 15.5 Bringing it all together with the CAMERA.srt	3.8 KB
6. Assignment Progress Meter.html	0.1 KB
6.1 Module-15-Infographics.xlsx	93.9 KB
6.2 Module15-2ProgressMeterLab revised 11-15-2020.pdf	188.2 KB
/.../16. 16 - Conclusion/
1. 16.1 Thanks for watching!.mp4	8.9 MB
1. 16.1 Thanks for watching!.srt	4.4 KB
Total files 191