TorBT - Torrents and Magnet Links Search Engine

[ DevCourseWeb.com ] Udemy - The complete Excel crash course for data analysis

File Name
Size
Get Bonus Downloads Here.url
182 B
~Get Your Files Here !/1. Introduction/1. How to use this course.mp4
28 MB
~Get Your Files Here !/1. Introduction/1.1 Excel_v1.xlsx
175 kB
~Get Your Files Here !/2. How to navigate quickly in Excel/1. Shortcuts to quickly navigate a workbook.mp4
38 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 MB
~Get Your Files Here !/2. How to navigate quickly in Excel/4. Split screen and freeze pane.mp4
66 MB
~Get Your Files Here !/2. How to navigate quickly in Excel/5. Open new window of the same Excel file.mp4
29 MB
~Get Your Files Here !/2. How to navigate quickly in Excel/6. Enter and exit cell using F2.mp4
11 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 MB
~Get Your Files Here !/3. How to clean data in preparation for analysis/3. Find and replace data.mp4
28 MB
~Get Your Files Here !/3. How to clean data in preparation for analysis/4. IFERROR for calculations.mp4
30 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
49 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 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
28 MB
~Get Your Files Here !/4. How to analyze data/1. AVERAGE, MAX, MIN, MEDIAN.mp4
16 MB
~Get Your Files Here !/4. How to analyze data/2. PERCENTILES.mp4
23 MB
~Get Your Files Here !/4. How to analyze data/3. COUNT, COUNTA, COUNTIFS.mp4
72 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
19 MB
~Get Your Files Here !/4. How to analyze data/6. Pivot tables.mp4
80 MB
~Get Your Files Here !/4. How to analyze data/7. Pivot tables vs. advanced COUNTIFS.mp4
65 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
34 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 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
16 MB
~Get Your Files Here !/5. How to format your output/3. Conditional formatting.mp4
34 MB
~Get Your Files Here !/5. How to format your output/4. Align text, font color.mp4
20 MB
~Get Your Files Here !/5. How to format your output/5. Adding cell borders.mp4
24 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 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
26 MB
~Get Your Files Here !/6. Best practices for structuring your workbook/1. How to structure your workbook tabs.mp4
36 MB
~Get Your Files Here !/6. Best practices for structuring your workbook/2. How to structure your Analysis sheet.mp4
19 MB
~Get Your Files Here !/6. Best practices for structuring your workbook/3. Use dynamic formulas.mp4
27 MB
~Get Your Files Here !/6. Best practices for structuring your workbook/4. Color code your analysis output numbers.mp4
68 MB
~Get Your Files Here !/Bonus Resources.txt
386 B