Pluralsight - Excel 2019 Pro by Bill Kulterman
File List
- 1. Working with Data/0. Outline Data.mp4 37.5 MB
- 8. Charts/0. Insert Sparklines.mp4 31.3 MB
- 9. Pivot Tables/0. Create Pivot Tables.mp4 29.6 MB
- 2. Power Query/0. Import, Transform, and Connect to Data.mp4 29.3 MB
- 7. Conditional Formatting/0. Apply Conditional Formatting.mp4 29.0 MB
- 7. Conditional Formatting/2. Create Conditional Formatting Rules That Use Formulas.mp4 28.3 MB
- 6. Error Checking/3. Validate Formulas by Using Error Checking Rules.mp4 24.9 MB
- 5. Expanded Functions/5. Calculate Data by Using Financial Functions- PPMT & IPMT.mp4 22.2 MB
- 1. Working with Data/1. Insert Subtotals.mp4 22.0 MB
- 5. Expanded Functions/3. Perform What-if Analysis by Using Scenario Manager.mp4 21.7 MB
- 7. Conditional Formatting/1. Create Custom Conditional Formatting Rules.mp4 20.7 MB
- 2. Power Query/1. Combine and Display Data.mp4 20.5 MB
- 12. Macros/0. Create a Simple Macro.mp4 19.2 MB
- 5. Expanded Functions/1. Serialize Numbers by Using DATE and TIME Functions.mp4 18.9 MB
- 8. Charts/7. Add and Modify Chart Elements.mp4 18.5 MB
- 4. Logical and Statistical Functions/8. Perform Logical Operations by Using Nested Functions.mp4 18.5 MB
- 4. Logical and Statistical Functions/1. Perform Logical Operations by Using the SUMIF Function.mp4 18.3 MB
- 7. Conditional Formatting/3. Manage Conditional Formatting Rules.mp4 18.2 MB
- 10. Advanced Options/0. Display Hidden Ribbon Tabs.mp4 18.0 MB
- 9. Pivot Tables/8. Use Cube Functions to Get Data out of the Excel Data Model.mp4 17.9 MB
- 4. Logical and Statistical Functions/4. Perform Statistical Operations by Using the SUMIFS Function.mp4 17.5 MB
- 11. Finalizing a Workbook/3. Restrict Editing.mp4 17.3 MB
- 4. Logical and Statistical Functions/2. Perform Logical Operations by Using the AVERAGEIF Function.mp4 17.1 MB
- 8. Charts/2. Add Additional Data Series.mp4 17.0 MB
- 9. Pivot Tables/1. Modify Field Selections and Options.mp4 17.0 MB
- 9. Pivot Tables/6. Add Calculated Fields.mp4 16.6 MB
- 6. Error Checking/1. Trace Precedence and Dependence.mp4 16.1 MB
- 5. Expanded Functions/0. Reference the Date and Time by Using the NOW and TODAY Functions.mp4 15.9 MB
- 13. Form Controls/0. Insert and Configure Form Controls.mp4 15.3 MB
- 3. Text Functions/0. Format Text by Using RIGHT, LEFT, and MID Functions.mp4 15.3 MB
- 1. Working with Data/5. Consolidate Data.mp4 14.9 MB
- 4. Logical and Statistical Functions/5. Perform Statistical Operations by Using the AVERAGEIFS Function.mp4 14.4 MB
- 1. Working with Data/6. Configure Data Validation.mp4 14.1 MB
- 11. Finalizing a Workbook/1. Inspect a Workbook for Accessibility Issues.mp4 13.5 MB
- 4. Logical and Statistical Functions/7. Perform Logical Operations by Using AND, OR, and NOT Functions.mp4 13.5 MB
- 3. Text Functions/1. Format Text by Using UPPER, LOWER, and PROPER Functions.mp4 13.3 MB
- 9. Pivot Tables/5. Add Additional Fields.mp4 13.3 MB
- 11. Finalizing a Workbook/0. Inspect a Workbook for Hidden Properties or Personal Information.mp4 13.1 MB
- 10. Advanced Options/1. Configure Formula Calculation Options.mp4 13.0 MB
- 6. Error Checking/4. Monitor Cells and Formulas by Using the Watch Window.mp4 12.8 MB
- 11. Finalizing a Workbook/2. Inspect a Workbook for Compatibility Issues.mp4 12.7 MB
- 9. Pivot Tables/9. Create Pivot Charts.mp4 12.6 MB
- 0. Formatting/0. Create Custom Number Formats.mp4 12.6 MB
- 8. Charts/10. Add Trendlines to Charts.mp4 12.5 MB
- 8. Charts/9. Apply Chart Styles.mp4 12.5 MB
- 4. Logical and Statistical Functions/6. Perform Statistical Operations by Using the COUNTIFS Function.mp4 12.2 MB
- 3. Text Functions/2. Format Text by Using the CONCAT Function.mp4 11.8 MB
- 9. Pivot Tables/3. Group Pivot Table Data.mp4 11.7 MB
- 8. Charts/1. Create a New Chart.mp4 11.6 MB
- 1. Working with Data/2. Insert References.mp4 11.5 MB
- 12. Macros/3. Copy Macros Between Workbooks.mp4 11.3 MB
- 5. Expanded Functions/6. Calculate Data by Using Financial Functions- FV.mp4 11.3 MB
- 9. Pivot Tables/4. Format Pivot Table Data.mp4 10.9 MB
- 8. Charts/4. Analyze Data by Using Quick Analysis.mp4 10.5 MB
- 8. Charts/11. Create Dual-axis Charts.mp4 10.4 MB
- 9. Pivot Tables/10. Manipulate Options in Existing Pivot Charts.mp4 10.2 MB
- 6. Error Checking/0. Display Formulas.mp4 9.7 MB
- 8. Charts/6. Move Charts to a Chart Sheet.mp4 9.6 MB
- 9. Pivot Tables/2. Create Slicers.mp4 9.4 MB
- 11. Finalizing a Workbook/4. Protect Workbook Structure.mp4 9.0 MB
- 1. Working with Data/3. Reference Data in Another Workbook.mp4 9.0 MB
- 5. Expanded Functions/2. Perform What-if Analysis by Using Goal Seek.mp4 9.0 MB
- 9. Pivot Tables/7. Drill down into PivotTable Details.mp4 8.9 MB
- 12. Macros/1. Modify a Simple Macro.mp4 8.9 MB
- 11. Finalizing a Workbook/6. Manage Workbook Versions.mp4 8.7 MB
- 8. Charts/12. Save a Chart as a Template.mp4 8.5 MB
- 5. Expanded Functions/4. Calculate Data by Using Financial Functions- PMT.mp4 8.5 MB
- 0. Formatting/1. Apply International Currency Formats.mp4 8.5 MB
- 9. Pivot Tables/12. Drill down into Pivot Chart Details.mp4 8.4 MB
- 1. Working with Data/4. Reference Data by Using Structured References.mp4 8.3 MB
- 8. Charts/8. Apply Chart Layouts.mp4 8.2 MB
- 4. Logical and Statistical Functions/0. Perform Logical Operations by Using the IF Function.mp4 7.8 MB
- 6. Error Checking/2. Evaluate Formulas.mp4 7.7 MB
- 0. Formatting/2. Display Data in Multiple International Formats.mp4 7.6 MB
- 12. Macros/2. Save and Enable Macros in a Workbook.mp4 7.4 MB
- 9. Pivot Tables/11. Apply Styles to Pivot Charts.mp4 7.3 MB
- 8. Charts/5. Resize Charts.mp4 7.1 MB
- 12. Macros/4. Create a Macro Button.mp4 6.5 MB
- 11. Finalizing a Workbook/5. Encrypt a Workbook with a Password.mp4 5.5 MB
- 4. Logical and Statistical Functions/3. Perform Statistical Operations by Using the COUNTIF Function.mp4 5.1 MB
- 8. Charts/3. Switch Between Rows and Columns in Source Data.mp4 4.8 MB
- 2. Power Query/0. Import, Transform, and Connect to Data.srt 14.1 KB
- 5. Expanded Functions/5. Calculate Data by Using Financial Functions- PPMT & IPMT.srt 12.5 KB
- 5. Expanded Functions/3. Perform What-if Analysis by Using Scenario Manager.srt 11.0 KB
- 9. Pivot Tables/8. Use Cube Functions to Get Data out of the Excel Data Model.srt 10.3 KB
- 2. Power Query/1. Combine and Display Data.srt 10.0 KB
- 13. Form Controls/0. Insert and Configure Form Controls.srt 9.9 KB
- 4. Logical and Statistical Functions/8. Perform Logical Operations by Using Nested Functions.srt 9.8 KB
- 9. Pivot Tables/0. Create Pivot Tables.srt 9.7 KB
- 7. Conditional Formatting/0. Apply Conditional Formatting.srt 9.7 KB
- 5. Expanded Functions/0. Reference the Date and Time by Using the NOW and TODAY Functions.srt 9.5 KB
- 12. Macros/0. Create a Simple Macro.srt 8.9 KB
- 5. Expanded Functions/1. Serialize Numbers by Using DATE and TIME Functions.srt 8.5 KB
- 0. Formatting/0. Create Custom Number Formats.srt 8.5 KB
- 1. Working with Data/6. Configure Data Validation.srt 8.4 KB
- 10. Advanced Options/0. Display Hidden Ribbon Tabs.srt 8.2 KB
- 8. Charts/7. Add and Modify Chart Elements.srt 7.8 KB
- 9. Pivot Tables/1. Modify Field Selections and Options.srt 7.6 KB
- 7. Conditional Formatting/2. Create Conditional Formatting Rules That Use Formulas.srt 7.5 KB
- 8. Charts/10. Add Trendlines to Charts.srt 7.3 KB
- 8. Charts/0. Insert Sparklines.srt 7.2 KB
- 9. Pivot Tables/6. Add Calculated Fields.srt 7.1 KB
- 7. Conditional Formatting/1. Create Custom Conditional Formatting Rules.srt 7.1 KB
- 11. Finalizing a Workbook/3. Restrict Editing.srt 7.0 KB
- 6. Error Checking/3. Validate Formulas by Using Error Checking Rules.srt 6.9 KB
- 6. Error Checking/1. Trace Precedence and Dependence.srt 6.7 KB
- 8. Charts/2. Add Additional Data Series.srt 6.5 KB
- 4. Logical and Statistical Functions/1. Perform Logical Operations by Using the SUMIF Function.srt 6.5 KB
- 11. Finalizing a Workbook/0. Inspect a Workbook for Hidden Properties or Personal Information.srt 6.5 KB
- 10. Advanced Options/1. Configure Formula Calculation Options.srt 6.3 KB
- 4. Logical and Statistical Functions/4. Perform Statistical Operations by Using the SUMIFS Function.srt 6.2 KB
- 8. Charts/11. Create Dual-axis Charts.srt 6.1 KB
- 5. Expanded Functions/6. Calculate Data by Using Financial Functions- FV.srt 6.0 KB
- 9. Pivot Tables/5. Add Additional Fields.srt 6.0 KB
- 5. Expanded Functions/2. Perform What-if Analysis by Using Goal Seek.srt 5.9 KB
- 9. Pivot Tables/2. Create Slicers.srt 5.9 KB
- 1. Working with Data/5. Consolidate Data.srt 5.9 KB
- 1. Working with Data/0. Outline Data.srt 5.8 KB
- 1. Working with Data/2. Insert References.srt 5.7 KB
- 4. Logical and Statistical Functions/2. Perform Logical Operations by Using the AVERAGEIF Function.srt 5.7 KB
- 7. Conditional Formatting/3. Manage Conditional Formatting Rules.srt 5.7 KB
- 9. Pivot Tables/9. Create Pivot Charts.srt 5.6 KB
- 8. Charts/1. Create a New Chart.srt 5.5 KB
- 8. Charts/9. Apply Chart Styles.srt 5.4 KB
- 8. Charts/4. Analyze Data by Using Quick Analysis.srt 5.3 KB
- 6. Error Checking/4. Monitor Cells and Formulas by Using the Watch Window.srt 5.3 KB
- 5. Expanded Functions/4. Calculate Data by Using Financial Functions- PMT.srt 5.2 KB
- 9. Pivot Tables/4. Format Pivot Table Data.srt 5.2 KB
- 9. Pivot Tables/10. Manipulate Options in Existing Pivot Charts.srt 5.2 KB
- 9. Pivot Tables/3. Group Pivot Table Data.srt 5.2 KB
- 11. Finalizing a Workbook/2. Inspect a Workbook for Compatibility Issues.srt 5.1 KB
- 11. Finalizing a Workbook/1. Inspect a Workbook for Accessibility Issues.srt 5.0 KB
- 1. Working with Data/4. Reference Data by Using Structured References.srt 4.9 KB
- 4. Logical and Statistical Functions/7. Perform Logical Operations by Using AND, OR, and NOT Functions.srt 4.9 KB
- 3. Text Functions/0. Format Text by Using RIGHT, LEFT, and MID Functions.srt 4.6 KB
- 11. Finalizing a Workbook/6. Manage Workbook Versions.srt 4.5 KB
- 4. Logical and Statistical Functions/5. Perform Statistical Operations by Using the AVERAGEIFS Function.srt 4.5 KB
- 1. Working with Data/3. Reference Data in Another Workbook.srt 4.4 KB
- 1. Working with Data/1. Insert Subtotals.srt 4.4 KB
- 0. Formatting/2. Display Data in Multiple International Formats.srt 4.4 KB
- content.txt 4.2 KB
- 9. Pivot Tables/12. Drill down into Pivot Chart Details.srt 4.2 KB
- 12. Macros/3. Copy Macros Between Workbooks.srt 4.0 KB
- 8. Charts/12. Save a Chart as a Template.srt 4.0 KB
- 8. Charts/8. Apply Chart Layouts.srt 4.0 KB
- 0. Formatting/1. Apply International Currency Formats.srt 3.9 KB
- 8. Charts/6. Move Charts to a Chart Sheet.srt 3.8 KB
- 9. Pivot Tables/7. Drill down into PivotTable Details.srt 3.6 KB
- 3. Text Functions/1. Format Text by Using UPPER, LOWER, and PROPER Functions.srt 3.6 KB
- 11. Finalizing a Workbook/4. Protect Workbook Structure.srt 3.6 KB
- 12. Macros/1. Modify a Simple Macro.srt 3.4 KB
- 3. Text Functions/2. Format Text by Using the CONCAT Function.srt 3.4 KB
- 12. Macros/2. Save and Enable Macros in a Workbook.srt 3.4 KB
- 6. Error Checking/2. Evaluate Formulas.srt 3.4 KB
- 4. Logical and Statistical Functions/0. Perform Logical Operations by Using the IF Function.srt 3.3 KB
- 9. Pivot Tables/11. Apply Styles to Pivot Charts.srt 3.3 KB
- 4. Logical and Statistical Functions/6. Perform Statistical Operations by Using the COUNTIFS Function.srt 3.2 KB
- 8. Charts/5. Resize Charts.srt 2.9 KB
- 6. Error Checking/0. Display Formulas.srt 2.8 KB
- 11. Finalizing a Workbook/5. Encrypt a Workbook with a Password.srt 2.8 KB
- 8. Charts/3. Switch Between Rows and Columns in Source Data.srt 2.1 KB
- 4. Logical and Statistical Functions/3. Perform Statistical Operations by Using the COUNTIF Function.srt 2.0 KB
- 12. Macros/4. Create a Macro Button.srt 1.8 KB
Download Torrent
Related Resources
Copyright Infringement
If the content above is not authorized, please contact us via activebusinesscommunication[AT]gmail.com. Remember to include the full url in your complaint.