Udemy - Learn Excel by Building Real-World Business Projects

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1 - Introduction
• 1. Course-Outline.pdf (12.6 MB)
• 1. CourseIntroduction.pdf (28.8 KB)
• 1. Introduction (Description).html (0.6 KB)
• 1. Introduction.en_US.srt (3.7 KB)
• 1. Introduction.mp4 (50.6 MB)
• 1. P1-budget-data.csv (22.0 KB)
• 1. P2-hr-messy-data.csv (20.4 KB)
• 1. P3-retail-sales.csv (403.0 KB)
• 1. P4-monthly-sales-vba.csv (4.1 KB)
• 1. P5-kpi-data.csv (1.4 KB)
• 1. P6-startup-forecast.xlsx (7.6 KB)
• 1. P7-ecommerce-raw.csv (99.2 KB)
10 - Project 7 End-to-End BI in Excel (Power Query Pivots PDF)
• 10. End to End Business Intelligence (Description).html (0.8 KB)
• 10. End to End Business Intelligence.en_US.srt (16.4 KB)
• 10. End to End Business Intelligence.mp4 (299.1 MB)
• 10. Solution-Project7.xlsx (139.2 KB)
• 10. ecommerce-raw.csv (99.2 KB)
2 - Project 1
• 2. Getting Started with Excel for Business (Description).html (0.9 KB)
• 2. Getting Started with Excel for Business.en_US.srt (17.9 KB)
• 2. Getting Started with Excel for Business.mp4 (279.5 MB)
• 2. NOTES-Going-to-Last-Row-in-Excel.pdf (12.6 MB)
• 2. NOTES-Negative-Value-In-Formula-Explaination.pdf (12.6 MB)
• 2. NOTES-What-is-the-SUMIF-formula-doing.pdf (6.3 MB)
• 2. Solution-Project1.xlsx (42.6 KB)
• 2. budget-data.csv (22.0 KB)
3 - Project 2
• 3. HR Employee Data Cleaner (Power Query + Data Quality) (Description).html (0.9 KB)
• 3. HR Employee Data Cleaner (Power Query + Data Quality).en_US.srt (13.8 KB)
• 3. HR Employee Data Cleaner (Power Query + Data Quality).mp4 (279.8 MB)
• 3. NOTES-ReplaceTheseValues.pdf (29.4 KB)
• 3. NOTES-Transform-Format-Clean.pdf (12.6 MB)
• 3. Solution-Project2.xlsx (34.5 KB)
• 3. hr-messy-data.csv (20.4 KB)
4 - Project 3
• 4. NOTES-Sorting-and-ValueFilterNotes.pdf (12.6 MB)
• 4. Retail Store Sales Analysis (PivotTables, Slicers, Top-N) (Description).html (0.9 KB)
• 4. Retail Store Sales Analysis (PivotTables, Slicers, Top-N).en_US.srt (9.8 KB)
• 4. Retail Store Sales Analysis (PivotTables, Slicers, Top-N).mp4 (206.7 MB)
• 4. Solution-Project3.xlsx (522.4 KB)
• 4. retail-sales.csv (403.0 KB)
5 - Project 4 Introduction - No Visual Basic (VBA) coding experience necessary
• 5. No coding is necessary (Description).html (0.7 KB)
• 5. No coding is necessary.en_US.srt (0.9 KB)
• 5. No coding is necessary.mp4 (17.8 MB)
6 - Project 4
• 6. Automated Monthly Sales Dashboard w VBA (Description).html (0.8 KB)
• 6. Automated Monthly Sales Dashboard w VBA.en_US.srt (12.9 KB)
• 6. Automated Monthly Sales Dashboard w VBA.mp4 (205.6 MB)
• 6. NOTES-Email-Using-Outlook.pdf (58.5 KB)
• 6. NOTES-Emails-with-Gmail-Yahoo.pdf (30.0 KB)
• 6. NOTES-VBA-Code-Explaination.pdf (88.7 KB)
• 6. NOTES-VBAWhereTheFileWriteHappens.pdf (12.6 MB)
• 6. NOTES-VBCode.pdf (17.6 KB)
• 6. Solution-Project4.xlsm (46.9 KB)
• 6. monthly-sales-vba.csv (4.1 KB)
7 - Project 5
• 7. Executive KPI Dashboard (KPIs, Conditional Formatting, Slicers) (Description).html (0.9 KB)
• 7. Executive KPI Dashboard (KPIs, Conditional Formatting, Slicers).en_US.srt (28.2 KB)
• 7. Executive KPI Dashboard (KPIs, Conditional Formatting, Slicers).mp4 (384.3 MB)
• 7. NOTES-AlternativeTo-XLOOKUP.pdf (6.3 MB)
• 7. NOTES-BusinessTerms.pdf (6.3 MB)
• 7. NOTES-BusinessTermsDefinitions.pdf (12.6 MB)
• 7. NOTES-ChurnNegativeValues.pdf (12.6 MB)
• 7. NOTES-FunctionNotes.pdf (12.7 MB)
• 7. NOTES-UpDownArrows.pdf (12.6 MB)
• 7. Solution-Project5.xlsx (36.2 KB)
• 7. kpi-data.csv (1.4 KB)
8 - Project 6 Introduction
• 8. Project 6 is optional (Description).html (0.8 KB)
• 8. Project 6 is optional.en_US.srt (0.5 KB)
• 8. Project 6 is optional.mp4 (9.8 MB)
9 - Project 6 (Optional)
• 9. Solution-Project6.xlsx (201.1 KB)
• 9. Startup Financial Forecast (What-If, Goal Seek, Data Tables) (Description).html (0.9 KB)
• 9. Startup Financial Forecast (What-If, Goal Seek, Data Tables).en_US.srt (23.2 KB)
• 9. Startup Financial Forecast (What-If, Goal Seek, Data Tables).mp4 (425.7 MB)
• 9. startup-forecast.xlsx (7.6 KB)
• Bonus Resources.txt (0.1 KB)