17 OCT 2024 - Welcome Back to TorrentFunk! Get your pirate hat back out. Streaming is dying and torrents are the new trend. Account Registration works again and so do Torrent Uploads. We invite you all to start uploading torrents again!
TORRENT DETAILS
Udemy - The Complete Excel Crash Course For Data Analysis
TORRENT SUMMARY
Status:
All the torrents in this section have been verified by our verification system
A no-nonsense primer on everything you need to become a star Analyst, taught by an ex-BCG consultant and ex-Amazon PM
What you'll learn
Navigate quickly around Excel (without using a mouse)
Clean data in preparation for data analysis
Use dynamic formulas to conduct detailed data analysis
Use beautiful and best-in-class formatting
Structure your workbook to be clear and auditable
Requirements
You should have a basic understanding of Excel or more to fully benefit from this course
If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com
Get More Tutorials and Support Us -->> https://FreeCourseWeb.com
We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...
VISITOR COMMENTS (0 )
FILE LIST
Filename
Size
~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
