[ CoursePig.com ] Udemy - Excel Data Analysis Masterclass with Excel Dashboards (updated 10 - 2021)

File Name

Size

Get Bonus Downloads Here.url

179 B

~Get Your Files Here !/01 - Excel Basics/001 How is Excel important to businesses.mp4

49 MB

~Get Your Files Here !/01 - Excel Basics/001 How is Excel important to businesses_en.vtt

2.5 kB

~Get Your Files Here !/01 - Excel Basics/002 Understanding the excel interface.mp4

27 MB

~Get Your Files Here !/01 - Excel Basics/002 Understanding the excel interface_en.vtt

2.1 kB

~Get Your Files Here !/01 - Excel Basics/003 Basic Formatting in Excel.mp4

36 MB

~Get Your Files Here !/01 - Excel Basics/003 Basic Formatting in Excel_en.vtt

1.8 kB

~Get Your Files Here !/01 - Excel Basics/004 Insertion and Deletion in Excel.mp4

37 MB

~Get Your Files Here !/01 - Excel Basics/004 Insertion and Deletion in Excel_en.vtt

1.9 kB

~Get Your Files Here !/01 - Excel Basics/005 Data Types in Excel.mp4

69 MB

~Get Your Files Here !/01 - Excel Basics/005 Data Types in Excel_en.vtt

5.0 kB

~Get Your Files Here !/01 - Excel Basics/006 Quiz Solution.mp4

37 MB

~Get Your Files Here !/01 - Excel Basics/006 Quiz Solution_en.vtt

2.8 kB

~Get Your Files Here !/01 - Excel Basics/Exercises on Conditional formatting.docx

687 kB

~Get Your Files Here !/01 - Excel Basics/Exercises on Data cleaning.docx

326 kB

~Get Your Files Here !/01 - Excel Basics/Exercises on Descriptive statistics.docx

188 kB

~Get Your Files Here !/01 - Excel Basics/Exercises on Filters.docx

16 kB

~Get Your Files Here !/01 - Excel Basics/Exercises on Index and match function.docx

276 kB

~Get Your Files Here !/01 - Excel Basics/Exercises on Logical function.docx

259 kB

~Get Your Files Here !/01 - Excel Basics/Exercises on Pivot table.docx

315 kB

~Get Your Files Here !/01 - Excel Basics/Exercises on dashboard and visualization.xlsx

278 kB

~Get Your Files Here !/01 - Excel Basics/Exercises on lookups.docx

240 kB

~Get Your Files Here !/01 - Excel Basics/Exercises on text function.docx

404 kB

~Get Your Files Here !/01 - Excel Basics/S01- Excel Basics/Excel_Example.xls

157 kB

~Get Your Files Here !/02 - Sort and Filter/001 Applying the sort function.mp4

30 MB

~Get Your Files Here !/02 - Sort and Filter/001 Applying the sort function_en.vtt

1.8 kB

~Get Your Files Here !/02 - Sort and Filter/002 Applying the filter function.mp4

27 MB

~Get Your Files Here !/02 - Sort and Filter/002 Applying the filter function_en.vtt

1.5 kB

~Get Your Files Here !/02 - Sort and Filter/003 Applying the advanced filter function.mp4

42 MB

~Get Your Files Here !/02 - Sort and Filter/003 Applying the advanced filter function_en.vtt

2.3 kB

~Get Your Files Here !/02 - Sort and Filter/004 Quiz Solution.mp4

44 MB

~Get Your Files Here !/02 - Sort and Filter/004 Quiz Solution_en.vtt

3.1 kB

~Get Your Files Here !/02 - Sort and Filter/005 Exercise on Filters.mp4

49 MB

~Get Your Files Here !/02 - Sort and Filter/005 Exercise on Filters_en.vtt

2.4 kB

~Get Your Files Here !/02 - Sort and Filter/006 Solution on Filters.mp4

55 MB

~Get Your Files Here !/02 - Sort and Filter/006 Solution on Filters_en.vtt

3.8 kB

~Get Your Files Here !/02 - Sort and Filter/S02- Sort and Filter/Excel_Example.xls

157 kB

~Get Your Files Here !/03 - Text functions/001 Using the UPPER, LOWER and PROPER functions.mp4

55 MB

