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