Filename Size 1. Introduction/1. Introduction.mp4 18 MB 1. Introduction/1. Introduction.vtt 2.9 KB 1. Introduction/1.1 Introduction_01.pdf.pdf 905.1 KB 1. Introduction/2. Setting Expectations.mp4 10 MB 1. Introduction/2. Setting Expectations.vtt 2.5 KB 10. Macros/1. Macros.mp4 80.2 MB 10. Macros/1. Macros.vtt 11.1 KB 10. Macros/1.1 Lecture_12_Macro.xlsx.xlsx 13.5 KB 10. Macros/2. Exercise 1212 Macros.html 276 B 10. Macros/2.1 Session12_Solution.xlsm.xlsm 23.6 KB 10. Macros/2.2 Session12_Exercise.xlsx.xlsx 13.6 KB 11. Bonus Lectures/1. Waterfall chart.mp4 95.6 MB 11. Bonus Lectures/1. Waterfall chart.vtt 11.7 KB 11. Bonus Lectures/1.1 Lecture_14_Ex_Waterfall.xlsx.xlsx 30.5 KB 11. Bonus Lectures/2. Infographics 1 Cool charts.mp4 149 MB 11. Bonus Lectures/2. Infographics 1 Cool charts.vtt 11.8 KB 11. Bonus Lectures/2.1 Lecture_15_Infographics.xlsx.xlsx 335.8 KB 11. Bonus Lectures/3. Infographics 2 Cool charts.mp4 46.2 MB 11. Bonus Lectures/3. Infographics 2 Cool charts.vtt 6.6 KB 11. Bonus Lectures/3.1 Lecture_16_Infographics.xlsx.xlsx 295.5 KB 11. Bonus Lectures/4. Income Tax calculation - Slabs based tax.html 509 B 11. Bonus Lectures/5. Other Resourses for Data Analytics Journey.html 2.7 KB 11. Bonus Lectures/6. Excel Practice test.html 159 B 11. Bonus Lectures/7. Course Conclusion.html 932 B 11. Bonus Lectures/8. Bonus Lecture.html 1.7 KB 2. Essential Formulas/1. Mathematical Functions.mp4 57.5 MB 2. Essential Formulas/1. Mathematical Functions.vtt 5.7 KB 2. Essential Formulas/1.1 Lecture_1.xlsx.xlsx 31.9 KB 2. Essential Formulas/2. Exercise 112 Mathematical Formulas.html 336 B 2. Essential Formulas/2.1 Session1_Exercise.xlsx.xlsx 64.3 KB 2. Essential Formulas/2.2 Session1_Solution.xlsx.xlsx 111.9 KB 2. Essential Formulas/3. Textual Formulas.mp4 67.7 MB 2. Essential Formulas/3. Textual Formulas.vtt 7.1 KB 2. Essential Formulas/3.1 Lecture_2.xlsx.xlsx 28 KB 2. Essential Formulas/4. Exercise 212 Textual Formulas.html 300 B 2. Essential Formulas/4.1 Session2_Solution.xlsx.xlsx 122.8 KB 2. Essential Formulas/4.2 Session2_Exercise.xlsx.xlsx 66.2 KB 2. Essential Formulas/5. Logical Formulas.mp4 98.3 MB 2. Essential Formulas/5. Logical Formulas.vtt 9.1 KB 2. Essential Formulas/5.1 Lecture_3_logical.xlsx.xlsx 23.8 KB 2. Essential Formulas/6. Exercise 312 Logical Formulas.html 355 B 2. Essential Formulas/6.1 Session3_Exercise.xlsx.xlsx 49.2 KB 2. Essential Formulas/6.2 Session3_Solution.xlsx.xlsx 73.5 KB 2. Essential Formulas/7. Date-time (Temporal) Formulas.mp4 59.9 MB 2. Essential Formulas/7. Date-time (Temporal) Formulas.vtt 6.6 KB 2. Essential Formulas/7.1 Lecture_4_Dates.xlsx.xlsx 19.5 KB 2. Essential Formulas/8. Exercise 412 Date-Time Formulas.html 260 B 2. Essential Formulas/8.1 Session4_Exercise.xlsx.xlsx 51.2 KB 2. Essential Formulas/8.2 Session4_Solution.xlsx.xlsx 59.4 KB 2. Essential Formulas/9. Quiz 1.html 159 B 3. Lookup Formulas/1. Lookup Formulas.mp4 79.3 MB 3. Lookup Formulas/1. Lookup Formulas.vtt 9.1 KB 3. Lookup Formulas/1.1 Lecture_5_Lookups.xlsx.xlsx 25.5 KB 3. Lookup Formulas/2. Exercise 512 Lookup Formulas.html 260 B 3. Lookup Formulas/2.1 Session5_Solution.xlsx.xlsx 421.6 KB 3. Lookup Formulas/2.2 Session5_Exercise.xlsx.xlsx 272.3 KB 4. Data Tools/1. Data Tools.mp4 158.2 MB 4. Data Tools/1. Data Tools.vtt 19.4 KB 4. Data Tools/1.1 Lecture_6_Data.xlsx.xlsx 23.1 KB 4. Data Tools/2. Exercise 612 Data Tools.html 311 B 4. Data Tools/2.1 Session6_Solution.xlsx.xlsx 3.6 MB 4. Data Tools/2.2 Session6_Exercise.xlsx.xlsx 849.4 KB 4. Data Tools/3. Quiz 2.html 159 B 5. Formatting data and tables/1. Formatting data and tables.mp4 201.8 MB 5. Formatting data and tables/1. Formatting data and tables.vtt 19 KB 5. Formatting data and tables/1.1 Lecture_6_Formatting.xlsx.xlsx 14.9 KB 5. Formatting data and tables/2. Exercise 712 Formatting.html 268 B 5. Formatting data and tables/2.1 Session7_Exercise.xlsx.xlsx 13.5 KB 5. Formatting data and tables/2.2 Session7_Solution.xlsx.xlsx 14.1 KB 6. Pivot Tables/1. Pivot Tables.mp4 90.6 MB 6. Pivot Tables/1. Pivot Tables.vtt 9.1 KB 6. Pivot Tables/1.1 Lecture_8_PivotTables.xlsx.xlsx 103.4 KB 6. Pivot Tables/2. Exercise 812 Pivot tables.html 234 B 6. Pivot Tables/2.1 Session8_Solution.xlsx.xlsx 294.5 KB 6. Pivot Tables/2.2 Session8_Exercise.xlsx.xlsx 173.7 KB 7. Charts/1. Charts-Part 1.mp4 92.3 MB 7. Charts/1. Charts-Part 1.vtt 12.5 KB 7. Charts/2. Charts-Part 2.mp4 110.9 MB 7. Charts/2. Charts-Part 2.vtt 13.5 KB 7. Charts/2.1 Lecture_9_Charts.xlsx.xlsx 162.2 KB 7. Charts/3. Exercise 912 Charts.html 301 B 7. Charts/3.1 Session9_Exercise.xlsx.xlsx 25.8 KB 7. Charts/3.2 Session9_Solution.xlsx.xlsx 67.7 KB 8. Excel Shortcuts/1. Excel Shortcuts.mp4 134.6 MB 8. Excel Shortcuts/1. Excel Shortcuts.vtt 14.2 KB 8. Excel Shortcuts/1.1 Lecture_10_Shortcuts.xlsx.xlsx 21.4 KB 8. Excel Shortcuts/2. Exercise 1012 Shortcuts.html 274 B 8. Excel Shortcuts/2.1 Session10_Exercise.xlsx.xlsx 8.5 MB 8. Excel Shortcuts/2.2 Session10_Solution.xlsx.xlsx 8.5 MB 9. Analytics in Excel/1. Analytics in Excel.mp4 138.8 MB 9. Analytics in Excel/1. Analytics in Excel.vtt 17.5 KB 9. Analytics in Excel/1.1 Lecture_11_Advance_Analytics.xlsx.xlsx 20.9 KB 9. Analytics in Excel/2. Exercise 1112 Analytics.html 291 B 9. Analytics in Excel/2.1 Session11_Solution.xlsx.xlsx 23.5 KB 9. Analytics in Excel/2.2 Session11_Exercise.xlsx.xlsx 16.8 KB 9. Analytics in Excel/3. Quiz 3.html 159 B