FreeCourseLab com Udemy Data Analysis Essentials Using Excel | C89C85BFBB22A25B1C31BA208487E0A03BFC8620

FreeCourseLab com Udemy Data Analysis Essentials Using Excel

Name	[FreeCourseLab.com] Udemy - Data Analysis Essentials Using Excel	DOWNLOAD Copy Link
Total Size	2.2 GB
Total Files	407
Hash	C89C85BFBB22A25B1C31BA208487E0A03BFC8620

/1. Watch This First/
1. Watch this first.mp4	12.9 MB
1. Watch this first.vtt	1.6 KB
2. Navigating Udemy.mp4	52.9 MB
2. Navigating Udemy.vtt	6.3 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 SP500 USD Historical Daily Prices.csv.csv	138.5 KB
2.3 ETH USD Historical Daily Prices.csv.csv	32.7 KB
2.4 LTC USD Historical Daily Prices.csv.csv	61.2 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 - BEFORE.xlsx.xlsx	90.0 KB
3.2 Survey Data Demographics - AFTER.xlsx.xlsx	95.9 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.1 MB
2. A Note On Data Preparation.vtt	5.0 KB
3. Scan the Data.mp4	7.7 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 - COMPLETED.xlsx.xlsx	1.6 MB
1.2 startup funding 2016.xlsx.xlsx	1.1 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
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.xlsx.xlsx	3.1 MB
3.2 Import and Fix Startup Info Data - Part 2 - COMPLETED.xlsx.xlsx	3.2 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 - COMPLETED.xlsx.xlsx	11.8 MB
5.2 Join the Two Tables.xlsx.xlsx	5.7 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
/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 Part 1.mp4	22.7 MB
2. Jumpstart Part 1.vtt	9.5 KB
2.1 vgsales_part 1.xlsx.xlsx	1.2 MB
2.2 vgsales_part 1 COMPLETED.xlsx.xlsx	1.2 MB
3. Jumpstart Part 2.mp4	19.5 MB
3. Jumpstart Part 2.vtt	6.6 KB
3.1 vgsales_part 2 COMPLETED.xlsx.xlsx	1.2 MB
3.2 vgsales_part 2.xlsx.xlsx	1.2 MB
4. Jumpstart Part 3.mp4	19.5 MB
4. Jumpstart Part 3.vtt	7.2 KB
4.1 vgsales_part 3.xlsx.xlsx	1.2 MB
4.2 vgsales_part 3 COMPLETED.xlsx.xlsx	1.2 MB
5. 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
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
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.6 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
/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
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.xlsx.xlsx	46.3 KB
10.2 Net Present Value - COMPLETED.xlsx.xlsx	50.3 KB
11. Loan Amortization Table.mp4	9.0 MB
11. Loan Amortization Table.vtt	3.5 KB
11.1 Loan Amortization.xlsx.xlsx	30.8 KB
11.2 Loan Amortization - COMPLETED.xlsx.xlsx	39.7 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 - COMPLETED.xlsx.xlsx	63.3 KB
12.2 Compound Annual Growth Rate.xlsx.xlsx	67.8 KB
13. Formula Auditing.mp4	9.6 MB
13. Formula Auditing.vtt	5.5 KB
13.1 Formula Auditing - COMPLETED.xlsx.xlsx	20.4 KB
13.2 Formula Auditing.xlsx.xlsx	30.6 KB
14. Fill Commands.mp4	13.2 MB
14. Fill Commands.vtt	4.4 KB
14.1 Fill Commands.xlsx.xlsx	45.2 KB
14.2 Fill Commands - COMPLETED.xlsx.xlsx	45.6 KB
15. IS Functions.mp4	10.3 MB
15. IS Functions.vtt	3.4 KB
15.1 IS Functions - COMPLETED.xlsx.xlsx	34.7 KB
15.2 IS Functions.xlsx.xlsx	34.5 KB
16. Rounding Numbers.mp4	12.5 MB
16. Rounding Numbers.vtt	6.5 KB
16.1 Rounding Numbers.xlsx.xlsx	26.4 KB
16.2 Rounding Numbers - COMPLETED.xlsx.xlsx	29.1 KB
17. Quiz #2.html	0.1 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.xlsx.xlsx	32.0 KB
3.2 Conditional Arithmetic - COMPLETED.xlsx.xlsx	35.2 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 - COMPLETED.xlsx.xlsx	35.1 KB
4.2 Min, Max, & Average Functions.xlsx.xlsx	34.8 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.xlsx.xlsx	38.1 KB
5.2 Logical Operators IF, AND, & OR - COMPLETED.xlsx.xlsx	38.3 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
/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
10. Adding and Subtracting Dates.mp4	10.6 MB
10. Adding and Subtracting Dates.vtt	4.9 KB
10.1 Add and Subtract Dates.xlsx.xlsx	42.1 KB
10.2 Add and Subtract Dates - COMPLETED.xlsx.xlsx	43.9 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 - COMPLETED.xlsx.xlsx	204.9 KB
14.2 Add and Subtract Times.xlsx.xlsx	145.7 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
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.xlsx.xlsx	17.9 KB
2.2 How Excel deals with text, times, and dates - COMPLETED.xlsx.xlsx	17.8 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.xlsx.xlsx	45.1 KB
5.2 Cutting Substrings from Text - COMPLETED.xlsx.xlsx	46.4 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 - COMPLETED.xlsx.xlsx	38.5 KB
7.2 Searching Inside Tex Data.xlsx.xlsx	37.2 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 - COMPLETED.xlsx.xlsx	27.0 KB
8.2 Splitting Text Field into Multiple Columns.xlsx.xlsx	26.9 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 - COMPLETED.xlsx.xlsx	44.0 KB
9.2 Converting Dates from Text into Values.xlsx.xlsx	34.4 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.0 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 - COMPLETED.xlsx.xlsx	51.2 KB
5.2 Frequency Distributions.xlsx.xlsx	45.4 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.xlsx.xlsx	64.7 KB
8.2 Correlations - COMPLETED.xlsx.xlsx	65.2 KB
/7. Handling Data in EXCEL/
1. Handling Data Overview.mp4	4.9 MB
1. Handling Data Overview.vtt	0.7 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	15.0 MB
11.1 Rankings with SMALL and LARGE.xlsx.xlsx	58.4 KB
11.2 Rankings with SMALL and LARGE - COMPLETE.xlsx.xlsx	59.0 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.xlsx.xlsx	60.1 KB
12.2 Multi-Condition Lookup with INDEX and MATCH - COMPLETED.xlsx.xlsx	60.2 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.xlsx.xlsx	34.3 KB
3.2 Lookup with HLOOKUP - COMPLETED.xlsx.xlsx	34.5 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	28.0 MB
7. Create Dropdown Lists for Filtering.vtt	10.6 KB
7.1 Create Dropdowns for Filtering - COMPLETED.xlsx.xlsx	53.6 KB
7.2 Create Dropdowns for Filtering.xlsx.xlsx	53.2 KB
8. Create Unique Lists.mp4	13.2 MB
8. Create Unique Lists.vtt	5.4 KB
8.1 Create Unique Lists - COMPLETED.xlsx.xlsx	58.0 KB
8.2 Create Unique Lists.xlsx.xlsx	54.3 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.xlsx.xlsx	41.9 KB
9.2 Fast Lookup with INDEX and MATCH - COMPLETED.xlsx.xlsx	42.3 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.xlsx.xlsx	4.6 MB
1.2 Insert a Pivot Table - COMPLETED.xlsx.xlsx	6.0 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 - COMPLETED.xlsx.xlsx	7.2 MB
2.2 Prepare Data for Pivoting.xlsx.xlsx	4.6 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 - COMPLETED.xlsx.xlsx	6.9 MB
5.2 Format for Readability.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.xlsx.xlsx	6.9 MB
6.2 Modify Output Values for Insights - COMPLETED.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.xlsx.xlsx	6.9 MB
7.2 Insert Calculated Fields - COMPLETED.xlsx.xlsx	7.0 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 - COMPLETED.xlsx.xlsx	7.0 MB
8.2 Sort, Filter and Slicer.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
10. Scatter Plot.mp4	8.2 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
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
Total files 407