Filename | Size |
| 0. Websites you may like/How you can help Team-FTU.txt | 229 B |
| 1. Getting Started/1. Greetings.mp4 | 17.3 MB |
| 1. Getting Started/1. Greetings.vtt | 2 KB |
| 1. Getting Started/2. MS Excel for data analysis.mp4 | 16.4 MB |
| 1. Getting Started/2. MS Excel for data analysis.vtt | 1.9 KB |
| 1. Getting Started/3. Download the Working Data.html | 49 B |
| 1. Getting Started/3.1 Working data_clean.xlsx.xlsx | 6.3 MB |
| 10. Final Tricks/1. Protect Worksheet and Workbook.mp4 | 41.1 MB |
| 10. Final Tricks/1. Protect Worksheet and Workbook.vtt | 3 KB |
| 10. Final Tricks/2. Hot Shortcuts for Working in Excel.html | 72 B |
| 10. Final Tricks/2.1 The list of hot keys in Excel.docx.docx | 15 KB |
| 10. Final Tricks/3. Wrapping Up.mp4 | 7.6 MB |
| 10. Final Tricks/3. Wrapping Up.vtt | 1012 B |
| 11. Your Special Bonus!/1. Introduction to Power Add-ins in Excel.mp4 | 27.2 MB |
| 11. Your Special Bonus!/1. Introduction to Power Add-ins in Excel.vtt | 2.2 KB |
| 11. Your Special Bonus!/2. Bonus Coupon of My Next Course!.html | 188 B |
| 2. Cleaning and Preparing Tools/1. Introduction to the Task.mp4 | 26.4 MB |
| 2. Cleaning and Preparing Tools/1. Introduction to the Task.vtt | 2.6 KB |
| 2. Cleaning and Preparing Tools/2. Sort and Filter.mp4 | 95.4 MB |
| 2. Cleaning and Preparing Tools/2. Sort and Filter.vtt | 6 KB |
| 2. Cleaning and Preparing Tools/3. Text to Columns.mp4 | 71.4 MB |
| 2. Cleaning and Preparing Tools/3. Text to Columns.vtt | 4.3 KB |
| 2. Cleaning and Preparing Tools/4. Remove Duplicates.mp4 | 61.2 MB |
| 2. Cleaning and Preparing Tools/4. Remove Duplicates.vtt | 3.5 KB |
| 2. Cleaning and Preparing Tools/5. Data Validation.mp4 | 102.7 MB |
| 2. Cleaning and Preparing Tools/5. Data Validation.vtt | 5.5 KB |
| 2. Cleaning and Preparing Tools/5.1 Data Validation.xlsx.xlsx | 15.4 KB |
| 2. Cleaning and Preparing Tools/6. Find, Replace, Go to.mp4 | 56.4 MB |
| 2. Cleaning and Preparing Tools/6. Find, Replace, Go to.vtt | 2.9 KB |
| 2. Cleaning and Preparing Tools/7. Data Entry Form.mp4 | 32.5 MB |
| 2. Cleaning and Preparing Tools/7. Data Entry Form.vtt | 2.2 KB |
| 2. Cleaning and Preparing Tools/8. Quiz 1.html | 146 B |
| 3. 50 Most Frequently Used Functions/1. Logical Functions IF, AND, OR.mp4 | 140.7 MB |
| 3. 50 Most Frequently Used Functions/1. Logical Functions IF, AND, OR.vtt | 5.4 KB |
| 3. 50 Most Frequently Used Functions/2. SUBTOTAL vs SUM.mp4 | 89.1 MB |
| 3. 50 Most Frequently Used Functions/2. SUBTOTAL vs SUM.vtt | 4.1 KB |
| 3. 50 Most Frequently Used Functions/3. Text Fuctions RIGHT, LEFT, LEN, CONCATENATE, UPPER, LOWER.mp4 | 122.4 MB |
| 3. 50 Most Frequently Used Functions/3. Text Fuctions RIGHT, LEFT, LEN, CONCATENATE, UPPER, LOWER.vtt | 5.2 KB |
| 3. 50 Most Frequently Used Functions/4. Date Functions YEAR, MONTH, DAY, EOMONTH, DATE.mp4 | 63.7 MB |
| 3. 50 Most Frequently Used Functions/4. Date Functions YEAR, MONTH, DAY, EOMONTH, DATE.vtt | 3.8 KB |
| 3. 50 Most Frequently Used Functions/5. Math Functions SUMIF, COUNTIF, SUMIFS, COUNTIFS.mp4 | 116.8 MB |
| 3. 50 Most Frequently Used Functions/6. Statistical Functions MAX, MIN, MEAN, MEDIAN, MODE, VAR, StdDev, CORREL.mp4 | 99.9 MB |
| 3. 50 Most Frequently Used Functions/6. Statistical Functions MAX, MIN, MEAN, MEDIAN, MODE, VAR, StdDev, CORREL.vtt | 6.7 KB |
| 3. 50 Most Frequently Used Functions/7. Financial Functions PMT, PV, RATE, NPER, NPV, IRR.mp4 | 63.1 MB |
| 3. 50 Most Frequently Used Functions/7. Financial Functions PMT, PV, RATE, NPER, NPV, IRR.vtt | 5.7 KB |
| 3. 50 Most Frequently Used Functions/7.1 Financial Analysis.xlsx.xlsx | 13.1 KB |
| 3. 50 Most Frequently Used Functions/8. Quiz 2.html | 146 B |
| 4. PivotTable for Data Analysis/1. Introduction to PivotTable.mp4 | 86.4 MB |
| 4. PivotTable for Data Analysis/1. Introduction to PivotTable.vtt | 5.8 KB |
| 4. PivotTable for Data Analysis/2. Calculations by PivotTable.mp4 | 141.2 MB |
| 4. PivotTable for Data Analysis/2. Calculations by PivotTable.vtt | 7.9 KB |
| 4. PivotTable for Data Analysis/3. GetPivotData.mp4 | 32.7 MB |
| 5. What-If Analysis/1. What-If Analysis Goal Seek.mp4 | 93.5 MB |
| 5. What-If Analysis/1. What-If Analysis Goal Seek.vtt | 6 KB |
| 5. What-If Analysis/2. What-If Analysis Data Table.mp4 | 41.7 MB |
| 5. What-If Analysis/2. What-If Analysis Data Table.vtt | 4.8 KB |
| 5. What-If Analysis/2.1 Data Table.xlsx.xlsx | 11.6 KB |
| 5. What-If Analysis/3. What-If Analysis Scenario Manager.mp4 | 44.8 MB |
| 5. What-If Analysis/3. What-If Analysis Scenario Manager.vtt | 3.8 KB |
| 5. What-If Analysis/4. Auditing Formulas.mp4 | 17.7 MB |
| 5. What-If Analysis/4. Auditing Formulas.vtt | 1.9 KB |
| 5. What-If Analysis/5. Quiz 3.html | 146 B |
| 6. Merging Techniques/1. VLOOKUP With Exact Match.mp4 | 101.5 MB |
| 6. Merging Techniques/1. VLOOKUP With Exact Match.vtt | 6.2 KB |
| 6. Merging Techniques/2. INDEX and MATCH vs VLOOKUP.mp4 | 91.6 MB |
| 6. Merging Techniques/2. INDEX and MATCH vs VLOOKUP.vtt | 5.7 KB |
| 6. Merging Techniques/3. VLOOKUP With Approximate Match.mp4 | 68 MB |
| 6. Merging Techniques/3. VLOOKUP With Approximate Match.vtt | 3.1 KB |
| 7. Smart and Interactive Tables/1. Format as Table.mp4 | 36.7 MB |
| 7. Smart and Interactive Tables/1. Format as Table.vtt | 2.4 KB |
| 7. Smart and Interactive Tables/2. Data Model.mp4 | 47.7 MB |
| 7. Smart and Interactive Tables/2. Data Model.vtt | 4.1 KB |
| 7. Smart and Interactive Tables/3. Slicer.mp4 | 36.1 MB |
| 7. Smart and Interactive Tables/4. Quiz 4.html | 146 B |
| 8. Visualizing Data/1. Conditional Formatting.mp4 | 70.2 MB |
| 8. Visualizing Data/1. Conditional Formatting.vtt | 4.7 KB |
| 8. Visualizing Data/10. Creation of the Interactive Dashboard.mp4 | 35.2 MB |
| 8. Visualizing Data/10. Creation of the Interactive Dashboard.vtt | 2.8 KB |
| 8. Visualizing Data/11. Presenting of the Final Results.mp4 | 33.7 MB |
| 8. Visualizing Data/11. Presenting of the Final Results.vtt | 3 KB |
| 8. Visualizing Data/12. Download the Completed File.html | 51 B |
| 8. Visualizing Data/12.1 Working data_complete.xlsx.xlsx | 17.8 MB |
| 8. Visualizing Data/13. Quiz 5.html | 146 B |
| 8. Visualizing Data/2. Sparklines as Mini Charts.mp4 | 35.1 MB |
| 8. Visualizing Data/2. Sparklines as Mini Charts.vtt | 2.4 KB |
| 8. Visualizing Data/3. Column Chart and Bar Chart.mp4 | 55 MB |
| 8. Visualizing Data/3. Column Chart and Bar Chart.vtt | 4.5 KB |
| 8. Visualizing Data/4. Line Chart.mp4 | 29.1 MB |
| 8. Visualizing Data/4. Line Chart.vtt | 1.9 KB |
| 8. Visualizing Data/5. Pie Chart.mp4 | 18.4 MB |
| 8. Visualizing Data/5. Pie Chart.vtt | 1.9 KB |
| 8. Visualizing Data/6. Area Chart.mp4 | 19.6 MB |
| 8. Visualizing Data/6. Area Chart.vtt | 1.5 KB |
| 8. Visualizing Data/7. Combo Charts.mp4 | 37.7 MB |