Udemy - The complete Excel crash course for data analysis

Files:

• Get Bonus Downloads Here.url (0.2 KB)
~Get Your Files Here ! 1. Introduction
• 1. How to use this course.mp4 (28.4 MB)
• 1.1 Excel_v1.xlsx (174.6 KB)
2. How to navigate quickly in Excel
• 1. Shortcuts to quickly navigate a workbook.mp4 (37.7 MB)
• 2. Insert or delete rows, columns, and sheets.mp4 (75.0 MB)
• 3. Move and copy sheets.mp4 (33.1 MB)
• 4. Split screen and freeze pane.mp4 (65.8 MB)
• 5. Open new window of the same Excel file.mp4 (29.3 MB)
• 6. Enter and exit cell using F2.mp4 (10.7 MB)
3. How to clean data in preparation for analysis
• 1. Insert filters, multiple sort.mp4 (82.0 MB)
• 2. Create tables.mp4 (43.1 MB)
• 3. Find and replace data.mp4 (28.1 MB)
• 4. IFERROR for calculations.mp4 (30.5 MB)
• 5. IFS for creating buckets in a new column.mp4 (58.0 MB)
• 6. LEFT RIGHT LEN SEARCH for manipulating text.mp4 (48.7 MB)
• 7. LEFT RIGHT LEN SEARCH for manipulating text (advanced).mp4 (26.4 MB)
• 8. Cleaning dates.mp4 (16.0 MB)
• 9. Using Excel's Smart Autofill feature.mp4 (27.6 MB)
4. How to analyze data
• 1. AVERAGE, MAX, MIN, MEDIAN.mp4 (15.6 MB)
• 2. PERCENTILES.mp4 (23.2 MB)
• 3. COUNT, COUNTA, COUNTIFS.mp4 (71.9 MB)
• 4. SUMIFS, AVERAGEIFS.mp4 (25.0 MB)
• 5. SUMPRODUCT.mp4 (18.9 MB)
• 6. Pivot tables.mp4 (80.2 MB)
• 7. Pivot tables vs. advanced COUNTIFS.mp4 (65.3 MB)
• 8. Index match.mp4 (114.0 MB)
5. How to format your output
• 1. Format numbers quickly, set decimal points.mp4 (33.5 MB)
• 10. Set row width and column height, Use autofit.mp4 (42.0 MB)
• 11. Show and hide gridlines.mp4 (12.2 MB)
• 12. Color the tabs in your workbook.mp4 (7.9 MB)
• 2. Using detailed formatting options in Ctr + 1.mp4 (15.7 MB)
• 3. Conditional formatting.mp4 (33.5 MB)
• 4. Align text, font color.mp4 (20.3 MB)
• 5. Adding cell borders.mp4 (24.4 MB)
• 6. Cell highlights.mp4 (7.1 MB)
• 7. Use Paste Special to copy formats from another cell.mp4 (33.3 MB)
• 8. Clear formatting from cells.mp4 (23.0 MB)
• 9. Insert and delete comments from cells.mp4 (25.6 MB)
6. Best practices for structuring your workbook
• 1. How to structure your workbook tabs.mp4 (35.5 MB)
• 2. How to structure your Analysis sheet.mp4 (19.1 MB)
• 3. Use dynamic formulas.mp4 (27.3 MB)
• 4. Color code your analysis output numbers.mp4 (68.5 MB)
• Bonus Resources.txt (0.4 KB)