Pluralsight - Excel 2019 Pro by Bill Kulterman
File List
| File | Size |
|---|---|
| 0. Formatting/0. Create Custom Number Formats.mp4 | 12.61 MB |
| 0. Formatting/0. Create Custom Number Formats.srt | 8.48 KB |
| 0. Formatting/1. Apply International Currency Formats.mp4 | 8.47 MB |
| 0. Formatting/1. Apply International Currency Formats.srt | 3.95 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.39 KB |
| 1. Working with Data/0. Outline Data.mp4 | 37.46 MB |
| 1. Working with Data/0. Outline Data.srt | 5.84 KB |
| 1. Working with Data/1. Insert Subtotals.mp4 | 21.99 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.74 KB |
| 1. Working with Data/3. Reference Data in Another Workbook.mp4 | 9.01 MB |
| 1. Working with Data/3. Reference Data in Another Workbook.srt | 4.44 KB |
| 1. Working with Data/4. Reference Data by Using Structured References.mp4 | 8.34 MB |
| 1. Working with Data/4. Reference Data by Using Structured References.srt | 4.92 KB |
| 1. Working with Data/5. Consolidate Data.mp4 | 14.9 MB |
| 1. Working with Data/5. Consolidate Data.srt | 5.86 KB |
| 1. Working with Data/6. Configure Data Validation.mp4 | 14.08 MB |
| 1. Working with Data/6. Configure Data Validation.srt | 8.39 KB |
| 10. Advanced Options/0. Display Hidden Ribbon Tabs.mp4 | 18.02 MB |
| 10. Advanced Options/0. Display Hidden Ribbon Tabs.srt | 8.16 KB |
| 10. Advanced Options/1. Configure Formula Calculation Options.mp4 | 13 MB |
| 10. Advanced Options/1. Configure Formula Calculation Options.srt | 6.34 KB |
| 11. Finalizing a Workbook/0. Inspect a Workbook for Hidden Properties or Personal Information.mp4 | 13.08 MB |
| 11. Finalizing a Workbook/0. Inspect a Workbook for Hidden Properties or Personal Information.srt | 6.47 KB |
| 11. Finalizing a Workbook/1. Inspect a Workbook for Accessibility Issues.mp4 | 13.52 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.74 MB |
| 11. Finalizing a Workbook/2. Inspect a Workbook for Compatibility Issues.srt | 5.14 KB |
| 11. Finalizing a Workbook/3. Restrict Editing.mp4 | 17.28 MB |
| 11. Finalizing a Workbook/3. Restrict Editing.srt | 6.95 KB |
| 11. Finalizing a Workbook/4. Protect Workbook Structure.mp4 | 9.03 MB |
| 11. Finalizing a Workbook/4. Protect Workbook Structure.srt | 3.59 KB |
| 11. Finalizing a Workbook/5. Encrypt a Workbook with a Password.mp4 | 5.54 MB |
| 11. Finalizing a Workbook/5. Encrypt a Workbook with a Password.srt | 2.76 KB |
| 11. Finalizing a Workbook/6. Manage Workbook Versions.mp4 | 8.73 MB |
| 11. Finalizing a Workbook/6. Manage Workbook Versions.srt | 4.52 KB |
| 12. Macros/0. Create a Simple Macro.mp4 | 19.16 MB |
| 12. Macros/0. Create a Simple Macro.srt | 8.92 KB |
| 12. Macros/1. Modify a Simple Macro.mp4 | 8.87 MB |
| 12. Macros/1. Modify a Simple Macro.srt | 3.44 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.38 KB |
| 12. Macros/3. Copy Macros Between Workbooks.mp4 | 11.28 MB |
| 12. Macros/3. Copy Macros Between Workbooks.srt | 4.01 KB |
| 12. Macros/4. Create a Macro Button.mp4 | 6.47 MB |
| 12. Macros/4. Create a Macro Button.srt | 1.79 KB |
| 13. Form Controls/0. Insert and Configure Form Controls.mp4 | 15.35 MB |
| 13. Form Controls/0. Insert and Configure Form Controls.srt | 9.92 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.14 KB |
| 2. Power Query/1. Combine and Display Data.mp4 | 20.5 MB |
| 2. Power Query/1. Combine and Display Data.srt | 9.97 KB |
| 3. Text Functions/0. Format Text by Using RIGHT, LEFT, and MID Functions.mp4 | 15.26 MB |
| 3. Text Functions/0. Format Text by Using RIGHT, LEFT, and MID Functions.srt | 4.56 KB |
| 3. Text Functions/1. Format Text by Using UPPER, LOWER, and PROPER Functions.mp4 | 13.31 MB |
| 3. Text Functions/1. Format Text by Using UPPER, LOWER, and PROPER Functions.srt | 3.61 KB |
| 3. Text Functions/2. Format Text by Using the CONCAT Function.mp4 | 11.84 MB |
| 3. Text Functions/2. Format Text by Using the CONCAT Function.srt | 3.39 KB |
| 4. Logical and Statistical Functions/0. Perform Logical Operations by Using the IF Function.mp4 | 7.76 MB |
| 4. Logical and Statistical Functions/0. Perform Logical Operations by Using the IF Function.srt | 3.34 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.49 KB |
| 4. Logical and Statistical Functions/2. Perform Logical Operations by Using the AVERAGEIF Function.mp4 | 17.06 MB |
| 4. Logical and Statistical Functions/2. Perform Logical Operations by Using the AVERAGEIF Function.srt | 5.73 KB |
| 4. Logical and Statistical Functions/3. Perform Statistical Operations by Using the COUNTIF Function.mp4 | 5.12 MB |
| 4. Logical and Statistical Functions/3. Perform Statistical Operations by Using the COUNTIF Function.srt | 2.01 KB |
| 4. Logical and Statistical Functions/4. Perform Statistical Operations by Using the SUMIFS Function.mp4 | 17.54 MB |
| 4. Logical and Statistical Functions/4. Perform Statistical Operations by Using the SUMIFS Function.srt | 6.24 KB |
| 4. Logical and Statistical Functions/5. Perform Statistical Operations by Using the AVERAGEIFS Function.mp4 | 14.36 MB |
| 4. Logical and Statistical Functions/5. Perform Statistical Operations by Using the AVERAGEIFS Function.srt | 4.48 KB |
| 4. Logical and Statistical Functions/6. Perform Statistical Operations by Using the COUNTIFS Function.mp4 | 12.23 MB |
| 4. Logical and Statistical Functions/6. Perform Statistical Operations by Using the COUNTIFS Function.srt | 3.16 KB |
| 4. Logical and Statistical Functions/7. Perform Logical Operations by Using AND, OR, and NOT Functions.mp4 | 13.49 MB |
| 4. Logical and Statistical Functions/7. Perform Logical Operations by Using AND, OR, and NOT Functions.srt | 4.91 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.81 KB |
| 5. Expanded Functions/0. Reference the Date and Time by Using the NOW and TODAY Functions.mp4 | 15.91 MB |
| 5. Expanded Functions/0. Reference the Date and Time by Using the NOW and TODAY Functions.srt | 9.53 KB |
| 5. Expanded Functions/1. Serialize Numbers by Using DATE and TIME Functions.mp4 | 18.92 MB |
| 5. Expanded Functions/1. Serialize Numbers by Using DATE and TIME Functions.srt | 8.52 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.67 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.51 MB |
| 5. Expanded Functions/4. Calculate Data by Using Financial Functions- PMT.srt | 5.25 KB |
| 5. Expanded Functions/5. Calculate Data by Using Financial Functions- PPMT & IPMT.mp4 | 22.24 MB |
| 5. Expanded Functions/5. Calculate Data by Using Financial Functions- PPMT & IPMT.srt | 12.54 KB |
| 5. Expanded Functions/6. Calculate Data by Using Financial Functions- FV.mp4 | 11.28 MB |
| 5. Expanded Functions/6. Calculate Data by Using Financial Functions- FV.srt | 6.02 KB |
| 6. Error Checking/0. Display Formulas.mp4 | 9.68 MB |
| 6. Error Checking/0. Display Formulas.srt | 2.85 KB |
| 6. Error Checking/1. Trace Precedence and Dependence.mp4 | 16.13 MB |
| 6. Error Checking/1. Trace Precedence and Dependence.srt | 6.7 KB |
| 6. Error Checking/2. Evaluate Formulas.mp4 | 7.69 MB |
| 6. Error Checking/2. Evaluate Formulas.srt | 3.37 KB |
| 6. Error Checking/3. Validate Formulas by Using Error Checking Rules.mp4 | 24.87 MB |
| 6. Error Checking/3. Validate Formulas by Using Error Checking Rules.srt | 6.93 KB |
Trackers
No trackers found.