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 |