Search Our Content Library

Learning Path Courses:

  • Excel 2019 Beginners

    The material presented in this course helps you gain an understanding of the following topics:

    Getting Started with Excel
    Creating Workbooks and Using Templates
    Entering Data
    Excel Formula Basics
    Adjusting a Worksheet
    Formatting and Aligning a Worksheet
    Using Cell Styles and Themes
    Inserting Objects and Graphics
    Proofing a Worksheet
    Printing an Excel File
    Managing Worksheets
    Navigating and Viewing Excel Files

    Approximate Duration: 5 hours 30 minutes

  • Excel 2019 Intermediate

    The material presented in this course helps you gain an understanding of the following topics:

    Linking Workbooks and Worksheets
    Working with Range Names
    Sorting and Filtering Range Data
    Analyzing and Organizing with Tables
    Using Conditional Formatting
    Displaying Data Graphically
    Understanding PivotTables, PivotCharts, and Slicers
    Working with Advanced PivotTables and PowerPivot Features

    Approximate Duration: 4 hours 40 minutes

  • Excel 2019 Advanced

    The material presented in this course helps you gain an understanding of the following topics:

    Customizing Excel
    Analyzing Data with Logical Functions
    Working with Lookup Functions
    Using Text Function
    Working with Date and Time Functions
    Formula Auditing
    What-if Analysis Tools
    Worksheet and Workbook Protection
    Automating with Macros
    Working with Form Controls
    Ensuring Data Integrity
    Collaborating in Excel
    Importing and Exporting Data to a Text File

    Approximate Duration: 3 hours 58 minutes

Like what you see? We’d love to give you a guided tour of the best Pinnacle has to offer.

Book Your Demo

Trusted By Leaders

Understanding the Manufacturing & Construction Skills Gap
Before You Go

Understanding the Manufacturing & Construction Skills Gap

We went deep into the latest market research and created a resource to give you fresh insight into your recruitment challenges.