Search Our Content Library

Learning Path Courses:

  • Outlining with Subtotals and Grouping

    Outlining with Subtotals and Grouping
    (Approximate Duration: 7 minutes)

    Welcome to the Outlining with Subtotals and Grouping part of the Microsoft Office, Excel 2016 Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand:
    What are Subtotals and Grouping
    Creating Subtotals
    Grouping and Ungrouping Data

    Course Prerequisites
    Excel 2016 Beginner
     
    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.

  • Displaying Data Graphically

    Displaying Data Graphically
    (Approximate Duration: 48 minutes)

    Welcome to the Displaying Data Graphically part of the Microsoft Office, Excel 2016 Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand:
    Creating Charts
    Understanding and Modifying Chart Elements
    Changing and Moving Charts
    Filtering and Formatting Charts
    Adjusting Numbering
    Creating Dual Axis Charts
    Forecasting with Trendlines
    Creating a Chart Template
    Displaying Trends with Sparklines

    Course Prerequisites
    Excel 2016 Beginner
     
    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.

  • Understanding Pivot Tables and Pivot Charts and Filtering with Slicers

    Understanding Pivot Tables and Pivot Charts and Filtering with Slicers
    (Approximate Duration: 37 minutes)

    Welcome to the Understanding Pivot Tables and Pivot Charts and Filtering with Slicers part of the Microsoft Office, Excel 2016 Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand:
    Creating Pivot Tables
    Working with the Pivot Table Fields Pane
    Data Organization and Analysis with Pivot Tables
    Formatting Pivot Tables
    Creating, Modifying and Formatting Pivot Charts
    Adding Slicers and Timeline Slicers
    Formatting Slicers

    Course Prerequisites
    Excel 2016 Beginner
     
    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.

  • Working with Flash Fill

    Working with Flash Fill
    (Approximate Duration: 9 minutes)

    Welcome to the Working with Flash Fill part of the Microsoft Office, Excel 2016 Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand:
    Using FlashFIll and Autofill
    How to Fill Various Series

    Course Prerequisites
    Excel 2016 Beginner
     
    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.

  • Working with Date and Time Functions

    Working with Date and Time Functions
    (Approximate Duration: 7 minutes)

    Welcome to the Working with Date and Time Functions part of the Microsoft Office, Excel 2016 – Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand:
    Data and Time Functions
    How to use TODAY, NOW and DAY Functions
    Using NETWORKDAYS and YEARFRAC Functions

    Course Prerequisites
    Excel 2016 Beginner
     
    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.

  • Working with Common Text Functions

    Working with Common Text Functions
    (Approximate Duration: 10 minutes)

    Welcome to the Working with Common Text Functions part of the Microsoft Office, Excel 2016 – Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand:
    Text Functions
    Using CONCATENATE
    Using Text to Columns
    Using LEFT, RIGHT and MID Functions
    Using UPPER, LOWER, and PROPER Functions

    Course Prerequisites
    Excel 2016 Beginner
     
    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.

  • Customizing Excel

    Customizing Excel
    (Approximate Duration: 22 minutes)

    Welcome to the Customizing Excel Course part of the Microsoft Office, Excel 2016 Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to customize the following parts of Excel:
    Ribbon
    Quick Access Toolbar
    General and Formula Options
    AutoCorrect Options
    Save Defaults
    Advanced Excel Options

    Course Prerequisites
    Excel 2016 Beginner

    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.

  • Linking Workbooks and Worksheets

    Linking Workbooks and Worksheets
    (Approximate Duration: 13 minutes)

    Welcome to the Linking Workbooks and Worksheets part of the Microsoft Office, Excel 2016 Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand:
    Linking Workbooks and Worksheets
    Linking Worksheets with 3D References
    Understanding the Consolidate Feature

    Course Prerequisites
    Excel 2016 Beginner

    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.

  • Working with Range Names

    Working with Range Names
    (Approximate Duration: 13 minutes)

    Welcome to the Working with Range Names part of the Microsoft Office, Excel 2016 Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand:
    What are Range Names
    Creating Range Names

    Course Prerequisites
    Excel 2016 Beginner
     
    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.

  • Analyzing Data with Common Logical Functions

    Analyzing Data with Common Logical Functions
    (Approximate Duration: 20 minutes)

    Welcome to the Analyzing Data with Common Logical Functions part of the Microsoft Office, Excel 2016 Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand:
    Working with the Common Logical Functions
    Evaluating Data with the AND and OR Functions
    Understanding IF Functions
    Nesting of AND and OR in IF Functions

    Course Prerequisites
    Excel 2016 Beginner
     
    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.

  • Analyzing Data with Common Lookup Functions

    Analyzing Data with Common Lookup Functions
    (Approximate Duration: 12 minutes)

    Welcome to the Analyzing Data with Common Lookup Functions part of the Microsoft Office, Excel 2016 Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand:
    Lookup Functions
    Using VLOOKUP and HLOOKUP

    Course Prerequisites
    Excel 2016 Beginner
     
    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.

  • Sorting and Filtering Range Data

    Sorting and Filtering Range Data
    (Approximate Duration: 9 minutes)

    Welcome to the Sorting and Filtering Range Data part of the Microsoft Office, Excel 2016 Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand:
    Sorting and Filtering Data

    Course Prerequisites
    Excel 2016 Beginner 

    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.

  • Analyzing and Organizing with Tables

    Analyzing and Organizing with Tables
    (Approximate Duration: 23 minutes)

    Welcome to the Analyzing and Organizing with Tables part of the Microsoft Office, Excel 2016 Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand:
    Creating Tables and Understanding the Elements
    Formatting Tables
    Sorting and Filtering
    Calculating with Tables
    Removing Erroneous Data
    Exporting, Refreshing and Converting Tables

    Course Prerequisites
    Excel 2016 Beginner
     
    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 Conditional Formatting

    Using Conditional Formatting
    (Approximate Duration: 17 minutes)

    Welcome to the Using Conditional Formatting part of the Microsoft Office, Excel 2016 Intermediate Learning Path

    Course Objectives
    The material presented in this course will help you to understand conditional formatting for:
    Highlight Cells and Rules
    Data Bars, Icon Sets and Color Scales
    Custom Fonts and Colors
    Setup, Modification and Removal of Custom Conditional Formatting

    Course Prerequisites
    Excel 2016 Beginner
     
    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.