~Get Your Files Here !/03 - Text functions/001 Using the UPPER, LOWER and PROPER functions_en.vtt

2.9 kB

~Get Your Files Here !/03 - Text functions/002 Using the LEFT, RIGHT and SEARCH functions.mp4

58 MB

~Get Your Files Here !/03 - Text functions/002 Using the LEFT, RIGHT and SEARCH functions_en.vtt

3.0 kB

~Get Your Files Here !/03 - Text functions/003 Using the TRIM, CONCAT and LEN functions.mp4

48 MB

~Get Your Files Here !/03 - Text functions/003 Using the TRIM, CONCAT and LEN functions_en.vtt

2.5 kB

~Get Your Files Here !/03 - Text functions/004 Quiz Solution.mp4

70 MB

~Get Your Files Here !/03 - Text functions/004 Quiz Solution_en.vtt

4.4 kB

~Get Your Files Here !/03 - Text functions/005 Exercise on Text Functions.mp4

67 MB

~Get Your Files Here !/03 - Text functions/005 Exercise on Text Functions_en.vtt

3.2 kB

~Get Your Files Here !/03 - Text functions/006 Solution on Text Functions.mp4

64 MB

~Get Your Files Here !/03 - Text functions/006 Solution on Text Functions_en.vtt

5.6 kB

~Get Your Files Here !/03 - Text functions/S03- Text functions/Excel_Example.xls

157 kB

~Get Your Files Here !/04 - Statistical functions/001 Using the MIN, MAX AVERAGE functions.mp4

37 MB

~Get Your Files Here !/04 - Statistical functions/001 Using the MIN, MAX AVERAGE functions_en.vtt

1.9 kB

~Get Your Files Here !/04 - Statistical functions/002 Finding the Standard deviations.mp4

50 MB

~Get Your Files Here !/04 - Statistical functions/002 Finding the Standard deviations_en.vtt

2.6 kB

~Get Your Files Here !/04 - Statistical functions/003 Find the percentiles of data.mp4

49 MB

~Get Your Files Here !/04 - Statistical functions/003 Find the percentiles of data_en.vtt

2.9 kB

~Get Your Files Here !/04 - Statistical functions/004 Finding the Outliers present in data.mp4

57 MB

~Get Your Files Here !/04 - Statistical functions/004 Finding the Outliers present in data_en.vtt

3.2 kB

~Get Your Files Here !/04 - Statistical functions/005 Finding the Missing values in data.mp4

35 MB

~Get Your Files Here !/04 - Statistical functions/005 Finding the Missing values in data_en.vtt

1.7 kB

~Get Your Files Here !/04 - Statistical functions/006 Quiz Solution.mp4

58 MB

~Get Your Files Here !/04 - Statistical functions/006 Quiz Solution_en.vtt

4.1 kB

~Get Your Files Here !/04 - Statistical functions/007 Exercise on Descriptive Statistics.mp4

61 MB

~Get Your Files Here !/04 - Statistical functions/007 Exercise on Descriptive Statistics_en.vtt

2.9 kB

~Get Your Files Here !/04 - Statistical functions/008 Solution on Descriptive Statistics.mp4

58 MB

~Get Your Files Here !/04 - Statistical functions/008 Solution on Descriptive Statistics_en.vtt

4.4 kB

~Get Your Files Here !/04 - Statistical functions/009 Exercise on Data Cleaning.mp4

54 MB

~Get Your Files Here !/04 - Statistical functions/009 Exercise on Data Cleaning_en.vtt

2.7 kB

~Get Your Files Here !/04 - Statistical functions/010 Solution on Data Cleaning.mp4

76 MB

~Get Your Files Here !/04 - Statistical functions/010 Solution on Data Cleaning_en.vtt

6.6 kB

~Get Your Files Here !/04 - Statistical functions/37037462-exams.xlsx

66 kB

~Get Your Files Here !/04 - Statistical functions/37037484-exams.xlsx

66 kB

~Get Your Files Here !/04 - Statistical functions/S04- Statistical functions/Excel_Example.xls

157 kB

~Get Your Files Here !/04 - Statistical functions/S04- Statistical functions/market_fact.csv

605 kB

~Get Your Files Here !/05 - Logical Functions/001 Using the IF function.mp4

