CoursePig com Udemy Excel Data Analysis Masterclass with Excel Dashboards updated 10 2021

CoursePig com Udemy Excel Data Analysis Masterclass with Excel Dashboards updated 10 2021

Name	[ CoursePig.com ] Udemy - Excel Data Analysis Masterclass with Excel Dashboards (updated 10 - 2021)	DOWNLOAD Copy Link
Total Size	3.6 GB
Total Files	189
Last Seen	2024-07-23 00:00
Hash	7ABE26246F65ABEBADF9ED612C83349F1C32B046

/
Get Bonus Downloads Here.url	0.2 KB
/.../01 - Excel Basics/
001 How is Excel important to businesses.mp4	51.7 MB
001 How is Excel important to businesses_en.vtt	2.5 KB
002 Understanding the excel interface.mp4	28.1 MB
002 Understanding the excel interface_en.vtt	2.1 KB
003 Basic Formatting in Excel.mp4	37.7 MB
003 Basic Formatting in Excel_en.vtt	1.9 KB
004 Insertion and Deletion in Excel.mp4	38.9 MB
004 Insertion and Deletion in Excel_en.vtt	1.9 KB
005 Data Types in Excel.mp4	72.1 MB
005 Data Types in Excel_en.vtt	5.2 KB
006 Quiz Solution.mp4	38.7 MB
006 Quiz Solution_en.vtt	2.9 KB
Exercises on Conditional formatting.docx	703.3 KB
Exercises on Data cleaning.docx	333.4 KB
Exercises on Descriptive statistics.docx	192.8 KB
Exercises on Filters.docx	15.9 KB
Exercises on Index and match function.docx	282.6 KB
Exercises on Logical function.docx	265.0 KB
Exercises on Pivot table.docx	322.3 KB
Exercises on dashboard and visualization.xlsx	284.9 KB
Exercises on lookups.docx	245.9 KB
Exercises on text function.docx	413.3 KB
/.../S01- Excel Basics/
Excel_Example.xls	160.8 KB
/.../02 - Sort and Filter/
001 Applying the sort function.mp4	30.9 MB
001 Applying the sort function_en.vtt	1.8 KB
002 Applying the filter function.mp4	28.2 MB
002 Applying the filter function_en.vtt	1.5 KB
003 Applying the advanced filter function.mp4	44.5 MB
003 Applying the advanced filter function_en.vtt	2.4 KB
004 Quiz Solution.mp4	46.3 MB
004 Quiz Solution_en.vtt	3.1 KB
005 Exercise on Filters.mp4	51.6 MB
005 Exercise on Filters_en.vtt	2.4 KB
006 Solution on Filters.mp4	57.4 MB
006 Solution on Filters_en.vtt	3.9 KB
/.../S02- Sort and Filter/
Excel_Example.xls	160.8 KB
/.../03 - Text functions/
001 Using the UPPER, LOWER and PROPER functions.mp4	57.6 MB
001 Using the UPPER, LOWER and PROPER functions_en.vtt	3.0 KB
002 Using the LEFT, RIGHT and SEARCH functions.mp4	60.5 MB
002 Using the LEFT, RIGHT and SEARCH functions_en.vtt	3.1 KB
003 Using the TRIM, CONCAT and LEN functions.mp4	50.6 MB
003 Using the TRIM, CONCAT and LEN functions_en.vtt	2.5 KB
004 Quiz Solution.mp4	73.3 MB
004 Quiz Solution_en.vtt	4.5 KB
005 Exercise on Text Functions.mp4	69.8 MB
005 Exercise on Text Functions_en.vtt	3.3 KB
006 Solution on Text Functions.mp4	66.8 MB
006 Solution on Text Functions_en.vtt	5.7 KB
/.../S03- Text functions/
Excel_Example.xls	160.8 KB
/.../04 - Statistical functions/
001 Using the MIN, MAX AVERAGE functions.mp4	38.4 MB
001 Using the MIN, MAX AVERAGE functions_en.vtt	1.9 KB
002 Finding the Standard deviations.mp4	52.0 MB
002 Finding the Standard deviations_en.vtt	2.6 KB
003 Find the percentiles of data.mp4	50.9 MB
003 Find the percentiles of data_en.vtt	2.9 KB
004 Finding the Outliers present in data.mp4	60.0 MB
004 Finding the Outliers present in data_en.vtt	3.3 KB
005 Finding the Missing values in data.mp4	36.8 MB
005 Finding the Missing values in data_en.vtt	1.7 KB
006 Quiz Solution.mp4	60.5 MB
006 Quiz Solution_en.vtt	4.2 KB
007 Exercise on Descriptive Statistics.mp4	64.2 MB
007 Exercise on Descriptive Statistics_en.vtt	3.0 KB
008 Solution on Descriptive Statistics.mp4	60.8 MB
008 Solution on Descriptive Statistics_en.vtt	4.5 KB
009 Exercise on Data Cleaning.mp4	56.6 MB
009 Exercise on Data Cleaning_en.vtt	2.8 KB
010 Solution on Data Cleaning.mp4	79.8 MB
010 Solution on Data Cleaning_en.vtt	6.8 KB
37037462-exams.xlsx	67.2 KB
37037484-exams.xlsx	67.2 KB
/.../S04- Statistical functions/
Excel_Example.xls	160.8 KB
market_fact.csv	619.9 KB
/.../05 - Logical Functions/
001 Using the IF function.mp4	29.6 MB
001 Using the IF function_en.vtt	1.4 KB
002 Using the IF ERROR function.mp4	35.1 MB
002 Using the IF ERROR function_en.vtt	1.9 KB
003 Applying the COUNTIF function.mp4	35.9 MB
003 Applying the COUNTIF function_en.vtt	1.9 KB
004 Applying the SUMIF function.mp4	32.0 MB
004 Applying the SUMIF function_en.vtt	1.7 KB
005 Applying the AVERAGEIF function.mp4	33.7 MB
005 Applying the AVERAGEIF function_en.vtt	1.8 KB
006 Quiz Solution.mp4	45.9 MB
006 Quiz Solution_en.vtt	3.6 KB
007 Exercise on Logical Functions.mp4	70.8 MB
007 Exercise on Logical Functions_en.vtt	3.5 KB
008 Solution on Logical Functions.mp4	63.4 MB
008 Solution on Logical Functions_en.vtt	6.7 KB
37037346-logicalData.xlsx	10.8 KB
37037350-exams.xlsx	67.2 KB
/.../S05- Logical functions/
market_fact.csv	619.9 KB
/.../06 - Conditional Formatting/
001 Using Colorbars for formatting.mp4	32.5 MB
001 Using Colorbars for formatting_en.vtt	1.9 KB
002 Using Colorscales for formatting.mp4	32.3 MB
002 Using Colorscales for formatting_en.vtt	1.5 KB
003 Quiz Solution.mp4	52.9 MB
003 Quiz Solution_en.vtt	4.1 KB
004 Exercise on Conditional Formatting.mp4	60.6 MB
004 Exercise on Conditional Formatting_en.vtt	3.0 KB
005 Solution on Conditional Formatting.mp4	54.7 MB
005 Solution on Conditional Formatting_en.vtt	4.2 KB
37037326-logical-data.xlsx	10.8 KB
37037664-market-fact.csv	619.9 KB
/.../07 - Lookup Functions/
001 Applying VLOOKUP function.mp4	61.3 MB
001 Applying VLOOKUP function_en.vtt	3.5 KB
002 Applying HLOOKUP function.mp4	26.8 MB
002 Applying HLOOKUP function_en.vtt	2.0 KB
003 Quiz Solution.mp4	45.5 MB
003 Quiz Solution_en.vtt	3.3 KB
004 Exercise on Lookup Functions.mp4	44.2 MB
004 Exercise on Lookup Functions_en.vtt	2.1 KB
005 Solution on Lookup Functions.mp4	51.8 MB
005 Solution on Lookup Functions_en.vtt	4.5 KB
37037298-vlookup.xlsx	10.8 KB
37037310-vlookup-2.xlsx	10.6 KB
/.../S07- Lookup functions/
MOCK_DATA.xlsx	11.2 KB
/.../08 - Index and Match/
001 Why to use Index and Match_.mp4	54.7 MB
001 Why to use Index and Match__en.vtt	2.3 KB
002 Applying Index and Match.mp4	40.2 MB
002 Applying Index and Match_en.vtt	2.5 KB
003 Quiz Solution.mp4	42.1 MB
003 Quiz Solution_en.vtt	3.4 KB
004 Exercise on Index and Match Functions.mp4	58.6 MB
004 Exercise on Index and Match Functions_en.vtt	2.8 KB
005 Solution on Index and Match Functions.mp4	73.8 MB
005 Solution on Index and Match Functions_en.vtt	6.5 KB
37037286-Exercises-on-Index-and-match.xlsx	9.2 KB
/.../S08- Index and MAtch/
MOCK_DATA.xlsx	9.3 KB
/.../09 - Pivot Tables/
001 Making Pivot Tables.mp4	46.5 MB
001 Making Pivot Tables_en.vtt	3.3 KB
002 Making Pivot Charts.mp4	29.8 MB
002 Making Pivot Charts_en.vtt	1.8 KB
003 Quiz Solution.mp4	42.6 MB
003 Quiz Solution_en.vtt	3.1 KB
004 Exercise on Pivot Tables.mp4	61.6 MB
004 Exercise on Pivot Tables_en.vtt	2.9 KB
005 Solution on Pivot Tables.mp4	50.5 MB
005 Solution on Pivot Tables_en.vtt	4.0 KB
37037008-pivot-exercise.xlsx	33.4 KB
37037012-pivot2.xlsx	11.0 KB
37037146-pivot-3.xlsx	16.6 KB
/.../S09- Pivot Tables/
MOCK_DATA.xlsx	26.1 KB
/10 - Dashboards/
001 Basics of Data Visualizations.mp4	43.9 MB
001 Basics of Data Visualizations_en.vtt	2.1 KB
002 Making Charts in Excel.mp4	52.9 MB
002 Making Charts in Excel_en.vtt	3.5 KB
003 Making Dashboards.mp4	40.7 MB
003 Making Dashboards_en.vtt	2.2 KB
004 Adding Slicers in Dashbaords.mp4	34.6 MB
004 Adding Slicers in Dashbaords_en.vtt	2.4 KB
005 Formatting dashboards.mp4	29.3 MB
005 Formatting dashboards_en.vtt	1.8 KB
006 Quiz Solution.mp4	41.1 MB
006 Quiz Solution_en.vtt	3.0 KB
007 Exercise on Data Visualizations.mp4	60.0 MB
007 Exercise on Data Visualizations_en.vtt	2.8 KB
008 Solution on Data Visualizations.mp4	49.4 MB
008 Solution on Data Visualizations_en.vtt	3.8 KB
009 Exercise on Dashboards.mp4	41.4 MB
009 Exercise on Dashboards_en.vtt	1.9 KB
010 Solution on Dashboards.mp4	65.2 MB
010 Solution on Dashboards_en.vtt	5.7 KB
37036824-pivot-3.xlsx	16.6 KB
37036832-Pivot-charts.xlsx	284.9 KB
37036996-Exercises-on-dashboard-and-visualization.xlsx	284.9 KB
/10 - Dashboards/S10- Dashboards/
Orders_data.xlsx	1.5 MB
/.../11 - What If Analysis/
001 Goal Seek Analysis.mp4	44.9 MB
001 Goal Seek Analysis_en.vtt	3.1 KB
002 Data Tables.mp4	34.4 MB
002 Data Tables_en.vtt	2.5 KB
003 Scenario Management.mp4	48.3 MB
003 Scenario Management_en.vtt	3.2 KB
004 Quiz Solution.mp4	56.0 MB
004 Quiz Solution_en.vtt	4.0 KB
/.../S11- What if Analysis/
What if Analysis.xlsx	15.5 KB
/12 - Regression/
001 Understanding Regression.mp4	40.9 MB
001 Understanding Regression_en.vtt	1.9 KB
002 Performing Linear Regression.mp4	35.2 MB
002 Performing Linear Regression_en.vtt	2.1 KB
003 Quiz Solution.mp4	76.2 MB
003 Quiz Solution_en.vtt	5.0 KB
/12 - Regression/S12- Regression/
Salary_Data.xls	21.0 KB
/.../13 - Outro Section/
001 Conclusion.mp4	48.5 MB
001 Conclusion_en.vtt	2.6 KB
002 How to Get Your Certificate of Completion.html	0.5 KB
/.../14 - Bonus Section/
001 Bonus Lecture.html	4.8 KB
/~Get Your Files Here !/
Bonus Resources.txt	0.4 KB
Total files 189