Search Our Content Library

Learning Path Courses:

  • Getting Started With Excel

    Getting Started with Excel
    (Approximate Duration: 24 minutes)

    Welcome to the Getting Started With Excel part of the Excel Learning Path.

    Course Objectives
    The material presented in this course helps you gain an understanding of the following topics:
    Opening Excel
    Navigating the User Interface
    Using the Ribbon
    Understanding Worksheet Components

    Course Prerequisites
    To participate in this training course, you should have the following:
    Microsoft Excel Installed

    Tips:
    Turn off your phone, close your email, text and social media apps.
    Plug headphones or ear buds to your computer.
    Go Full Screen when watching videos.

  • Creating Workbooks and Using Templates

    Creating Workbooks and Using Templates
    (Approximate Duration: 14 minutes)

    Welcome to the Creating Workbooks and Using Templates part of the Excel Learning Path.

    Course Objectives
    The material presented in this course helps you gain an understanding of the following topics:
    Opening Excel
    Navigating the User Interface
    Using the Ribbon
    Understanding Worksheet Components

    Course Prerequisites
    To participate in this training course, you should have the following:
    Microsoft Excel Installed

    Tips:
    Turn off your phone, close your email, text and social media apps.
    Plug headphones or ear buds to your computer.
    Go Full Screen when watching videos.

  • Entering Data

    Entering Data
    (Approximate Duration: 25 minutes)

    Welcome to the Entering Data part of the Excel Learning Path.

    Course Objectives
    The material presented in this course helps you gain an understanding of the following topics:
    Navigating a Worksheet
    Understanding Data Types
    Working with Cell Ranges and Addressing
    Using Various Data Selection Techniques
    Working with Common Excel Commands
    Using Autofill Handle

    Course Prerequisites
    To participate in this training course, you should have the following:
    Microsoft Excel Installed

    Tips:
    Turn off your phone, close your email, text and social media apps.
    Plug headphones or ear buds to your computer.
    Go Full Screen when watching videos.

  • Excel Formula Basics

    Excel Formula Basics
    (Approximate Duration: 27 minutes)

    Welcome to the Excel Formula Basics part of the Excel Learning Path.

    Course Objectives
    The material presented in this course helps you gain an understanding of the following topics:
    Understanding what Formulas and Functions are
    Understanding the Components of a Formula
    Understanding Calculation Hierarchy and the Order of Operations
    Creating Basic Formulas
    Working with Basic Functions and AutoSum
    Using Cell References
    Using the Quick Analysis Tool

    Course Prerequisites
    To participate in this training course, you should have the following:
    Microsoft Excel Installed

    Tips:
    Turn off your phone, close your email, text and social media apps.
    Plug headphones or ear buds to your computer.
    Go Full Screen when watching videos.

  • Adjusting a Worksheet

    Adjusting a Worksheet
    (Approximate Duration: 9 minutes)

    Welcome to the Adjusting a Worksheet part of the Excel Learning Path.

    Course Objectives
    The material presented in this course helps you gain an understanding of the following topics:
    Modifying Columns and Rows
    Hiding and Unhiding Columns and Rows.

    Course Prerequisites
    To participate in this training course, you should have the following:
    Microsoft Excel Installed

    Tips:
    Turn off your phone, close your email, text and social media apps.
    Plug headphones or ear buds to your computer.
    Go Full Screen when watching videos.

  • Formatting and Aligning Worksheet Data

    Formatting and Aligning Worksheet Data
    (Approximate Duration: 20 minutes)

    Welcome to the Formatting and Aligning Worksheet Data part of the Excel Learning Path.

    Course Objectives
    The material presented in this course helps you gain an understanding of the following topics:
    Formatting and Aligning Data
    Merging Data
    Wrapping Text and Adjusting Orientation
    Formatting Numbers
    Using Borders and Shading
    Using the Format Painter
    Removing Formatting Quickly

    Course Prerequisites
    To participate in this training course, you should have the following:
    Microsoft Excel Installed

    Tips:
    Turn off your phone, close your email, text and social media apps.
    Plug headphones or ear buds to your computer.
    Go Full Screen when watching videos.

  • Using Cell Styles and Themes

    Using Cell Styles and Themes
    (Approximate Duration: 9 minutes)

    Welcome to the Using Cell Styles and Themes part of the Excel Learning Path.

    Course Objectives
    The material presented in this course helps you gain an understanding of the following topics:
    Understanding Cell Styles
    Applying Cell Styles
    Applying Themes

    Course Prerequisites
    To participate in this training course, you should have the following:
    Microsoft Excel Installed

    Tips:
    Turn off your phone, close your email, text and social media apps.
    Plug headphones or ear buds to your computer.
    Go Full Screen when watching videos.

  • Inserting Objects and Graphics

    Inserting Objects and Graphics
    (Approximate Duration: 30 minutes)

    Welcome to the Inserting Objects and Graphics part of the Excel Learning Path.

    Course Objectives
    The material presented in this course helps you gain an understanding of the following topics:
    Inserting and Formatting Images
    Inserting and Formatting Shapes
    Inserting and Formatting SmartArt
    Inserting Screenshots
    Inserting Hyperlinks
    Inserting Symbols and Equations
    Inserting WordArt and Text Boxes
    Inserting Other Excel Objects
    Arranging Objects

    Course Prerequisites
    To participate in this training course, you should have the following:
    Microsoft Excel Installed

    Tips:
    Turn off your phone, close your email, text and social media apps.
    Plug headphones or ear buds to your computer.
    Go Full Screen when watching videos.

  • Proofing a Workbook

    Proofing a Workbook
    (Approximate Duration: 13 minutes)

    Welcome to the Proofing a Workbook part of the Excel Learning Path.

    Course Objectives
    The material presented in this course helps you gain an understanding of the following topics:
    Using Find and Replace
    Finding and Replacing Formatting
    Using Go To and Go To Special
    Using the Spell Checker
    Using the Thesaurus and Translation Features

    Course Prerequisites
    To participate in this training course, you should have the following:
    Microsoft Excel Installed

    Tips:
    Turn off your phone, close your email, text and social media apps.
    Plug headphones or ear buds to your computer.
    Go Full Screen when watching videos.

  • Printing an Excel File

    Printing an Excel File
    (Approximate Duration: 20 minutes)

    Welcome to the Printing an Excel File part of the Excel Learning Path.

    Course Objectives
    The material presented in this course helps you gain an understanding of the following topics:
    Printing and Previewing Excel Files
    Creating Custom Margins and Scaling
    Adding Headers and Footers
    Formatting a Page with the Page Layout Tab
    Printing Titles and Specific Worksheets Areas
    Exporting to PDF and XPS

    Course Prerequisites
    To participate in this training course, you should have the following:
    Microsoft Excel Installed

    Tips:
    Turn off your phone, close your email, text and social media apps.
    Plug headphones or ear buds to your computer.
    Go Full Screen when watching videos.

  • Managing Worksheets

    Managing Worksheets
    (Approximate Duration: 12 minutes)

    Welcome to the Managing Worksheets part of the Excel Learning Path.

    Course Objectives
    The material presented in this course helps you gain an understanding of the following topics:
    Renaming and Coloring Worksheet Tabs
    Adding, Deleting, And Navigating Worksheets
    Moving and Copying Worksheets
    Hiding and Unhiding Worksheets

    Course Prerequisites
    To participate in this training course, you should have the following:
    Microsoft Excel Installed

    Tips:
    Turn off your phone, close your email, text and social media apps.
    Plug headphones or ear buds to your computer.
    Go Full Screen when watching videos.

  • Navigating and Viewing Excel Files

    Navigating and Viewing Excel Files
    (Approximate Duration: 13 minutes)

    Welcome to the Navigating and Viewing Excel Files part of the Excel Learning Path.

    Course Objectives
    The material presented in this course helps you gain an understanding of the following topics:
    Viewing Workbooks
    Using Zoom Tools
    Configuring Sheet Options
    Using the Freeze Panes and Split Commands
    Working with Window Commands
    Adjusting Workbook Properties

    Course Prerequisites
    To participate in this training course, you should have the following:
    Microsoft Excel Installed

    Tips:
    Turn off your phone, close your email, text and social media apps.
    Plug headphones or ear buds to your computer.
    Go Full Screen when watching videos.

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.