FreeCourseLab com Udemy Visually Effective Excel Dashboards | D2AB6A88611F2B9DF674E5D8CDBA907FE3590620

FreeCourseLab com Udemy Visually Effective Excel Dashboards

Name	[FreeCourseLab.com] Udemy - Visually Effective Excel Dashboards	DOWNLOAD Copy Link
Total Size	2.4 GB
Total Files	225
Hash	D2AB6A88611F2B9DF674E5D8CDBA907FE3590620

/1. A Foundation in Dashboards/
1. Introduction.mp4	25.9 MB
1. Introduction.vtt	6.6 KB
2. Get the Most from the Course.mp4	12.5 MB
2. Get the Most from the Course.vtt	4.0 KB
3. Download Course Files Here.html	4.2 KB
3.1 KPISampleData_Access.zip.zip	34.5 KB
3.2 Demo-WorkBook-Dashboard.xlsx.xlsx	389.1 KB
3.3 Slicer_Regional_Dashboard.xlsm.xlsm	142.2 KB
3.4 Practice_Demo_WorkBook_Dashboard_Empty.xlsx.xlsx	103.7 KB
3.5 KPI-Dashboard.xlsx.xlsx	106.1 KB
3.6 Source_Data_Examples_Workbook.xlsx.xlsx	22.9 KB
3.7 Tabular_data_set_csv.csv.csv	9.2 KB
4. A Dashboard Primer.mp4	10.4 MB
4. A Dashboard Primer.vtt	2.9 KB
5. New project This is Your Checklist.mp4	18.6 MB
5. New project This is Your Checklist.vtt	5.8 KB
5.1 Dashboard Starting Checklist.pdf.pdf	41.2 KB
5.2 Excel Online Compatibility.html	0.1 KB
/10. KPI Dashboard - Dynamic Headers/
1. Conditional Comments in Header.mp4	11.7 MB
1. Conditional Comments in Header.vtt	3.3 KB
2. Adding Shapes & Text boxes.mp4	22.6 MB
2. Adding Shapes & Text boxes.vtt	7.6 KB
3. Download Dashboard till here & practice along - Draft03.html	0.6 KB
3.1 KPI_Dashboard_Draft03.xlsx.xlsx	76.1 KB
/11. KPI Dashboard - TopBottom KPI Based on Selection/
1. Show Top 6 Matches with Unique Identifier.mp4	53.3 MB
1. Show Top 6 Matches with Unique Identifier.vtt	16.0 KB
2. List Box to Select KPI for Top 6 Matches.mp4	38.0 MB
2. List Box to Select KPI for Top 6 Matches.vtt	9.8 KB
3. Option Button to Toggle Between Top OR Bottom 6.mp4	24.3 MB
3. Option Button to Toggle Between Top OR Bottom 6.vtt	6.8 KB
4. Actual to Budget Comparison - Sorted Bars with Error Bar Technique.mp4	32.6 MB
4. Actual to Budget Comparison - Sorted Bars with Error Bar Technique.vtt	10.8 KB
5. Finalize Top Bottom Report on Dashboard.mp4	33.4 MB
5. Finalize Top Bottom Report on Dashboard.vtt	9.9 KB
6. Download Dashboard till here & practice along - Draft04.html	0.7 KB
6.1 KPI_Dashboard_Draft04.xlsx.xlsx	92.8 KB
/12. KPI Dashboard - Scrolling Line Chart with Check Boxes/
1. Complex Lookup to Prepare data for Scrolling Chart.mp4	40.4 MB
1. Complex Lookup to Prepare data for Scrolling Chart.vtt	9.3 KB
2. Scroll-able Line Chart.mp4	19.7 MB
2. Scroll-able Line Chart.vtt	5.1 KB
3. Trick to Avoid Crashing Lines in Line Chart.mp4	18.7 MB
3. Trick to Avoid Crashing Lines in Line Chart.vtt	6.4 KB
4. Check Box to Control Series Visibility (Hide or Show).mp4	14.6 MB
4. Check Box to Control Series Visibility (Hide or Show).vtt	3.8 KB
5. Line Series Tweaks for Better Readability.mp4	30.4 MB
5. Line Series Tweaks for Better Readability.vtt	10.5 KB
6. Finalize Profit Comparison Section on Dashboard.mp4	10.1 MB
6. Finalize Profit Comparison Section on Dashboard.vtt	2.8 KB
7. Download Dashboard till here & practice along - Draft05.html	0.7 KB
7.1 KPI_Dashboard_Draft05.xlsx.xlsx	101.8 KB
/13. KPI Dashboard - Final Touches/
1. Restrict Dashboard Area and Format for Printing.mp4	15.2 MB
1. Restrict Dashboard Area and Format for Printing.vtt	4.7 KB
2. Dashboard Protection, Hyperlinks and Final Touches.mp4	29.1 MB
2. Dashboard Protection, Hyperlinks and Final Touches.vtt	8.9 KB
3. Download Dashboard till here - Final.html	0.5 KB
3.1 KPI_Dashboard.xlsx.xlsx	105.8 KB
/14. Regional (Pivot Slicer) Dashboard - Using Slicer as Buttons/
1. More Interactivity - Pivot Slicers as Buttons (also without Pivot Tables).mp4	24.6 MB
1. More Interactivity - Pivot Slicers as Buttons (also without Pivot Tables).vtt	11.7 KB
1.1 Slicer_Regional_Dashboard_Draft01.xlsx.xlsx	449.9 KB
2. Column Chart Controlled by Slicer Buttons.mp4	14.2 MB
2. Column Chart Controlled by Slicer Buttons.vtt	7.2 KB
3. Slicer Custom Sorting & Design.mp4	10.1 MB
3. Slicer Custom Sorting & Design.vtt	5.3 KB
4. Check to Ensure Single Slicer Button is Selected.mp4	4.4 MB
4. Check to Ensure Single Slicer Button is Selected.vtt	2.5 KB
5. Dynamic Comments with Slicer Selection.mp4	23.6 MB
5. Dynamic Comments with Slicer Selection.vtt	12.8 KB
6. Download Regional Dashboard till here - Draft02.html	0.6 KB
6.1 Slicer_Regional_Dashboard_Draft02.xlsx.xlsx	461.5 KB
/15. Regional Dashboard - Advanced Pivot Table Techniques/
1. Variances in Pivot Table.mp4	18.1 MB
1. Variances in Pivot Table.vtt	9.1 KB
2. Conditional Formatting in Pivot Table.mp4	10.1 MB
2. Conditional Formatting in Pivot Table.vtt	5.2 KB
3. Pivot Table as Part of Dashboard Report.mp4	6.5 MB
3. Pivot Table as Part of Dashboard Report.vtt	3.3 KB
4. Pivot Charts in Dashboards.mp4	9.5 MB
4. Pivot Charts in Dashboards.vtt	4.5 KB
5. Automatically Refresh Pivot Table with Simple VBA code.mp4	13.5 MB
5. Automatically Refresh Pivot Table with Simple VBA code.vtt	6.2 KB
6. Download Regional Dashboard till here - Draft03.html	0.7 KB
6.1 Slicer_Regional_Dashboard_Draft03.xlsm.xlsm	338.0 KB
/16. Regional Dashboard - Impressive Charts Using Shapes/
1. Info Charts Adding Shapes to (Pivot) Charts.mp4	10.0 MB
1. Info Charts Adding Shapes to (Pivot) Charts.vtt	5.4 KB
2. Info Charts Overcoming Pivot Chart Limitations.mp4	19.2 MB
2. Info Charts Overcoming Pivot Chart Limitations.vtt	9.5 KB
3. Download Regional Dashboard till here - Draft04.html	0.6 KB
3.1 Slicer_Regional_Dashboard_Draft04.xlsm.xlsm	339.9 KB
/17. Regional Dashboard - Secrets for Impressive Reports/
1. Camera for Improved Design.mp4	18.4 MB
1. Camera for Improved Design.vtt	8.3 KB
2. Advanced Camera - Lookups on Pictures.mp4	16.1 MB
2. Advanced Camera - Lookups on Pictures.vtt	7.7 KB
3. Dashboard Complete - Final Touches.mp4	18.7 MB
3. Dashboard Complete - Final Touches.vtt	8.0 KB
4. Download the final version of the SlicerRegional Dashboard.html	0.5 KB
4.1 Slicer_Regional_Dashboard.xlsm.xlsm	142.2 KB
/18. What you Learnt/
1. Final Words.mp4	4.3 MB
1. Final Words.vtt	1.5 KB
2. Do you want to Learn More.html	4.9 KB
/2. Dashboards - Before You Start/
1. First Steps for your Dashboard Project.mp4	14.6 MB
1. First Steps for your Dashboard Project.vtt	4.4 KB
1.1 Dashboard First Steps.pdf.pdf	131.4 KB
2. Create a Mockup (Wireframe) in Excel.html	2.5 KB
2.1 Excel-Dashboard-Report-Vector-Elements.xlsx.xlsx	22.1 KB
3. Useful Excel Keyboard Shortcuts.mp4	27.6 MB
3. Useful Excel Keyboard Shortcuts.vtt	13.1 KB
4. 4 Time-Saving Tips for Excel.mp4	24.0 MB
4. 4 Time-Saving Tips for Excel.vtt	9.3 KB
5. Proper Spreadsheet Architecture & Workflow.mp4	12.6 MB
5. Proper Spreadsheet Architecture & Workflow.vtt	3.3 KB
/3. Report Design Principles/
1. Layout - Best Practice.mp4	13.0 MB
1. Layout - Best Practice.vtt	4.1 KB
1.1 Dashboard Design Layout.pdf.pdf	841.7 KB
2. Color - Best Practice.mp4	11.2 MB
2. Color - Best Practice.vtt	3.8 KB
2.1 Dashboard Design Color.pdf.pdf	715.5 KB
3. A Color Scheme that fits with your Report.mp4	8.5 MB
3. A Color Scheme that fits with your Report.vtt	4.7 KB
3.1 Dashboard-Color-Palettes.xlsx.xlsx	46.8 KB
4. 10 Concrete Design Tips for Better Excel Reports.mp4	15.2 MB
4. 10 Concrete Design Tips for Better Excel Reports.vtt	6.8 KB
5. Bonus Setting a Default Theme for New Workbooks.mp4	26.3 MB
5. Bonus Setting a Default Theme for New Workbooks.vtt	6.0 KB
6. Excel Report Design - Test Your Knowledge.html	0.1 KB
/4. Dashboard Source Data & Formats/
1. Where is Your Source Data.mp4	6.0 MB
1. Where is Your Source Data.vtt	2.2 KB
2. Source Excel Spreadsheet.mp4	19.0 MB
2. Source Excel Spreadsheet.vtt	7.2 KB
3. Source Microsoft Access.mp4	9.8 MB
3. Source Microsoft Access.vtt	5.1 KB
4. Source Text Data CSV File.mp4	14.9 MB
4. Source Text Data CSV File.vtt	7.7 KB
5. Source Excel Add-ins.mp4	6.7 MB
5. Source Excel Add-ins.vtt	2.6 KB
/5. Dashboard Formula Toolbox/
1. Excel Formulas You'll Need.mp4	10.2 MB
1. Excel Formulas You'll Need.vtt	1.6 KB
10. CHOOSE for Flexibility.mp4	18.0 MB
10. CHOOSE for Flexibility.vtt	9.9 KB
11. Text Function for Formatting.mp4	29.7 MB
11. Text Function for Formatting.vtt	15.5 KB
12. N Function for Tracking.mp4	6.7 MB
12. N Function for Tracking.vtt	3.8 KB
13. GetPivotData Extract data Efficiently from Pivot Tables.mp4	24.7 MB
13. GetPivotData Extract data Efficiently from Pivot Tables.vtt	11.8 KB
14. INDIRECT for Flexible References.mp4	22.0 MB
14. INDIRECT for Flexible References.vtt	11.5 KB
15. Choose & Name Manager for Flexible Ranges (Alternative to Indirect).mp4	11.9 MB
15. Choose & Name Manager for Flexible Ranges (Alternative to Indirect).vtt	5.7 KB
2. Index Match for Complex Lookups - Basics.mp4	33.9 MB
2. Index Match for Complex Lookups - Basics.vtt	12.4 KB
3. Index Match for Complex Lookups - Advanced.mp4	31.7 MB
3. Index Match for Complex Lookups - Advanced.vtt	10.8 KB
4. Index for Dynamic List Selection.mp4	25.6 MB
4. Index for Dynamic List Selection.vtt	8.7 KB
5. Realistic Case Index for Dependent Drop-down Lists.mp4	134.6 MB
5. Realistic Case Index for Dependent Drop-down Lists.vtt	7.6 KB
6. SUMIFS, COUNTIFS, AVERAGEIFS to Handle Multiple Criteria.mp4	26.1 MB
6. SUMIFS, COUNTIFS, AVERAGEIFS to Handle Multiple Criteria.vtt	11.4 KB
7. LARGE and SMALL for Sorting.mp4	5.0 MB
7. LARGE and SMALL for Sorting.vtt	3.1 KB
8. ROW(S), COLUMN(S) for Indexing.mp4	12.8 MB
8. ROW(S), COLUMN(S) for Indexing.vtt	7.1 KB
9. ROW as Unique Identifier for Lookups.mp4	14.4 MB
9. ROW as Unique Identifier for Lookups.vtt	7.3 KB
/6. Form Controls for Interactive Dashboards/
1. Introduction to Form Controls - Active X vs. Form Controls.mp4	7.7 MB
1. Introduction to Form Controls - Active X vs. Form Controls.vtt	1.3 KB
2. Combo Box - Select From a Drop Down List.mp4	13.2 MB
2. Combo Box - Select From a Drop Down List.vtt	5.6 KB
3. Check Box - Check Uncheck Option.mp4	14.3 MB
3. Check Box - Check Uncheck Option.vtt	5.4 KB
4. Spin Button - Move Up & Down Lists.mp4	6.1 MB
4. Spin Button - Move Up & Down Lists.vtt	2.5 KB
5. Option Button - Choose One Option Only.mp4	11.2 MB
5. Option Button - Choose One Option Only.vtt	4.9 KB
6. List Box - Select From a List of Option.mp4	9.3 MB
6. List Box - Select From a List of Option.vtt	3.3 KB
7. Scroll Bar - Scroll Through Graphs & Tables.mp4	18.0 MB
7. Scroll Bar - Scroll Through Graphs & Tables.vtt	6.4 KB
8. Bonus Dependent Combo Boxes (2nd list automatically resets).mp4	112.2 MB
8. Bonus Dependent Combo Boxes (2nd list automatically resets).vtt	15.0 KB
/7. Advanced Chart Techniques/
1. Chart Overview & When to Use Which Graph.mp4	7.5 MB
1. Chart Overview & When to Use Which Graph.vtt	2.7 KB
1.1 ChartPlaybook.pdf.pdf	515.4 KB
1.2 Sorted Bar Chart as Alternative to the Pie Chart.html	0.1 KB
2. Chart Basics (for those who need to get familiar with basic features).html	0.5 KB
3. Improve Charts 1 Add Total Values to Stacked Column Charts.mp4	16.9 MB
3. Improve Charts 1 Add Total Values to Stacked Column Charts.vtt	5.2 KB
4. Improve Charts 2 Add Series Labels Inside Chart.mp4	27.3 MB
4. Improve Charts 2 Add Series Labels Inside Chart.vtt	8.9 KB
5. Improve Charts 3 Error Bars for Additional Control.mp4	25.6 MB
5. Improve Charts 3 Error Bars for Additional Control.vtt	12.4 KB
5.1 Error bar example 1 Excel Better Variance Charts - Effective Variance Charts with Error Bars.html	0.1 KB
5.2 Error bar example 2 Excel Arrow Variance Chart.html	0.1 KB
6. Pro Technique Changing Chart Ranges.mp4	185.6 MB
6. Pro Technique Changing Chart Ranges.vtt	11.9 KB
7. Info-graphics in Excel Non-standard but Impressive Bar Chart.mp4	119.3 MB
7. Info-graphics in Excel Non-standard but Impressive Bar Chart.vtt	17.9 KB
8. Dynamic Map Chart with Drop-down.mp4	203.3 MB
8. Dynamic Map Chart with Drop-down.vtt	18.1 KB
/8. KPI Dashboard - Setup/
1. KPI Dashboard Overview.mp4	19.7 MB
1. KPI Dashboard Overview.vtt	7.5 KB
2. Dashboard Wireframe.mp4	7.1 MB
2. Dashboard Wireframe.vtt	3.1 KB
3. Spreadsheet Setup.mp4	25.7 MB
3. Spreadsheet Setup.vtt	10.6 KB
4. Setup of Raw Data Sheet.mp4	36.1 MB
4. Setup of Raw Data Sheet.vtt	10.5 KB
5. Setup of Calculation sheet.mp4	18.3 MB
5. Setup of Calculation sheet.vtt	6.7 KB
6. Download Dashboard till here & practice along - Draft01.html	0.5 KB
6.1 KPI_Dashboard_Draft01.xlsx.xlsx	55.7 KB
/9. KPI Dashboard - Scrolling Table & Bars/
1. Setup a Combo Box to Ease Selection.mp4	38.2 MB
1. Setup a Combo Box to Ease Selection.vtt	12.1 KB
2. Complex Lookup with Index & Match.mp4	48.4 MB
2. Complex Lookup with Index & Match.vtt	14.4 KB
3. Scrolling Data Table.mp4	36.9 MB
3. Scrolling Data Table.vtt	12.5 KB
4. Conditionally-Formatted Data Bars.mp4	38.7 MB
4. Conditionally-Formatted Data Bars.vtt	12.0 KB
5. Arrows for Deviations.mp4	27.8 MB
5. Arrows for Deviations.vtt	9.6 KB
6. Formatting of Scrolling Data Table.mp4	18.8 MB
6. Formatting of Scrolling Data Table.vtt	6.2 KB
7. Download Dashboard till here & practice along - Draft02.html	0.5 KB
7.1 KPI_Dashboard_Draft02.xlsx.xlsx	73.7 KB
/
[FreeCourseLab.com].url	0.1 KB
Total files 225