28 MB

~Get Your Files Here !/05 - Logical Functions/001 Using the IF function_en.vtt

1.4 kB

~Get Your Files Here !/05 - Logical Functions/002 Using the IF ERROR function.mp4

34 MB

~Get Your Files Here !/05 - Logical Functions/002 Using the IF ERROR function_en.vtt

1.9 kB

~Get Your Files Here !/05 - Logical Functions/003 Applying the COUNTIF function.mp4

34 MB

~Get Your Files Here !/05 - Logical Functions/003 Applying the COUNTIF function_en.vtt

1.9 kB

~Get Your Files Here !/05 - Logical Functions/004 Applying the SUMIF function.mp4

31 MB

~Get Your Files Here !/05 - Logical Functions/004 Applying the SUMIF function_en.vtt

1.7 kB

~Get Your Files Here !/05 - Logical Functions/005 Applying the AVERAGEIF function.mp4

32 MB

~Get Your Files Here !/05 - Logical Functions/005 Applying the AVERAGEIF function_en.vtt

1.8 kB

~Get Your Files Here !/05 - Logical Functions/006 Quiz Solution.mp4

44 MB

~Get Your Files Here !/05 - Logical Functions/006 Quiz Solution_en.vtt

3.5 kB

~Get Your Files Here !/05 - Logical Functions/007 Exercise on Logical Functions.mp4

68 MB

~Get Your Files Here !/05 - Logical Functions/007 Exercise on Logical Functions_en.vtt

3.5 kB

~Get Your Files Here !/05 - Logical Functions/008 Solution on Logical Functions.mp4

60 MB

~Get Your Files Here !/05 - Logical Functions/008 Solution on Logical Functions_en.vtt

6.6 kB

~Get Your Files Here !/05 - Logical Functions/37037346-logicalData.xlsx

10 kB

~Get Your Files Here !/05 - Logical Functions/37037350-exams.xlsx

66 kB

~Get Your Files Here !/05 - Logical Functions/S05- Logical functions/market_fact.csv

605 kB

~Get Your Files Here !/06 - Conditional Formatting/001 Using Colorbars for formatting.mp4

31 MB

~Get Your Files Here !/06 - Conditional Formatting/001 Using Colorbars for formatting_en.vtt

1.8 kB

~Get Your Files Here !/06 - Conditional Formatting/002 Using Colorscales for formatting.mp4

31 MB

~Get Your Files Here !/06 - Conditional Formatting/002 Using Colorscales for formatting_en.vtt

1.5 kB

~Get Your Files Here !/06 - Conditional Formatting/003 Quiz Solution.mp4

50 MB

~Get Your Files Here !/06 - Conditional Formatting/003 Quiz Solution_en.vtt

4.0 kB

~Get Your Files Here !/06 - Conditional Formatting/004 Exercise on Conditional Formatting.mp4

58 MB

~Get Your Files Here !/06 - Conditional Formatting/004 Exercise on Conditional Formatting_en.vtt

2.9 kB

~Get Your Files Here !/06 - Conditional Formatting/005 Solution on Conditional Formatting.mp4

52 MB

~Get Your Files Here !/06 - Conditional Formatting/005 Solution on Conditional Formatting_en.vtt

4.1 kB

~Get Your Files Here !/06 - Conditional Formatting/37037326-logical-data.xlsx

10 kB

~Get Your Files Here !/06 - Conditional Formatting/37037664-market-fact.csv

605 kB

~Get Your Files Here !/07 - Lookup Functions/001 Applying VLOOKUP function.mp4

58 MB

~Get Your Files Here !/07 - Lookup Functions/001 Applying VLOOKUP function_en.vtt

3.4 kB

~Get Your Files Here !/07 - Lookup Functions/002 Applying HLOOKUP function.mp4

26 MB

~Get Your Files Here !/07 - Lookup Functions/002 Applying HLOOKUP function_en.vtt

1.9 kB

~Get Your Files Here !/07 - Lookup Functions/003 Quiz Solution.mp4

43 MB

~Get Your Files Here !/07 - Lookup Functions/003 Quiz Solution_en.vtt

3.2 kB

~Get Your Files Here !/07 - Lookup Functions/004 Exercise on Lookup Functions.mp4

