|
|
001 Applying VLOOKUP function.mp4
|
MP4
|
58.5 MB
|
|
|
001 Applying VLOOKUP function_en.vtt
|
VTT
|
3.4 KB
|
|
|
001 Applying the sort function.mp4
|
MP4
|
29.5 MB
|
|
|
001 Applying the sort function_en.vtt
|
VTT
|
1.8 KB
|
|
|
001 Basics of Data Visualizations.mp4
|
MP4
|
41.8 MB
|
|
|
001 Basics of Data Visualizations_en.vtt
|
VTT
|
2 KB
|
|
|
001 Bonus Lecture.html
|
HTML
|
4.7 KB
|
|
|
001 Conclusion.mp4
|
MP4
|
46.3 MB
|
|
|
001 Conclusion_en.vtt
|
VTT
|
2.5 KB
|
|
|
001 Goal Seek Analysis.mp4
|
MP4
|
42.8 MB
|
|
|
001 Goal Seek Analysis_en.vtt
|
VTT
|
3 KB
|
|
|
001 How is Excel important to businesses.mp4
|
MP4
|
49.3 MB
|
|
|
001 How is Excel important to businesses_en.vtt
|
VTT
|
2.5 KB
|
|
|
001 Making Pivot Tables.mp4
|
MP4
|
44.3 MB
|
|
|
001 Making Pivot Tables_en.vtt
|
VTT
|
3.2 KB
|
|
|
001 Understanding Regression.mp4
|
MP4
|
39 MB
|
|
|
001 Understanding Regression_en.vtt
|
VTT
|
1.8 KB
|
|
|
001 Using Colorbars for formatting.mp4
|
MP4
|
31 MB
|
|
|
001 Using Colorbars for formatting_en.vtt
|
VTT
|
1.8 KB
|
|
|
001 Using the IF function.mp4
|
MP4
|
28.2 MB
|
|
|
001 Using the IF function_en.vtt
|
VTT
|
1.4 KB
|
|
|
001 Using the MIN, MAX AVERAGE functions.mp4
|
MP4
|
36.6 MB
|
|
|
001 Using the MIN, MAX AVERAGE functions_en.vtt
|
VTT
|
1.9 KB
|
|
|
001 Using the UPPER, LOWER and PROPER functions.mp4
|
MP4
|
54.9 MB
|
|
|
001 Using the UPPER, LOWER and PROPER functions_en.vtt
|
VTT
|
2.9 KB
|
|
|
001 Why to use Index and Match_.mp4
|
MP4
|
52.1 MB
|
|
|
001 Why to use Index and Match__en.vtt
|
VTT
|
2.2 KB
|
|
|
002 Applying HLOOKUP function.mp4
|
MP4
|
25.6 MB
|
|
|
002 Applying HLOOKUP function_en.vtt
|
VTT
|
1.9 KB
|
|
|
002 Applying Index and Match.mp4
|
MP4
|
38.4 MB
|
|
|
002 Applying Index and Match_en.vtt
|
VTT
|
2.4 KB
|
|
|
002 Applying the filter function.mp4
|
MP4
|
26.9 MB
|
|
|
002 Applying the filter function_en.vtt
|
VTT
|
1.5 KB
|
|
|
002 Data Tables.mp4
|
MP4
|
32.8 MB
|
|
|
002 Data Tables_en.vtt
|
VTT
|
2.4 KB
|
|
|
002 Finding the Standard deviations.mp4
|
MP4
|
49.6 MB
|
|
|
002 Finding the Standard deviations_en.vtt
|
VTT
|
2.6 KB
|
|
|
002 How to Get Your Certificate of Completion.html
|
HTML
|
512 B
|
|
|
002 Making Charts in Excel.mp4
|
MP4
|
50.5 MB
|
|
|
002 Making Charts in Excel_en.vtt
|
VTT
|
3.4 KB
|
|
|
002 Making Pivot Charts.mp4
|
MP4
|
28.4 MB
|
|
|
002 Making Pivot Charts_en.vtt
|
VTT
|
1.8 KB
|
|
|
002 Performing Linear Regression.mp4
|
MP4
|
33.6 MB
|
|
|
002 Performing Linear Regression_en.vtt
|
VTT
|
2.1 KB
|
|
|
002 Understanding the excel interface.mp4
|
MP4
|
26.8 MB
|
|
|
002 Understanding the excel interface_en.vtt
|
VTT
|
2.1 KB
|
|
|
002 Using Colorscales for formatting.mp4
|
MP4
|
30.8 MB
|
|
|
002 Using Colorscales for formatting_en.vtt
|
VTT
|
1.5 KB
|
|
|
002 Using the IF ERROR function.mp4
|
MP4
|
33.5 MB
|
|
|
002 Using the IF ERROR function_en.vtt
|
VTT
|
1.9 KB
|
|
|
002 Using the LEFT, RIGHT and SEARCH functions.mp4
|
MP4
|
57.7 MB
|
|
|
002 Using the LEFT, RIGHT and SEARCH functions_en.vtt
|
VTT
|
3 KB
|
|
|
003 Applying the COUNTIF function.mp4
|
MP4
|
34.2 MB
|
|
|
003 Applying the COUNTIF function_en.vtt
|
VTT
|
1.9 KB
|
|
|
003 Applying the advanced filter function.mp4
|
MP4
|
42.4 MB
|
|
|
003 Applying the advanced filter function_en.vtt
|
VTT
|
2.3 KB
|
|
|
003 Basic Formatting in Excel.mp4
|
MP4
|
35.9 MB
|
|
|
003 Basic Formatting in Excel_en.vtt
|
VTT
|
1.8 KB
|
|
|
003 Find the percentiles of data.mp4
|
MP4
|
48.6 MB
|
|
|
003 Find the percentiles of data_en.vtt
|
VTT
|
2.9 KB
|
|
|
003 Making Dashboards.mp4
|
MP4
|
38.8 MB
|
|
|
003 Making Dashboards_en.vtt
|
VTT
|
2.1 KB
|
|
|
003 Quiz Solution.mp4
|
MP4
|
72.6 MB
|
|
|
003 Quiz Solution_en.vtt
|
VTT
|
4.9 KB
|
|
|
003 Scenario Management.mp4
|
MP4
|
46.1 MB
|
|
|
003 Scenario Management_en.vtt
|
VTT
|
3.2 KB
|
|
|
003 Using the TRIM, CONCAT and LEN functions.mp4
|
MP4
|
48.3 MB
|
|
|
003 Using the TRIM, CONCAT and LEN functions_en.vtt
|
VTT
|
2.5 KB
|
|
|
004 Adding Slicers in Dashbaords.mp4
|
MP4
|
33 MB
|
|
|
004 Adding Slicers in Dashbaords_en.vtt
|
VTT
|
2.4 KB
|
|
|
004 Applying the SUMIF function.mp4
|
MP4
|
30.6 MB
|
|
|
004 Applying the SUMIF function_en.vtt
|
VTT
|
1.7 KB
|
|
|
004 Exercise on Conditional Formatting.mp4
|
MP4
|
57.8 MB
|
|
|
004 Exercise on Conditional Formatting_en.vtt
|
VTT
|
2.9 KB
|
|
|
004 Exercise on Index and Match Functions.mp4
|
MP4
|
55.9 MB
|
|
|
004 Exercise on Index and Match Functions_en.vtt
|
VTT
|
2.8 KB
|
|
|
004 Exercise on Lookup Functions.mp4
|
MP4
|
42.1 MB
|
|
|
004 Exercise on Lookup Functions_en.vtt
|
VTT
|
2 KB
|
|
|
004 Exercise on Pivot Tables.mp4
|
MP4
|
58.7 MB
|
|
|
004 Exercise on Pivot Tables_en.vtt
|
VTT
|
2.9 KB
|
|
|
004 Finding the Outliers present in data.mp4
|
MP4
|
57.3 MB
|
|
|
004 Finding the Outliers present in data_en.vtt
|
VTT
|
3.2 KB
|
|
|
004 Insertion and Deletion in Excel.mp4
|
MP4
|
37.1 MB
|
|
|
004 Insertion and Deletion in Excel_en.vtt
|
VTT
|
1.9 KB
|
|
|
004 Quiz Solution.mp4
|
MP4
|
53.4 MB
|
|
|
004 Quiz Solution_en.vtt
|
VTT
|
3.9 KB
|
|
|
005 Applying the AVERAGEIF function.mp4
|
MP4
|
32.1 MB
|
|
|
005 Applying the AVERAGEIF function_en.vtt
|
VTT
|
1.8 KB
|
|
|
005 Data Types in Excel.mp4
|
MP4
|
68.8 MB
|
|
|
005 Data Types in Excel_en.vtt
|
VTT
|
5 KB
|
|
|
005 Exercise on Filters.mp4
|
MP4
|
49.3 MB
|
|
|
005 Exercise on Filters_en.vtt
|
VTT
|
2.4 KB
|
|
|
005 Exercise on Text Functions.mp4
|
MP4
|
66.6 MB
|
|
|
005 Exercise on Text Functions_en.vtt
|
VTT
|
3.2 KB
|
|
|
005 Finding the Missing values in data.mp4
|
MP4
|
35.1 MB
|
|
|
005 Finding the Missing values in data_en.vtt
|
VTT
|
1.7 KB
|
|
|
005 Formatting dashboards.mp4
|
MP4
|
27.9 MB
|
|
|
005 Formatting dashboards_en.vtt
|
VTT
|
1.8 KB
|
|
|
005 Solution on Conditional Formatting.mp4
|
MP4
|
52.1 MB
|
|
|
005 Solution on Conditional Formatting_en.vtt
|
VTT
|
4.1 KB
|
|
|
005 Solution on Index and Match Functions.mp4
|
MP4
|
70.4 MB
|
|
|
005 Solution on Index and Match Functions_en.vtt
|
VTT
|
6.3 KB
|
|
|
005 Solution on Lookup Functions.mp4
|
MP4
|
49.4 MB
|
|
|
005 Solution on Lookup Functions_en.vtt
|
VTT
|
4.4 KB
|
|
|
005 Solution on Pivot Tables.mp4
|
MP4
|
48.1 MB
|
|
|
005 Solution on Pivot Tables_en.vtt
|
VTT
|
3.9 KB
|
|
|
006 Quiz Solution.mp4
|
MP4
|
39.2 MB
|
|
|
006 Quiz Solution_en.vtt
|
VTT
|
3 KB
|
|
|
006 Solution on Filters.mp4
|
MP4
|
54.8 MB
|
|
|
006 Solution on Filters_en.vtt
|
VTT
|
3.8 KB
|
|
|
006 Solution on Text Functions.mp4
|
MP4
|
63.7 MB
|
|
|
006 Solution on Text Functions_en.vtt
|
VTT
|
5.6 KB
|
|
|
007 Exercise on Data Visualizations.mp4
|
MP4
|
57.3 MB
|
|
|
007 Exercise on Data Visualizations_en.vtt
|
VTT
|
2.7 KB
|
|
|
007 Exercise on Descriptive Statistics.mp4
|
MP4
|
61.3 MB
|
|
|
007 Exercise on Descriptive Statistics_en.vtt
|
VTT
|
2.9 KB
|
|
|
007 Exercise on Logical Functions.mp4
|
MP4
|
67.6 MB
|
|
|
007 Exercise on Logical Functions_en.vtt
|
VTT
|
3.5 KB
|
|
|
008 Solution on Data Visualizations.mp4
|
MP4
|
47.1 MB
|
|
|
008 Solution on Data Visualizations_en.vtt
|
VTT
|
3.7 KB
|
|
|
008 Solution on Descriptive Statistics.mp4
|
MP4
|
58 MB
|
|
|
008 Solution on Descriptive Statistics_en.vtt
|
VTT
|
4.4 KB
|
|
|
008 Solution on Logical Functions.mp4
|
MP4
|
60.5 MB
|
|
|
008 Solution on Logical Functions_en.vtt
|
VTT
|
6.6 KB
|
|
|
009 Exercise on Dashboards.mp4
|
MP4
|
39.5 MB
|
|
|
009 Exercise on Dashboards_en.vtt
|
VTT
|
1.8 KB
|
|
|
009 Exercise on Data Cleaning.mp4
|
MP4
|
54 MB
|
|
|
009 Exercise on Data Cleaning_en.vtt
|
VTT
|
2.7 KB
|
|
|
010 Solution on Dashboards.mp4
|
MP4
|
62.1 MB
|
|
|
010 Solution on Dashboards_en.vtt
|
VTT
|
5.6 KB
|
|
|
010 Solution on Data Cleaning.mp4
|
MP4
|
76.1 MB
|
|
|
010 Solution on Data Cleaning_en.vtt
|
VTT
|
6.6 KB
|
|
|
37036824-pivot-3.xlsx
|
XLSX
|
16.2 KB
|
|
|
37036832-Pivot-charts.xlsx
|
XLSX
|
278.3 KB
|
|
|
37036996-Exercises-on-dashboard-and-visualization.xlsx
|
XLSX
|
278.3 KB
|
|
|
37037008-pivot-exercise.xlsx
|
XLSX
|
32.6 KB
|
|
|
37037012-pivot2.xlsx
|
XLSX
|
10.8 KB
|
|
|
37037146-pivot-3.xlsx
|
XLSX
|
16.2 KB
|
|
|
37037286-Exercises-on-Index-and-match.xlsx
|
XLSX
|
9 KB
|
|
|
37037298-vlookup.xlsx
|
XLSX
|
10.6 KB
|
|
|
37037310-vlookup-2.xlsx
|
XLSX
|
10.4 KB
|
|
|
37037326-logical-data.xlsx
|
XLSX
|
10.5 KB
|
|
|
37037346-logicalData.xlsx
|
XLSX
|
10.5 KB
|
|
|
37037350-exams.xlsx
|
XLSX
|
65.6 KB
|
|
|
37037462-exams.xlsx
|
XLSX
|
65.6 KB
|
|
|
37037484-exams.xlsx
|
XLSX
|
65.6 KB
|
|
|
37037664-market-fact.csv
|
CSV
|
605.3 KB
|
|
|
Bonus Resources.txt
|
TXT
|
307.2 B
|
|
|
Excel_Example.xls
|
XLS
|
157 KB
|
|
|
Exercises on Conditional formatting.docx
|
DOCX
|
686.8 KB
|
|
|
Exercises on Data cleaning.docx
|
DOCX
|
325.6 KB
|
|
|
Exercises on Descriptive statistics.docx
|
DOCX
|
188.3 KB
|
|
|
Exercises on Filters.docx
|
DOCX
|
15.5 KB
|
|
|
Exercises on Index and match function.docx
|
DOCX
|
276 KB
|
|
|
Exercises on Logical function.docx
|
DOCX
|
258.8 KB
|
|
|
Exercises on Pivot table.docx
|
DOCX
|
314.8 KB
|
|
|
Exercises on dashboard and visualization.xlsx
|
XLSX
|
278.3 KB
|
|
|
Exercises on lookups.docx
|
DOCX
|
240.2 KB
|
|
|
Exercises on text function.docx
|
DOCX
|
403.6 KB
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
MOCK_DATA.xlsx
|
XLSX
|
25.5 KB
|
|
|
Orders_data.xlsx
|
XLSX
|
1.5 MB
|
|
|
Salary_Data.xls
|
XLS
|
20.5 KB
|
|
|
What if Analysis.xlsx
|
XLSX
|
15.1 KB
|
|
|
market_fact.csv
|
CSV
|
605.3 KB
|
