Udemy - The complete Excel crash course for data analysis

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

No comments yet.