Embrace the Microsoft hype! Get 50% off on Microsoft Instructor-led Training courses!

MyGK
Support
Canada Canada - English
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Course  
Contact Sales
Support
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

Subtotal

$

Checkout

or Continue Shopping

Request Group Training

Microsoft Excel 365: Part 3

By the end of this course, users should be comfortable in both the online and desktop environments, using automating functions, analyzing and presenting data, auditing and error checking your work, working in multiple workbooks, and accessing and distributing data.

Welcome to the third part of our Microsoft 365 Excel courseware. Excel is Microsoft’s powerful and easy-to-use spreadsheet program. This new version of Excel incorporates some new features and connectivity to make collaboration and production as easy as possible.

Most of the features Microsoft incorporated in Office 2019 already exist in Office 365. Office 365 is a great solution for those looking for Office 2019 Training.

GK# 821474 Vendor# MS Excel 365 P3
Vendor Credits:
  • Global Knowledge Delivered Course
  • Training Exclusives
No matching courses available.
Start learning as soon as today! Click Add To Cart to continue shopping or Buy Now to check out immediately.
Access Period:
Scheduling a custom training event for your team is fast and easy! Click here to get started.
$
Your Selections:
Location:
Access Period:
No available dates
Add To Cart

BUY NOW

Request a quote

Is This The Right Course?

This course assumes the user has completed, or has an understanding of the materials covered, in the first and second parts of the Microsoft Office Excel 365 courseware, including:

  • Excel basics
  • Working with data
  • Modifying worksheets
  • Printing workbook contents
  • Managing large workbooks
  • Customizing the Excel environment
  • Creating advanced formulas
  • Analyzing data with logical and lookup functions
  • Organizing worksheets data with tables
  • Visualizing data with charts
  • Analyzing data with PivotTables, slicers, and PivotCharts
  • Working with graphical objects
  • Enhancing workbooks

Who Should Attend?

Excel Users who are seeking to learn the advanced features of Excel 365.

What You'll Learn

This course is intended to help all users get up to speed quickly on the advanced features of Excel. We will cover:

  • Using Excel Online
  • Worksheet Automation
  • Auditing and Error Checking
  • Data Analysis and Presentation
  • Working with Multiple Workbooks
  • Exporting and Sorting Data

Course Outline

Lesson 1: Excel Online

  • Topic A: Accessing and Using Excel Online
  • Topic B: Features that Differ Between Excel Online and the Excel Desktop Application

Lesson 2: Worksheet Automation

  • Topic A: Managing Workbook Properties
  • Topic B: Working with Macros
  • Topic C: Create and Use a Template
  • Topic D: Use Data Validation in a Workbook

Lesson 3: Auditing and Error Checking

  • Topic A: Tracing Cells
  • Topic B: Error Checking
  • Topic C: Evaluating Formulas and Using the Watch Window
  • Topic D: Data List Outlines

Lesson 4: Data Analysis and Presentation

  • Topic A: Quick Analysis Tool
  • Topic B: Adding Sparklines
  • Topic C: What-If Analysis
  • Topic D: The Analysis ToolPak

Lesson 5: Working with Multiple Workbooks

  • Topic A: Arrange Workbooks
  • Topic B: Linking to Data in Multiple Workbooks
  • Topic C: Consolidating Data

Lesson 6: Exporting and Sourcing Data

  • Topic A: Exporting Data
  • Topic B: Using Data Sources
  • Topic C: Use a Microsoft Form for Data Collection
BUY NOW

Prerequisites

This course assumes the user has completed, or has an understanding of the materials covered, in the first and second parts of the Microsoft Office Excel 365 courseware, including:

  • Excel basics
  • Working with data
  • Modifying worksheets
  • Printing workbook contents
  • Managing large workbooks
  • Customizing the Excel environment
  • Creating advanced formulas
  • Analyzing data with logical and lookup functions
  • Organizing worksheets data with tables
  • Visualizing data with charts
  • Analyzing data with PivotTables, slicers, and PivotCharts
  • Working with graphical objects
  • Enhancing workbooks