42 MB

~Get Your Files Here !/07 - Lookup Functions/004 Exercise on Lookup Functions_en.vtt

2.0 kB

~Get Your Files Here !/07 - Lookup Functions/005 Solution on Lookup Functions.mp4

49 MB

~Get Your Files Here !/07 - Lookup Functions/005 Solution on Lookup Functions_en.vtt

4.4 kB

~Get Your Files Here !/07 - Lookup Functions/37037298-vlookup.xlsx

11 kB

~Get Your Files Here !/07 - Lookup Functions/37037310-vlookup-2.xlsx

10 kB

~Get Your Files Here !/07 - Lookup Functions/S07- Lookup functions/MOCK_DATA.xlsx

11 kB

~Get Your Files Here !/08 - Index and Match/001 Why to use Index and Match_.mp4

52 MB

~Get Your Files Here !/08 - Index and Match/001 Why to use Index and Match__en.vtt

2.2 kB

~Get Your Files Here !/08 - Index and Match/002 Applying Index and Match.mp4

38 MB

~Get Your Files Here !/08 - Index and Match/002 Applying Index and Match_en.vtt

2.4 kB

~Get Your Files Here !/08 - Index and Match/003 Quiz Solution.mp4

40 MB

~Get Your Files Here !/08 - Index and Match/003 Quiz Solution_en.vtt

3.3 kB

~Get Your Files Here !/08 - Index and Match/004 Exercise on Index and Match Functions.mp4

56 MB

~Get Your Files Here !/08 - Index and Match/004 Exercise on Index and Match Functions_en.vtt

2.8 kB

~Get Your Files Here !/08 - Index and Match/005 Solution on Index and Match Functions.mp4

70 MB

~Get Your Files Here !/08 - Index and Match/005 Solution on Index and Match Functions_en.vtt

6.3 kB

~Get Your Files Here !/08 - Index and Match/37037286-Exercises-on-Index-and-match.xlsx

9.0 kB

~Get Your Files Here !/08 - Index and Match/S08- Index and MAtch/MOCK_DATA.xlsx

9.1 kB

~Get Your Files Here !/09 - Pivot Tables/001 Making Pivot Tables.mp4

44 MB

~Get Your Files Here !/09 - Pivot Tables/001 Making Pivot Tables_en.vtt

3.2 kB

~Get Your Files Here !/09 - Pivot Tables/002 Making Pivot Charts.mp4

28 MB

~Get Your Files Here !/09 - Pivot Tables/002 Making Pivot Charts_en.vtt

1.8 kB

~Get Your Files Here !/09 - Pivot Tables/003 Quiz Solution.mp4

41 MB

~Get Your Files Here !/09 - Pivot Tables/003 Quiz Solution_en.vtt

3.0 kB

~Get Your Files Here !/09 - Pivot Tables/004 Exercise on Pivot Tables.mp4

59 MB

~Get Your Files Here !/09 - Pivot Tables/004 Exercise on Pivot Tables_en.vtt

2.9 kB

~Get Your Files Here !/09 - Pivot Tables/005 Solution on Pivot Tables.mp4

48 MB

~Get Your Files Here !/09 - Pivot Tables/005 Solution on Pivot Tables_en.vtt

3.9 kB

~Get Your Files Here !/09 - Pivot Tables/37037008-pivot-exercise.xlsx

33 kB

~Get Your Files Here !/09 - Pivot Tables/37037012-pivot2.xlsx

11 kB

~Get Your Files Here !/09 - Pivot Tables/37037146-pivot-3.xlsx

16 kB

~Get Your Files Here !/09 - Pivot Tables/S09- Pivot Tables/MOCK_DATA.xlsx

26 kB

~Get Your Files Here !/10 - Dashboards/001 Basics of Data Visualizations.mp4

42 MB

~Get Your Files Here !/10 - Dashboards/001 Basics of Data Visualizations_en.vtt

2.0 kB

~Get Your Files Here !/10 - Dashboards/002 Making Charts in Excel.mp4

50 MB

~Get Your Files Here !/10 - Dashboards/002 Making Charts in Excel_en.vtt

3.4 kB

~Get Your Files Here !/10 - Dashboards/003 Making Dashboards.mp4

39 MB

