Filename Size 0. Formatting/0. Create Custom Number Formats.mp4 12.6 MB 0. Formatting/0. Create Custom Number Formats.srt 8.5 KB 0. Formatting/1. Apply International Currency Formats.mp4 8.5 MB 0. Formatting/1. Apply International Currency Formats.srt 3.9 KB 0. Formatting/2. Display Data in Multiple International Formats.mp4 7.6 MB 0. Formatting/2. Display Data in Multiple International Formats.srt 4.4 KB 1. Working with Data/0. Outline Data.mp4 37.5 MB 1. Working with Data/0. Outline Data.srt 5.8 KB 1. Working with Data/1. Insert Subtotals.mp4 22 MB 1. Working with Data/1. Insert Subtotals.srt 4.4 KB 1. Working with Data/2. Insert References.mp4 11.5 MB 1. Working with Data/2. Insert References.srt 5.7 KB 1. Working with Data/3. Reference Data in Another Workbook.mp4 9 MB 1. Working with Data/3. Reference Data in Another Workbook.srt 4.4 KB 1. Working with Data/4. Reference Data by Using Structured References.mp4 8.3 MB 1. Working with Data/4. Reference Data by Using Structured References.srt 4.9 KB 1. Working with Data/5. Consolidate Data.mp4 14.9 MB 1. Working with Data/5. Consolidate Data.srt 5.9 KB 1. Working with Data/6. Configure Data Validation.mp4 14.1 MB 1. Working with Data/6. Configure Data Validation.srt 8.4 KB 10. Advanced Options/0. Display Hidden Ribbon Tabs.mp4 18 MB 10. Advanced Options/0. Display Hidden Ribbon Tabs.srt 8.2 KB 10. Advanced Options/1. Configure Formula Calculation Options.mp4 13 MB 10. Advanced Options/1. Configure Formula Calculation Options.srt 6.3 KB 11. Finalizing a Workbook/0. Inspect a Workbook for Hidden Properties or Personal Information.mp4 13.1 MB 11. Finalizing a Workbook/0. Inspect a Workbook for Hidden Properties or Personal Information.srt 6.5 KB 11. Finalizing a Workbook/1. Inspect a Workbook for Accessibility Issues.mp4 13.5 MB 11. Finalizing a Workbook/1. Inspect a Workbook for Accessibility Issues.srt 5 KB 11. Finalizing a Workbook/2. Inspect a Workbook for Compatibility Issues.mp4 12.7 MB 11. Finalizing a Workbook/2. Inspect a Workbook for Compatibility Issues.srt 5.1 KB 11. Finalizing a Workbook/3. Restrict Editing.mp4 17.3 MB 11. Finalizing a Workbook/3. Restrict Editing.srt 7 KB 11. Finalizing a Workbook/4. Protect Workbook Structure.mp4 9 MB 11. Finalizing a Workbook/4. Protect Workbook Structure.srt 3.6 KB 11. Finalizing a Workbook/5. Encrypt a Workbook with a Password.mp4 5.5 MB 11. Finalizing a Workbook/5. Encrypt a Workbook with a Password.srt 2.8 KB 11. Finalizing a Workbook/6. Manage Workbook Versions.mp4 8.7 MB 11. Finalizing a Workbook/6. Manage Workbook Versions.srt 4.5 KB 12. Macros/0. Create a Simple Macro.mp4 19.2 MB 12. Macros/0. Create a Simple Macro.srt 8.9 KB 12. Macros/1. Modify a Simple Macro.mp4 8.9 MB 12. Macros/1. Modify a Simple Macro.srt 3.4 KB 12. Macros/2. Save and Enable Macros in a Workbook.mp4 7.4 MB 12. Macros/2. Save and Enable Macros in a Workbook.srt 3.4 KB 12. Macros/3. Copy Macros Between Workbooks.mp4 11.3 MB 12. Macros/3. Copy Macros Between Workbooks.srt 4 KB 12. Macros/4. Create a Macro Button.mp4 6.5 MB 12. Macros/4. Create a Macro Button.srt 1.8 KB 13. Form Controls/0. Insert and Configure Form Controls.mp4 15.3 MB 13. Form Controls/0. Insert and Configure Form Controls.srt 9.9 KB 2. Power Query/0. Import, Transform, and Connect to Data.mp4 29.3 MB 2. Power Query/0. Import, Transform, and Connect to Data.srt 14.1 KB 2. Power Query/1. Combine and Display Data.mp4 20.5 MB 2. Power Query/1. Combine and Display Data.srt 10 KB 3. Text Functions/0. Format Text by Using RIGHT, LEFT, and MID Functions.mp4 15.3 MB 3. Text Functions/0. Format Text by Using RIGHT, LEFT, and MID Functions.srt 4.6 KB 3. Text Functions/1. Format Text by Using UPPER, LOWER, and PROPER Functions.mp4 13.3 MB 3. Text Functions/1. Format Text by Using UPPER, LOWER, and PROPER Functions.srt 3.6 KB 3. Text Functions/2. Format Text by Using the CONCAT Function.mp4 11.8 MB 3. Text Functions/2. Format Text by Using the CONCAT Function.srt 3.4 KB 4. Logical and Statistical Functions/0. Perform Logical Operations by Using the IF Function.mp4 7.8 MB 4. Logical and Statistical Functions/0. Perform Logical Operations by Using the IF Function.srt 3.3 KB 4. Logical and Statistical Functions/1. Perform Logical Operations by Using the SUMIF Function.mp4 18.3 MB 4. Logical and Statistical Functions/1. Perform Logical Operations by Using the SUMIF Function.srt 6.5 KB 4. Logical and Statistical Functions/2. Perform Logical Operations by Using the AVERAGEIF Function.mp4 17.1 MB 4. Logical and Statistical Functions/2. Perform Logical Operations by Using the AVERAGEIF Function.srt 5.7 KB 4. Logical and Statistical Functions/3. Perform Statistical Operations by Using the COUNTIF Function.mp4 5.1 MB 4. Logical and Statistical Functions/3. Perform Statistical Operations by Using the COUNTIF Function.srt 2 KB 4. Logical and Statistical Functions/4. Perform Statistical Operations by Using the SUMIFS Function.mp4 17.5 MB 4. Logical and Statistical Functions/4. Perform Statistical Operations by Using the SUMIFS Function.srt 6.2 KB 4. Logical and Statistical Functions/5. Perform Statistical Operations by Using the AVERAGEIFS Function.mp4 14.4 MB 4. Logical and Statistical Functions/5. Perform Statistical Operations by Using the AVERAGEIFS Function.srt 4.5 KB 4. Logical and Statistical Functions/6. Perform Statistical Operations by Using the COUNTIFS Function.mp4 12.2 MB 4. Logical and Statistical Functions/6. Perform Statistical Operations by Using the COUNTIFS Function.srt 3.2 KB 4. Logical and Statistical Functions/7. Perform Logical Operations by Using AND, OR, and NOT Functions.mp4 13.5 MB 4. Logical and Statistical Functions/7. Perform Logical Operations by Using AND, OR, and NOT Functions.srt 4.9 KB 4. Logical and Statistical Functions/8. Perform Logical Operations by Using Nested Functions.mp4 18.5 MB 4. Logical and Statistical Functions/8. Perform Logical Operations by Using Nested Functions.srt 9.8 KB 5. Expanded Functions/0. Reference the Date and Time by Using the NOW and TODAY Functions.mp4 15.9 MB 5. Expanded Functions/0. Reference the Date and Time by Using the NOW and TODAY Functions.srt 9.5 KB 5. Expanded Functions/1. Serialize Numbers by Using DATE and TIME Functions.mp4 18.9 MB 5. Expanded Functions/1. Serialize Numbers by Using DATE and TIME Functions.srt 8.5 KB 5. Expanded Functions/2. Perform What-if Analysis by Using Goal Seek.mp4 9 MB 5. Expanded Functions/2. Perform What-if Analysis by Using Goal Seek.srt 5.9 KB 5. Expanded Functions/3. Perform What-if Analysis by Using Scenario Manager.mp4 21.7 MB 5. Expanded Functions/3. Perform What-if Analysis by Using Scenario Manager.srt 11 KB 5. Expanded Functions/4. Calculate Data by Using Financial Functions- PMT.mp4 8.5 MB 5. Expanded Functions/4. Calculate Data by Using Financial Functions- PMT.srt 5.2 KB 5. Expanded Functions/5. Calculate Data by Using Financial Functions- PPMT & IPMT.mp4 22.2 MB 5. Expanded Functions/5. Calculate Data by Using Financial Functions- PPMT & IPMT.srt 12.5 KB 5. Expanded Functions/6. Calculate Data by Using Financial Functions- FV.mp4 11.3 MB 5. Expanded Functions/6. Calculate Data by Using Financial Functions- FV.srt 6 KB 6. Error Checking/0. Display Formulas.mp4 9.7 MB 6. Error Checking/0. Display Formulas.srt 2.8 KB 6. Error Checking/1. Trace Precedence and Dependence.mp4 16.1 MB 6. Error Checking/1. Trace Precedence and Dependence.srt 6.7 KB 6. Error Checking/2. Evaluate Formulas.mp4 7.7 MB 6. Error Checking/2. Evaluate Formulas.srt 3.4 KB 6. Error Checking/3. Validate Formulas by Using Error Checking Rules.mp4 24.9 MB