Pluralsight - Excel 2019 Pro by Bill Kulterman

1. 0. Formatting/0. Create Custom Number Formats.mp412.61MB
2. 0. Formatting/1. Apply International Currency Formats.mp48.47MB
3. 0. Formatting/2. Display Data in Multiple International Formats.mp47.6MB
4. 1. Working with Data/0. Outline Data.mp437.46MB
5. 1. Working with Data/1. Insert Subtotals.mp421.99MB
6. 1. Working with Data/2. Insert References.mp411.5MB
7. 1. Working with Data/3. Reference Data in Another Workbook.mp49.01MB
8. 1. Working with Data/4. Reference Data by Using Structured References.mp48.34MB
9. 1. Working with Data/5. Consolidate Data.mp414.9MB
10. 1. Working with Data/6. Configure Data Validation.mp414.08MB
11. 10. Advanced Options/0. Display Hidden Ribbon Tabs.mp418.02MB
12. 10. Advanced Options/1. Configure Formula Calculation Options.mp413MB
13. 11. Finalizing a Workbook/0. Inspect a Workbook for Hidden Properties or Personal Information.mp413.08MB
14. 11. Finalizing a Workbook/1. Inspect a Workbook for Accessibility Issues.mp413.52MB
15. 11. Finalizing a Workbook/2. Inspect a Workbook for Compatibility Issues.mp412.74MB
16. 11. Finalizing a Workbook/3. Restrict Editing.mp417.28MB
17. 11. Finalizing a Workbook/4. Protect Workbook Structure.mp49.03MB
18. 11. Finalizing a Workbook/5. Encrypt a Workbook with a Password.mp45.54MB
19. 11. Finalizing a Workbook/6. Manage Workbook Versions.mp48.73MB
20. 12. Macros/0. Create a Simple Macro.mp419.16MB
21. 12. Macros/1. Modify a Simple Macro.mp48.87MB
22. 12. Macros/2. Save and Enable Macros in a Workbook.mp47.4MB
23. 12. Macros/3. Copy Macros Between Workbooks.mp411.28MB
24. 12. Macros/4. Create a Macro Button.mp46.47MB
25. 13. Form Controls/0. Insert and Configure Form Controls.mp415.35MB
26. 2. Power Query/0. Import, Transform, and Connect to Data.mp429.3MB
27. 2. Power Query/1. Combine and Display Data.mp420.5MB
28. 3. Text Functions/0. Format Text by Using RIGHT, LEFT, and MID Functions.mp415.26MB
29. 3. Text Functions/1. Format Text by Using UPPER, LOWER, and PROPER Functions.mp413.31MB
30. 3. Text Functions/2. Format Text by Using the CONCAT Function.mp411.84MB
31. 4. Logical and Statistical Functions/0. Perform Logical Operations by Using the IF Function.mp47.76MB
32. 4. Logical and Statistical Functions/1. Perform Logical Operations by Using the SUMIF Function.mp418.3MB
33. 4. Logical and Statistical Functions/2. Perform Logical Operations by Using the AVERAGEIF Function.mp417.06MB
34. 4. Logical and Statistical Functions/3. Perform Statistical Operations by Using the COUNTIF Function.mp45.12MB
35. 4. Logical and Statistical Functions/4. Perform Statistical Operations by Using the SUMIFS Function.mp417.54MB
36. 4. Logical and Statistical Functions/5. Perform Statistical Operations by Using the AVERAGEIFS Function.mp414.36MB
37. 4. Logical and Statistical Functions/6. Perform Statistical Operations by Using the COUNTIFS Function.mp412.23MB
38. 4. Logical and Statistical Functions/7. Perform Logical Operations by Using AND, OR, and NOT Functions.mp413.49MB
39. 4. Logical and Statistical Functions/8. Perform Logical Operations by Using Nested Functions.mp418.5MB
40. 5. Expanded Functions/0. Reference the Date and Time by Using the NOW and TODAY Functions.mp415.91MB
41. 5. Expanded Functions/1. Serialize Numbers by Using DATE and TIME Functions.mp418.92MB
42. 5. Expanded Functions/2. Perform What-if Analysis by Using Goal Seek.mp49MB
43. 5. Expanded Functions/3. Perform What-if Analysis by Using Scenario Manager.mp421.67MB
44. 5. Expanded Functions/4. Calculate Data by Using Financial Functions- PMT.mp48.51MB
45. 5. Expanded Functions/5. Calculate Data by Using Financial Functions- PPMT & IPMT.mp422.24MB
46. 5. Expanded Functions/6. Calculate Data by Using Financial Functions- FV.mp411.28MB
47. 6. Error Checking/0. Display Formulas.mp49.68MB
48. 6. Error Checking/1. Trace Precedence and Dependence.mp416.13MB
49. 6. Error Checking/2. Evaluate Formulas.mp47.69MB
50. 6. Error Checking/3. Validate Formulas by Using Error Checking Rules.mp424.87MB
51. 6. Error Checking/4. Monitor Cells and Formulas by Using the Watch Window.mp412.78MB
52. 7. Conditional Formatting/0. Apply Conditional Formatting.mp428.96MB
53. 7. Conditional Formatting/1. Create Custom Conditional Formatting Rules.mp420.74MB
54. 7. Conditional Formatting/2. Create Conditional Formatting Rules That Use Formulas.mp428.34MB
55. 7. Conditional Formatting/3. Manage Conditional Formatting Rules.mp418.17MB
56. 8. Charts/0. Insert Sparklines.mp431.29MB
57. 8. Charts/1. Create a New Chart.mp411.59MB
58. 8. Charts/10. Add Trendlines to Charts.mp412.52MB
59. 8. Charts/11. Create Dual-axis Charts.mp410.4MB
60. 8. Charts/12. Save a Chart as a Template.mp48.52MB
61. 8. Charts/2. Add Additional Data Series.mp416.97MB
62. 8. Charts/3. Switch Between Rows and Columns in Source Data.mp44.82MB
63. 8. Charts/4. Analyze Data by Using Quick Analysis.mp410.52MB
64. 8. Charts/5. Resize Charts.mp47.14MB
65. 8. Charts/6. Move Charts to a Chart Sheet.mp49.63MB
66. 8. Charts/7. Add and Modify Chart Elements.mp418.53MB
67. 8. Charts/8. Apply Chart Layouts.mp48.17MB
68. 8. Charts/9. Apply Chart Styles.mp412.51MB
69. 9. Pivot Tables/0. Create Pivot Tables.mp429.63MB
70. 9. Pivot Tables/1. Modify Field Selections and Options.mp416.97MB
71. 9. Pivot Tables/10. Manipulate Options in Existing Pivot Charts.mp410.22MB
72. 9. Pivot Tables/11. Apply Styles to Pivot Charts.mp47.28MB
73. 9. Pivot Tables/12. Drill down into Pivot Chart Details.mp48.36MB
74. 9. Pivot Tables/2. Create Slicers.mp49.38MB
75. 9. Pivot Tables/3. Group Pivot Table Data.mp411.72MB
76. 9. Pivot Tables/4. Format Pivot Table Data.mp410.88MB
77. 9. Pivot Tables/5. Add Additional Fields.mp413.26MB
78. 9. Pivot Tables/6. Add Calculated Fields.mp416.6MB
79. 9. Pivot Tables/7. Drill down into PivotTable Details.mp48.87MB
80. 9. Pivot Tables/8. Use Cube Functions to Get Data out of the Excel Data Model.mp417.94MB
81. 9. Pivot Tables/9. Create Pivot Charts.mp412.63MB