~Get Your Files Here !/10 - Dashboards/003 Making Dashboards_en.vtt

2.1 kB

~Get Your Files Here !/10 - Dashboards/004 Adding Slicers in Dashbaords.mp4

33 MB

~Get Your Files Here !/10 - Dashboards/004 Adding Slicers in Dashbaords_en.vtt

2.4 kB

~Get Your Files Here !/10 - Dashboards/005 Formatting dashboards.mp4

28 MB

~Get Your Files Here !/10 - Dashboards/005 Formatting dashboards_en.vtt

1.8 kB

~Get Your Files Here !/10 - Dashboards/006 Quiz Solution.mp4

39 MB

~Get Your Files Here !/10 - Dashboards/006 Quiz Solution_en.vtt

3.0 kB

~Get Your Files Here !/10 - Dashboards/007 Exercise on Data Visualizations.mp4

57 MB

~Get Your Files Here !/10 - Dashboards/007 Exercise on Data Visualizations_en.vtt

2.7 kB

~Get Your Files Here !/10 - Dashboards/008 Solution on Data Visualizations.mp4

47 MB

~Get Your Files Here !/10 - Dashboards/008 Solution on Data Visualizations_en.vtt

3.7 kB

~Get Your Files Here !/10 - Dashboards/009 Exercise on Dashboards.mp4

40 MB

~Get Your Files Here !/10 - Dashboards/009 Exercise on Dashboards_en.vtt

1.8 kB

~Get Your Files Here !/10 - Dashboards/010 Solution on Dashboards.mp4

62 MB

~Get Your Files Here !/10 - Dashboards/010 Solution on Dashboards_en.vtt

5.6 kB

~Get Your Files Here !/10 - Dashboards/37036824-pivot-3.xlsx

16 kB

~Get Your Files Here !/10 - Dashboards/37036832-Pivot-charts.xlsx

278 kB

~Get Your Files Here !/10 - Dashboards/37036996-Exercises-on-dashboard-and-visualization.xlsx

278 kB

~Get Your Files Here !/10 - Dashboards/S10- Dashboards/Orders_data.xlsx

1.5 MB

~Get Your Files Here !/11 - What If Analysis/001 Goal Seek Analysis.mp4

43 MB

~Get Your Files Here !/11 - What If Analysis/001 Goal Seek Analysis_en.vtt

3.0 kB

~Get Your Files Here !/11 - What If Analysis/002 Data Tables.mp4

33 MB

~Get Your Files Here !/11 - What If Analysis/002 Data Tables_en.vtt

2.4 kB

~Get Your Files Here !/11 - What If Analysis/003 Scenario Management.mp4

46 MB

~Get Your Files Here !/11 - What If Analysis/003 Scenario Management_en.vtt

3.2 kB

~Get Your Files Here !/11 - What If Analysis/004 Quiz Solution.mp4

53 MB

~Get Your Files Here !/11 - What If Analysis/004 Quiz Solution_en.vtt

3.9 kB

~Get Your Files Here !/11 - What If Analysis/S11- What if Analysis/What if Analysis.xlsx

15 kB

~Get Your Files Here !/12 - Regression/001 Understanding Regression.mp4

39 MB

~Get Your Files Here !/12 - Regression/001 Understanding Regression_en.vtt

1.8 kB

~Get Your Files Here !/12 - Regression/002 Performing Linear Regression.mp4

34 MB

~Get Your Files Here !/12 - Regression/002 Performing Linear Regression_en.vtt

2.1 kB

~Get Your Files Here !/12 - Regression/003 Quiz Solution.mp4

73 MB

~Get Your Files Here !/12 - Regression/003 Quiz Solution_en.vtt

4.9 kB

~Get Your Files Here !/12 - Regression/S12- Regression/Salary_Data.xls

20 kB

~Get Your Files Here !/13 - Outro Section/001 Conclusion.mp4

46 MB

~Get Your Files Here !/13 - Outro Section/001 Conclusion_en.vtt

2.5 kB

~Get Your Files Here !/13 - Outro Section/002 How to Get Your Certificate of Completion.html

468 B

~Get Your Files Here !/14 - Bonus Section/001 Bonus Lecture.html

4.7 kB

~Get Your Files Here !/Bonus Resources.txt

357 B