PLU | Excel 2019 Pro (2019 EN)

Discussion in 'Information Technology' started by Kanka, Nov 23, 2019.

  1. Kanka

    Kanka Well-Known Member Loyal User

    Likes Received:
    Trophy Points:

    Company: Pluralsight
    Author: ByBill Kulterman
    Full Title: Excel 2019 Pro
    Year: 2019
    Language: English
    Genre: Educational: Spreadsheets
    Skill Level: Advanced
    Price: -
    Files: MP4
    Time: 05:20:36
    Video: AVC, 1280 x 720 (1.778) at 15.000 fps, 900 kbps
    Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz

    In this course, you’ll learn the most advanced aspects of working with Excel 2019. Explore how to perform all sorts of useful functions, pivot tables, macros, form controls, and much more in this massive deep dive into the world of Excel 2019.

    Learn the most advanced aspects of Excel 2019. In this course, Excel 2019 Pro, you'll take your knowledge to the ultimate level. First, you'll learn how to format and work with data. Then, you’ll learn about queries, text/logical/statistical and other functions. Finally, you’ll learn conditional formatting, charts, pivot tables, macros, and form controls. When you’re finished with this course, you'll have the skills and knowledge of Excel 2019 needed to format and work with more advanced spreadsheets (and continue your preparation for the Microsoft Office exams).

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