Pluralsight - Excel 2019 Pro by Bill Kulterman

File Name

Size

0. Formatting/0. Create Custom Number Formats.mp4

13 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

38 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

12 MB

1. Working with Data/2. Insert References.srt

5.7 kB

1. Working with Data/3. Reference Data in Another Workbook.mp4

9.0 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

15 MB

1. Working with Data/5. Consolidate Data.srt

5.9 kB

1. Working with Data/6. Configure Data Validation.mp4

14 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 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

14 MB

11. Finalizing a Workbook/1. Inspect a Workbook for Accessibility Issues.srt

5.0 kB

11. Finalizing a Workbook/2. Inspect a Workbook for Compatibility Issues.mp4

13 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 MB

11. Finalizing a Workbook/3. Restrict Editing.srt

7.0 kB

11. Finalizing a Workbook/4. Protect Workbook Structure.mp4

9.0 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 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 MB

12. Macros/3. Copy Macros Between Workbooks.srt

4.0 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 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 MB

2. Power Query/0. Import, Transform, and Connect to Data.srt

14 kB

2. Power Query/1. Combine and Display Data.mp4

20 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 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 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

12 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 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 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.0 kB

4. Logical and Statistical Functions/4. Perform Statistical Operations by Using the SUMIFS Function.mp4

18 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 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 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

14 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 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

16 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

19 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.0 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

22 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 MB

5. Expanded Functions/5. Calculate Data by Using Financial Functions- PPMT & IPMT.srt

12 kB

5. Expanded Functions/6. Calculate Data by Using Financial Functions- FV.mp4

11 MB

5. Expanded Functions/6. Calculate Data by Using Financial Functions- FV.srt

6.0 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 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

25 MB

6. Error Checking/3. Validate Formulas by Using Error Checking Rules.srt

6.9 kB

6. Error Checking/4. Monitor Cells and Formulas by Using the Watch Window.mp4

13 MB

6. Error Checking/4. Monitor Cells and Formulas by Using the Watch Window.srt

5.3 kB

7. Conditional Formatting/0. Apply Conditional Formatting.mp4

29 MB

7. Conditional Formatting/0. Apply Conditional Formatting.srt

9.7 kB

7. Conditional Formatting/1. Create Custom Conditional Formatting Rules.mp4

21 MB

7. Conditional Formatting/1. Create Custom Conditional Formatting Rules.srt

7.1 kB

7. Conditional Formatting/2. Create Conditional Formatting Rules That Use Formulas.mp4

28 MB

7. Conditional Formatting/2. Create Conditional Formatting Rules That Use Formulas.srt

7.5 kB

7. Conditional Formatting/3. Manage Conditional Formatting Rules.mp4

18 MB

7. Conditional Formatting/3. Manage Conditional Formatting Rules.srt

5.7 kB

8. Charts/0. Insert Sparklines.mp4

31 MB

8. Charts/0. Insert Sparklines.srt

7.2 kB

8. Charts/1. Create a New Chart.mp4

12 MB

8. Charts/1. Create a New Chart.srt

5.5 kB

8. Charts/10. Add Trendlines to Charts.mp4

12 MB

8. Charts/10. Add Trendlines to Charts.srt

7.3 kB

8. Charts/11. Create Dual-axis Charts.mp4

10 MB

8. Charts/11. Create Dual-axis Charts.srt

6.1 kB

8. Charts/12. Save a Chart as a Template.mp4

8.5 MB

8. Charts/12. Save a Chart as a Template.srt

4.0 kB

8. Charts/2. Add Additional Data Series.mp4

17 MB

8. Charts/2. Add Additional Data Series.srt

6.5 kB

8. Charts/3. Switch Between Rows and Columns in Source Data.mp4

4.8 MB

8. Charts/3. Switch Between Rows and Columns in Source Data.srt

2.1 kB

8. Charts/4. Analyze Data by Using Quick Analysis.mp4

10 MB

8. Charts/4. Analyze Data by Using Quick Analysis.srt

5.3 kB

8. Charts/5. Resize Charts.mp4

7.1 MB

8. Charts/5. Resize Charts.srt

2.9 kB

8. Charts/6. Move Charts to a Chart Sheet.mp4

9.6 MB

8. Charts/6. Move Charts to a Chart Sheet.srt

3.8 kB

8. Charts/7. Add and Modify Chart Elements.mp4

18 MB

8. Charts/7. Add and Modify Chart Elements.srt

7.8 kB

8. Charts/8. Apply Chart Layouts.mp4

8.2 MB

8. Charts/8. Apply Chart Layouts.srt

4.0 kB

8. Charts/9. Apply Chart Styles.mp4

12 MB

8. Charts/9. Apply Chart Styles.srt

5.4 kB

9. Pivot Tables/0. Create Pivot Tables.mp4

30 MB

9. Pivot Tables/0. Create Pivot Tables.srt

9.7 kB

9. Pivot Tables/1. Modify Field Selections and Options.mp4

17 MB

9. Pivot Tables/1. Modify Field Selections and Options.srt

7.6 kB

9. Pivot Tables/10. Manipulate Options in Existing Pivot Charts.mp4

10 MB

9. Pivot Tables/10. Manipulate Options in Existing Pivot Charts.srt

5.2 kB

9. Pivot Tables/11. Apply Styles to Pivot Charts.mp4

7.3 MB

9. Pivot Tables/11. Apply Styles to Pivot Charts.srt

3.3 kB

9. Pivot Tables/12. Drill down into Pivot Chart Details.mp4

8.4 MB

9. Pivot Tables/12. Drill down into Pivot Chart Details.srt

4.2 kB

9. Pivot Tables/2. Create Slicers.mp4

9.4 MB

9. Pivot Tables/2. Create Slicers.srt

5.9 kB

9. Pivot Tables/3. Group Pivot Table Data.mp4

12 MB

9. Pivot Tables/3. Group Pivot Table Data.srt

5.2 kB

9. Pivot Tables/4. Format Pivot Table Data.mp4

11 MB

9. Pivot Tables/4. Format Pivot Table Data.srt

5.2 kB

9. Pivot Tables/5. Add Additional Fields.mp4

13 MB

9. Pivot Tables/5. Add Additional Fields.srt

6.0 kB

9. Pivot Tables/6. Add Calculated Fields.mp4

17 MB

9. Pivot Tables/6. Add Calculated Fields.srt

7.1 kB

9. Pivot Tables/7. Drill down into PivotTable Details.mp4

8.9 MB

9. Pivot Tables/7. Drill down into PivotTable Details.srt

3.6 kB

9. Pivot Tables/8. Use Cube Functions to Get Data out of the Excel Data Model.mp4

18 MB

9. Pivot Tables/8. Use Cube Functions to Get Data out of the Excel Data Model.srt

10 kB

9. Pivot Tables/9. Create Pivot Charts.mp4

13 MB

9. Pivot Tables/9. Create Pivot Charts.srt

5.6 kB

content.txt

4.2 kB