Data Analysis Essentials Using Excel | 277B9D9D32F5597C90656A29F1D60BC3F8D0D96E

Data Analysis Essentials Using Excel

Name	Data Analysis Essentials Using Excel	DOWNLOAD Copy Link
Total Size	2.4 GB
Total Files	421
Hash	277B9D9D32F5597C90656A29F1D60BC3F8D0D96E

/.../1. Watch This First/
1. WATCH THIS FIRST! How to use Udemy, download files, etc....mp4	189.1 MB
1. WATCH THIS FIRST! How to use Udemy, download files, etc....vtt	23.5 KB
2. Welcome!.mp4	12.9 MB
2. Welcome!.vtt	1.6 KB
3. Fuzzy video Check the default resolution in the video player.html	0.7 KB
Must Read.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
/
Visit Coursedrive.org.url	0.1 KB
Course Downloaded from coursedrive.org.txt	0.5 KB
/Data Analysis Essentials Using Excel/
ReadMe.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
/2. Jumpstart/
1. Jumpstart Overview.mp4	11.7 MB
1. Jumpstart Overview.vtt	5.6 KB
1.1 vgsales_raw.xlsx.xlsx	1.1 MB
2. JUMPSTART NOTE.html	1.3 KB
3. Jumpstart Part 1.mp4	22.7 MB
3. Jumpstart Part 1.vtt	9.5 KB
3.1 vgsales_part 1.xlsx.xlsx	1.2 MB
3.2 vgsales_part 1 COMPLETED.xlsx.xlsx	1.2 MB
4. Jumpstart Part 2.mp4	87.7 MB
4. Jumpstart Part 2.vtt	6.5 KB
4.1 vgsales_part 2.xlsx.xlsx	1.2 MB
4.2 vgsales_part 2 COMPLETED.xlsx.xlsx	1.2 MB
5. Jumpstart Part 3.mp4	19.5 MB
5. Jumpstart Part 3.vtt	7.2 KB
5.1 vgsales-part-3-COMPLETED_updated 2019.xlsx.xlsx	1.1 MB
5.2 vgsales-part-3_updated 2019.xlsx.xlsx	1.1 MB
6. Quick Reminder.html	0.9 KB
/.../3. Getting Acclimated with EXCEL - Foundations/
1. Getting Acclimated Section Overview.mp4	4.0 MB
1. Getting Acclimated Section Overview.vtt	0.6 KB
2. EXCEL User Interface.mp4	12.6 MB
2. EXCEL User Interface.vtt	5.0 KB
3. Adding, Deleting, and Editing Data in a Cell.mp4	5.5 MB
3. Adding, Deleting, and Editing Data in a Cell.vtt	2.8 KB
4. Introduction to Keyboard Shortcuts.mp4	3.6 MB
4. Introduction to Keyboard Shortcuts.vtt	2.0 KB
5. Navigation Keyboard Shortcuts.mp4	5.7 MB
5. Navigation Keyboard Shortcuts.vtt	3.0 KB
5.1 4-7 Reference File.xlsx.xlsx	24.9 KB
6. Data Selection Keyboard Shortcuts.mp4	4.9 MB
6. Data Selection Keyboard Shortcuts.vtt	2.8 KB
6.1 4-7 _Reference File.xlsx.xlsx	24.9 KB
7. Inserting and Deleting Rows and Columns.mp4	10.0 MB
7. Inserting and Deleting Rows and Columns.vtt	4.4 KB
7.1 4-7 _Reference File.xlsx.xlsx	24.9 KB
8. Auto Fit Row and Column Size.mp4	4.1 MB
8. Auto Fit Row and Column Size.vtt	1.5 KB
8.1 4-7 _Reference File.xlsx.xlsx	24.9 KB
9. Freeze Panes and Split Boxes.mp4	13.7 MB
9. Freeze Panes and Split Boxes.vtt	5.2 KB
9.1 4-7 _Reference File.xlsx.xlsx	24.9 KB
10. Formatting Numbers.mp4	17.3 MB
10. Formatting Numbers.vtt	8.1 KB
10.1 9-12 _Reference File.xlsx.xlsx	32.3 KB
11. Formatting Cells.mp4	9.2 MB
11. Formatting Cells.vtt	4.3 KB
11.1 9-12 _Reference File.xlsx.xlsx	32.3 KB
12. Grouping and Hiding Rows or Columns.mp4	5.5 MB
12. Grouping and Hiding Rows or Columns.vtt	2.2 KB
12.1 12_Reference File.xlsx.xlsx	37.9 KB
13. Installing EXCEL Add-Ins.mp4	1.8 MB
13. Installing EXCEL Add-Ins.vtt	0.8 KB
14. Quiz #1.html	0.1 KB
/.../4. Basic EXCEL Formulas & Functions - Foundations/
1. Basic Excel Formulas & Functions Section Overview.mp4	5.0 MB
1. Basic Excel Formulas & Functions Section Overview.vtt	0.7 KB
2. Basic Math Functions in Excel.mp4	12.7 MB
2. Basic Math Functions in Excel.vtt	4.6 KB
2.1 Basic Mathematical Operations - COMPLETED.xlsx.xlsx	37.4 KB
2.2 Basic Mathematical Operations.xlsx.xlsx	36.8 KB
3. Conditional Math Functions.mp4	16.9 MB
3. Conditional Math Functions.vtt	5.9 KB
3.1 Conditional Arithmetic - COMPLETED.xlsx.xlsx	35.2 KB
3.2 Conditional Arithmetic.xlsx.xlsx	32.0 KB
4. MIN, MAX, and AVERAGE Functions.mp4	16.7 MB
4. MIN, MAX, and AVERAGE Functions.vtt	5.0 KB
4.1 Min, Max, & Average Functions.xlsx.xlsx	34.8 KB
4.2 Min, Max, & Average Functions - COMPLETED.xlsx.xlsx	35.1 KB
5. Logical Operators and Functions.mp4	19.8 MB
5. Logical Operators and Functions.vtt	8.3 KB
5.1 Logical Operators IF, AND, & OR - COMPLETED.xlsx.xlsx	38.3 KB
5.2 Logical Operators IF, AND, & OR.xlsx.xlsx	38.1 KB
6. Anchoring Cell References and Name Ranges.mp4	20.3 MB
6. Anchoring Cell References and Name Ranges.vtt	9.2 KB
6.1 Anchoring and naming cells.xlsx.xlsx	25.0 KB
6.2 Anchoring and naming cells - COMPLETED.xlsx.xlsx	31.6 KB
7. Array Functions.mp4	15.8 MB
7. Array Functions.vtt	4.6 KB
7.1 Array Functions.xlsx.xlsx	38.9 KB
7.2 Array Functions - COMPLETED.xlsx.xlsx	39.1 KB
8. Quick note about next three lectures.html	0.5 KB
9. Internal Rate of Return (IRR) Functions.mp4	21.5 MB
9. Internal Rate of Return (IRR) Functions.vtt	9.2 KB
9.1 Internal Rate of Return.xlsx.xlsx	17.3 KB
9.2 Internal Rate of Return - COMPLETED.xlsx.xlsx	20.3 KB
10. Net Present Value (NPV) and Cash Multiple.mp4	28.4 MB
10. Net Present Value (NPV) and Cash Multiple.vtt	12.7 KB
10.1 Net Present Value - COMPLETED.xlsx.xlsx	50.3 KB
10.2 Net Present Value.xlsx.xlsx	46.3 KB
11. Loan Amortization Table.mp4	9.0 MB
11. Loan Amortization Table.vtt	3.5 KB
11.1 Loan Amortization - COMPLETED.xlsx.xlsx	39.7 KB
11.2 Loan Amortization.xlsx.xlsx	30.8 KB
12. Compound Annual Growth Rate (CAGR).mp4	6.5 MB
12. Compound Annual Growth Rate (CAGR).vtt	3.2 KB
12.1 Compound Annual Growth Rate.xlsx.xlsx	67.8 KB
12.2 Compound Annual Growth Rate - COMPLETED.xlsx.xlsx	63.3 KB
13. Formula Auditing.mp4	9.6 MB
13. Formula Auditing.vtt	5.5 KB
13.1 Formula Auditing.xlsx.xlsx	20.4 KB
13.2 Formula Auditing - COMPLETED.xlsx.xlsx	20.4 KB
14. Fill Commands.mp4	13.2 MB
14. Fill Commands.vtt	4.4 KB
14.1 Fill Commands - COMPLETED.xlsx.xlsx	45.6 KB
14.2 Fill Commands.xlsx.xlsx	45.2 KB
15. IS Functions.mp4	10.3 MB
15. IS Functions.vtt	3.4 KB
15.1 IS Functions.xlsx.xlsx	34.5 KB
15.2 IS Functions - COMPLETED.xlsx.xlsx	34.7 KB
16. Rounding Numbers.mp4	12.5 MB
16. Rounding Numbers.vtt	6.5 KB
16.1 Rounding Numbers - COMPLETED.xlsx.xlsx	29.1 KB
16.2 Rounding Numbers.xlsx.xlsx	26.4 KB
17. Quiz #2.html	0.1 KB
/.../5. Text, Times, and Dates Data Formats - Foundations/
1. Text, Times, and Date Data Formats Section Overview.mp4	3.9 MB
1. Text, Times, and Date Data Formats Section Overview.vtt	0.6 KB
2. How EXCEL Treats Text, Times, and Dates Data.mp4	9.1 MB
2. How EXCEL Treats Text, Times, and Dates Data.vtt	5.2 KB
2.1 How Excel deals with text, times, and dates - COMPLETED.xlsx.xlsx	17.8 KB
2.2 How Excel deals with text, times, and dates.xlsx.xlsx	17.9 KB
3. Changing the Case of Text.mp4	6.7 MB
3. Changing the Case of Text.vtt	2.8 KB
3.1 Changing the case.xlsx.xlsx	40.2 KB
3.2 Changing the case - COMPLETED.xlsx.xlsx	40.0 KB
4. Combining Strings of Text Together.mp4	5.1 MB
4. Combining Strings of Text Together.vtt	2.7 KB
4.1 Combine Text Strings.xlsx.xlsx	25.9 KB
4.2 Combine Text Strings - COMPLETED.xlsx.xlsx	40.5 KB
5. Cutting Substrings from a Text.mp4	13.3 MB
5. Cutting Substrings from a Text.vtt	5.4 KB
5.1 Cutting Substrings from Text - COMPLETED.xlsx.xlsx	46.4 KB
5.2 Cutting Substrings from Text.xlsx.xlsx	45.1 KB
6. Using the FIND Function.mp4	12.5 MB
6. Using the FIND Function.vtt	5.9 KB
6.1 Cutting Substrings from Text Part 2 FIND.xlsx.xlsx	41.2 KB
6.2 Cutting Substrings from Text Part 2 FIND - COMPLETED.xlsx.xlsx	42.1 KB
7. Searching for Specific Text in Data.mp4	14.0 MB
7. Searching for Specific Text in Data.vtt	6.4 KB
7.1 Searching Inside Tex Data.xlsx.xlsx	37.2 KB
7.2 Searching Inside Tex Data - COMPLETED.xlsx.xlsx	38.5 KB
8. Splitting a Text Field into Multiple Columns.mp4	12.6 MB
8. Splitting a Text Field into Multiple Columns.vtt	4.4 KB
8.1 Splitting Text Field into Multiple Columns.xlsx.xlsx	26.9 KB
8.2 Splitting Text Field into Multiple Columns - COMPLETED.xlsx.xlsx	27.0 KB
9. Converting Dates from Text into Values.mp4	8.2 MB
9. Converting Dates from Text into Values.vtt	3.3 KB
9.1 Converting Dates from Text into Values.xlsx.xlsx	34.4 KB
9.2 Converting Dates from Text into Values - COMPLETED.xlsx.xlsx	44.0 KB
10. Adding and Subtracting Dates.mp4	10.6 MB
10. Adding and Subtracting Dates.vtt	4.9 KB
10.1 Add and Subtract Dates - COMPLETED.xlsx.xlsx	43.9 KB
10.2 Add and Subtract Dates.xlsx.xlsx	42.1 KB
11. Compiling Monthly and Annual Totals.mp4	9.9 MB
11. Compiling Monthly and Annual Totals.vtt	4.6 KB
11.1 Compile Monthly & Annual Totals.xlsx.xlsx	55.5 KB
11.2 Compile Monthly & Annual Totals - COMPLETED.xlsx.xlsx	73.9 KB
12. Conducting Day of the Week Analysis.mp4	9.7 MB
12. Conducting Day of the Week Analysis.vtt	4.1 KB
12.1 Day of the Week Analysis.xlsx.xlsx	58.4 KB
12.2 Day of the Week Analysis - COMPLETED.xlsx.xlsx	95.1 KB
13. Combining Date and Time Data.mp4	9.9 MB
13. Combining Date and Time Data.vtt	3.8 KB
13.1 Combining Date and Time - COMPLETED.xlsx.xlsx	88.5 KB
13.2 Combining Date and Time.xlsx.xlsx	103.7 KB
14. Adding and Subtracting Times.mp4	13.1 MB
14. Adding and Subtracting Times.vtt	5.9 KB
14.1 Add and Subtract Times.xlsx.xlsx	145.7 KB
14.2 Add and Subtract Times - COMPLETED.xlsx.xlsx	204.9 KB
15. Conducting Hours of the Day Analysis.mp4	11.9 MB
15. Conducting Hours of the Day Analysis.vtt	5.4 KB
15.1 Analysis by Hours of the Day - COMPLETED.xlsx.xlsx	147.8 KB
15.2 Analysis by Hours of the Day.xlsx.xlsx	86.3 KB
/.../6. Introduction to Statistics in EXCEL - Foundations/
1. Introduction Statistics in EXCEL Section Overview.mp4	3.7 MB
1. Introduction Statistics in EXCEL Section Overview.vtt	0.5 KB
2. Brief Overview of Statistics.mp4	6.6 MB
2. Brief Overview of Statistics.vtt	4.0 KB
3. Mean, Median, & Mode.mp4	23.2 MB
3. Mean, Median, & Mode.vtt	8.5 KB
3.1 Mean Median and Mode - COMPLETED.xlsx.xlsx	32.8 KB
3.2 Mean Median and Mode.xlsx.xlsx	23.0 KB
4. Percentile and PercentileRank.mp4	18.1 MB
4. Percentile and PercentileRank.vtt	5.8 KB
4.1 Percentiles.xlsx.xlsx	45.6 KB
4.2 Percentiles - COMPLETED.xlsx.xlsx	46.0 KB
5. Frequency Distributions.mp4	19.2 MB
5. Frequency Distributions.vtt	6.2 KB
5.1 Frequency Distributions.xlsx.xlsx	45.4 KB
5.2 Frequency Distributions - COMPLETED.xlsx.xlsx	51.2 KB
6. Standard Deviation and Variance.mp4	14.4 MB
6. Standard Deviation and Variance.vtt	6.5 KB
6.1 Standard Deviation and Variance.xlsx.xlsx	53.8 KB
6.2 Standard Deviation and Variance - COMPLETED.xlsx.xlsx	63.0 KB
7. Trends in Data.mp4	18.8 MB
7. Trends in Data.vtt	7.7 KB
7.1 Finding Trends in Data.xlsx.xlsx	51.7 KB
7.2 Finding Trends in Data - COMPLETED.xlsx.xlsx	52.5 KB
8. Introduction to Correlation.mp4	16.3 MB
8. Introduction to Correlation.vtt	6.2 KB
8.1 Correlations - COMPLETED.xlsx.xlsx	65.2 KB
8.2 Correlations.xlsx.xlsx	64.7 KB
/.../7. Handling Data in EXCEL/
1. Handling Data Overview.mp4	4.9 MB
1. Handling Data Overview.vtt	0.7 KB
2. Lookup with VLOOKUP.mp4	13.2 MB
2. Lookup with VLOOKUP.vtt	4.7 KB
2.1 Lookup with VLOOKUP.xlsx.xlsx	31.8 KB
2.2 Lookup with VLOOKUP - COMPLETED.xlsx.xlsx	32.4 KB
3. Lookup with HLOOKUP.mp4	5.9 MB
3. Lookup with HLOOKUP.vtt	2.8 KB
3.1 Lookup with HLOOKUP - COMPLETED.xlsx.xlsx	34.5 KB
3.2 Lookup with HLOOKUP.xlsx.xlsx	34.3 KB
4. Name Arrays for Reuse and Readability.mp4	10.7 MB
4. Name Arrays for Reuse and Readability.vtt	3.2 KB
4.1 Naming Arrays - COMPLETED.xlsx.xlsx	34.5 KB
4.2 Naming Arrays.xlsx.xlsx	34.5 KB
5. Group Records with Nested IF Statements.mp4	12.6 MB
5. Group Records with Nested IF Statements.vtt	4.6 KB
5.1 Nested IF Statements.xlsx.xlsx	38.4 KB
5.2 Nested IF Statements - COMPLETED.xlsx.xlsx	50.5 KB
6. Avoid Errors with IF and ISNUMBER.mp4	17.6 MB
6. Avoid Errors with IF and ISNUMBER.vtt	6.4 KB
6.1 Avoid Errors with IF and ISNUMBER - COMPLETED.xlsx.xlsx	51.1 KB
6.2 Avoid Errors with IF and ISNUMBER.xlsx.xlsx	50.5 KB
7. Create Dropdown Lists for Filtering.mp4	27.9 MB
7. Create Dropdown Lists for Filtering.vtt	10.6 KB
7.1 Create Dropdowns for Filtering.xlsx.xlsx	53.2 KB
7.2 Create Dropdowns for Filtering - COMPLETED.xlsx.xlsx	53.6 KB
8. Create Unique Lists.mp4	13.2 MB
8. Create Unique Lists.vtt	5.4 KB
8.1 Create Unique Lists.xlsx.xlsx	54.3 KB
8.2 Create Unique Lists - COMPLETED.xlsx.xlsx	58.0 KB
9. Fast Lookup with INDEX and MATCH.mp4	27.9 MB
9. Fast Lookup with INDEX and MATCH.vtt	10.4 KB
9.1 Fast Lookup with INDEX and MATCH - COMPLETED.xlsx.xlsx	42.3 KB
9.2 Fast Lookup with INDEX and MATCH.xlsx.xlsx	41.9 KB
10. Multi-Condition Lookup with DSUM.mp4	15.0 MB
10. Multi-Condition Lookup with DSUM.vtt	6.0 KB
10.1 Multi-Condition Lookup with DSUM.xlsx.xlsx	58.2 KB
10.2 Multi-Condition Lookup with DSUM - COMPLETED.xlsx.xlsx	58.5 KB
11. Create Rankings with SMALL and LARGE.mp4	15.0 MB
11. Create Rankings with SMALL and LARGE.vtt	5.1 KB
11.1 Rankings with SMALL and LARGE - COMPLETE.xlsx.xlsx	59.0 KB
11.2 Rankings with SMALL and LARGE.xlsx.xlsx	58.4 KB
12. Multi-Condition Lookup with INDEX and MATCH.mp4	14.7 MB
12. Multi-Condition Lookup with INDEX and MATCH.vtt	5.9 KB
12.1 Multi-Condition Lookup with INDEX and MATCH - COMPLETED.xlsx.xlsx	60.2 KB
12.2 Multi-Condition Lookup with INDEX and MATCH.xlsx.xlsx	60.1 KB
ReadMe.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
/8. Pivot Tables/
1. Insert a Pivot Table.mp4	18.5 MB
1. Insert a Pivot Table.vtt	7.2 KB
1.1 Insert a Pivot Table - COMPLETED.xlsx.xlsx	6.0 MB
1.2 Insert a Pivot Table.xlsx.xlsx	4.6 MB
2. Prepare Data for Pivoting.mp4	28.2 MB
2. Prepare Data for Pivoting.vtt	9.2 KB
2.1 Prepare Data for Pivoting.xlsx.xlsx	4.6 MB
2.2 Prepare Data for Pivoting - COMPLETED.xlsx.xlsx	7.2 MB
3. Learn to Pivot a Table.mp4	26.2 MB
3. Learn to Pivot a Table.vtt	11.2 KB
3.1 Learn to Pivot a Table - COMPLETED.xlsx.xlsx	7.0 MB
3.2 Learn to Pivot a Table.xlsx.xlsx	7.0 MB
4. Group Rows and Columns.mp4	14.3 MB
4. Group Rows and Columns.vtt	6.2 KB
4.1 Group Rows and Columns - COMPLETED.xlsx.xlsx	6.9 MB
4.2 Group Rows and Columns.xlsx.xlsx	7.0 MB
5. Format for Readability.mp4	16.0 MB
5. Format for Readability.vtt	6.0 KB
5.1 Format for Readability.xlsx.xlsx	6.9 MB
5.2 Format for Readability - COMPLETED.xlsx.xlsx	6.9 MB
6. Modify Output Values for Insights.mp4	24.2 MB
6. Modify Output Values for Insights.vtt	8.7 KB
6.1 Modify Output Values for Insights - COMPLETED.xlsx.xlsx	6.9 MB
6.2 Modify Output Values for Insights.xlsx.xlsx	6.9 MB
7. Insert Calculated Fields.mp4	20.9 MB
7. Insert Calculated Fields.vtt	9.1 KB
7.1 Insert Calculated Fields - COMPLETED.xlsx.xlsx	6.9 MB
7.2 Insert Calculated Fields.xlsx.xlsx	6.9 MB
8. Sort, Filter and Slicer.mp4	25.4 MB
8. Sort, Filter and Slicer.vtt	9.5 KB
8.1 Sort, Filter and Slicer.xlsx.xlsx	7.0 MB
8.2 Sort, Filter and Slicer - COMPLETED.xlsx.xlsx	6.9 MB
9. Handle New Data in Pivot Tables.mp4	27.1 MB
9. Handle New Data in Pivot Tables.vtt	8.8 KB
9.1 Handle New Data in Pivot Tables.xlsx.xlsx	7.0 MB
9.2 Handle New Data in Pivot Tables - COMPLETED.xlsx.xlsx	9.1 MB
/.../9. Introduction to Charts in Excel/
1. Intoduction to Charts in Excel Overview.mp4	4.0 MB
1. Intoduction to Charts in Excel Overview.vtt	0.6 KB
2. Why Use Charts Anyway.mp4	20.2 MB
2. Why Use Charts Anyway.vtt	10.8 KB
3. Line Chart.mp4	11.2 MB
3. Line Chart.vtt	5.4 KB
3.1 LINE Chart.xlsx.xlsx	38.7 KB
4. Pie Charts.mp4	12.0 MB
4. Pie Charts.vtt	6.2 KB
4.1 PIE Chart.xlsx.xlsx	59.3 KB
5. Bar Chart.mp4	8.2 MB
5. Bar Chart.vtt	3.6 KB
5.1 BAR Chart.xlsx.xlsx	16.6 KB
6. Column Chart - Clustered.mp4	14.7 MB
6. Column Chart - Clustered.vtt	6.4 KB
6.1 CLUSTERED COLUMN Chart.xlsx.xlsx	40.2 KB
7. Column Chart - Stacked.mp4	11.8 MB
7. Column Chart - Stacked.vtt	5.4 KB
7.1 STACKED COLUMN - CHART.xlsx.xlsx	32.0 KB
8. Column Chart - 100% Stacked.mp4	12.0 MB
8. Column Chart - 100% Stacked.vtt	5.2 KB
8.1 100 STACKED COLUMN - CHART.xlsx.xlsx	31.9 KB
9. Combination Chart.mp4	5.6 MB
9. Combination Chart.vtt	2.4 KB
9.1 COMBO Chart.xlsx.xlsx	30.5 KB
10. Scatter Plot.mp4	8.1 MB
10. Scatter Plot.vtt	3.2 KB
10.1 SCATTER Chart.xlsx.xlsx	53.3 KB
11. Area Chart.mp4	9.1 MB
11. Area Chart.vtt	4.3 KB
11.1 AREA Chart.xlsx.xlsx	29.2 KB
12. Bubble Chart.mp4	13.1 MB
12. Bubble Chart.vtt	4.5 KB
12.1 BUBBLE Chart.xlsx.xlsx	33.7 KB
13. Gantt Chart.mp4	9.1 MB
13. Gantt Chart.vtt	4.7 KB
13.1 GANTT Chart.xlsx.xlsx	36.6 KB
14. Bullet Chart.mp4	19.7 MB
14. Bullet Chart.vtt	10.6 KB
14.1 BULLET Chart.xlsx.xlsx	29.5 KB
15. Waterfall Chart.mp4	33.0 MB
15. Waterfall Chart.vtt	16.7 KB
15.1 WATERFALL Chart.xlsx.xlsx	51.7 KB
/.../10. Case Study Crytocurrency Data/
1. Cryptocurrency Case Study Overview.mp4	7.2 MB
1. Cryptocurrency Case Study Overview.vtt	3.2 KB
2. Getting and Prepping the Data.mp4	48.1 MB
2. Getting and Prepping the Data.vtt	14.2 KB
2.1 BTC USD Historical Daily Prices.csv.csv	178.4 KB
2.2 LTC USD Historical Daily Prices.csv.csv	61.2 KB
2.3 ETH USD Historical Daily Prices.csv.csv	32.7 KB
2.4 SP500 USD Historical Daily Prices.csv.csv	138.5 KB
3. Bitcoin vs S&P500.mp4	32.9 MB
3. Bitcoin vs S&P500.vtt	14.0 KB
3.1 Crypto Currency Combined Historical Daily Prices.xls.xls	1.6 MB
4. Ethereum, Litecoin, & Bitcoin.mp4	25.7 MB
4. Ethereum, Litecoin, & Bitcoin.vtt	9.8 KB
4.1 Crypto Currency Combined Historical Daily Prices.xls.xls	1.6 MB
5. Introduction to Moving Averages.mp4	43.1 MB
5. Introduction to Moving Averages.vtt	13.2 KB
5.1 SP500 Chart.xlsx.xlsx	236.3 KB
5.2 BTC Moving Averages.xlsx.xlsx	110.7 KB
/.../11. Case Study Survey Data/
1. Survey Data Overview.mp4	11.0 MB
1. Survey Data Overview.vtt	3.5 KB
1.1 LearnAirbnb.com-Airbnb-Home-Sharing-Report-v1.4.pdf.pdf	5.3 MB
2. Preparing the Data.mp4	28.0 MB
2. Preparing the Data.vtt	6.9 KB
2.1 Survey Data Part 1 - BEFORE.xlsx.xlsx	601.4 KB
2.2 Survey Data Part 1 - AFTER.xlsx.xlsx	465.9 KB
3. Demographics - Who Are the Survey Respondents.mp4	27.0 MB
3. Demographics - Who Are the Survey Respondents.vtt	9.3 KB
3.1 Survey Data Demographics - AFTER.xlsx.xlsx	95.9 KB
3.2 Survey Data Demographics - BEFORE.xlsx.xlsx	90.0 KB
4. Pivoting the Data Part 1.mp4	37.1 MB
4. Pivoting the Data Part 1.vtt	11.5 KB
4.1 Survey Data Pivot - BEFORE.xlsx.xlsx	465.9 KB
4.2 Survey Data Pivot - AFTER.xlsx.xlsx	290.4 KB
5. Pivoting the Data Part 2.mp4	17.0 MB
5. Pivoting the Data Part 2.vtt	7.0 KB
5.1 Survey Data Pivot - AFTER.xlsx.xlsx	290.4 KB
/.../12. Case Study The Startup Market/
1. So, You Want to Do a Startup.mp4	6.6 MB
1. So, You Want to Do a Startup.vtt	4.1 KB
2. A Note On Data Preparation.mp4	21.0 MB
2. A Note On Data Preparation.vtt	5.0 KB
3. Scan the Data.mp4	7.6 MB
3. Scan the Data.vtt	2.4 KB
4. Dig into the Categories.mp4	35.8 MB
4. Dig into the Categories.vtt	10.0 KB
5. Exercise 1.mp4	4.4 MB
5. Exercise 1.vtt	1.3 KB
5.1 Exercise 1.xlsx.xlsx	3.2 MB
5.2 Exercise 1 - COMPLETED.xlsx.xlsx	6.5 MB
6. Pivot and Chart Part 1.mp4	20.5 MB
6. Pivot and Chart Part 1.vtt	8.8 KB
6.1 Pivot and Chart Part 1.xlsx.xlsx	6.4 MB
6.2 Pivot and Chart Part 1 - COMPLETED.xlsx.xlsx	8.6 MB
7. Pivot and Chart Part 2.mp4	23.1 MB
7. Pivot and Chart Part 2.vtt	9.9 KB
7.1 Pivot and Chart Part 2.xlsx.xlsx	8.6 MB
7.2 Pivot and Chart 2 - COMPLETED.xlsx.xlsx	8.6 MB
8. Analysis Leads to Finding.mp4	12.7 MB
8. Analysis Leads to Finding.vtt	6.1 KB
/.../13. Case Study Data Preparation (for Startup Market Data)/
1. Startup Funding CSV File Import.mp4	49.8 MB
1. Startup Funding CSV File Import.vtt	18.0 KB
1.1 startup funding 2016.xlsx.xlsx	1.1 MB
1.2 startup funding 2016 - COMPLETED.xlsx.xlsx	1.6 MB
2. Import and Fix Startup Info Data - Part 1.mp4	44.5 MB
2. Import and Fix Startup Info Data - Part 1.vtt	15.0 KB
2.1 Import and Fix Startup Info Data - Part 1.xlsx.xlsx	3.0 MB
2.2 Import and Fix Startup Info Data - Part 1 - COMPLETED.xlsx.xlsx	3.1 MB
3. Import and Fix Startup Info Data - Part 2.mp4	45.0 MB
3. Import and Fix Startup Info Data - Part 2.vtt	13.3 KB
3.1 Import and Fix Startup Info Data - Part 2 - COMPLETED.xlsx.xlsx	3.2 MB
3.2 Import and Fix Startup Info Data - Part 2.xlsx.xlsx	3.1 MB
4. Import and Fix Startup Info Data - Part 3.mp4	21.9 MB
4. Import and Fix Startup Info Data - Part 3.vtt	9.1 KB
4.1 Import and Fix Startup Info Data - Part 3 - COMPLETED.xlsx.xlsx	3.3 MB
4.2 Import and Fix Startup Info Data - Part 3.xlsx.xlsx	3.3 MB
5. Join the Two Tables.mp4	47.8 MB
5. Join the Two Tables.vtt	13.8 KB
5.1 Join the Two Tables.xlsx.xlsx	5.7 MB
5.2 Join the Two Tables - COMPLETED.xlsx.xlsx	11.8 MB
6. Make Unique Lists.mp4	20.1 MB
6. Make Unique Lists.vtt	6.3 KB
6.1 Make Unique Lists.xlsx.xlsx	3.3 MB
6.2 Make Unique Lists - COMPLETE.xlsx.xlsx	3.3 MB
/14. BONUS/
1. BONUS Lecture $10 Coupons.html	5.9 KB
ReadMe.txt	0.5 KB
Visit Coursedrive.org.url	0.1 KB
Total files 421