Find my training Basket 0
Microsoft Office

Microsoft Excel 365: Part 2

By the end of this course users should be comfortable in creating advanced formulas, analyzing data with functions, analyzing data using functions and PivotTables, working with tables, visualizing data with charts, working with graphical objects, and enhancing workbooks.

GK #821473Virtual Classroom LiveClassroom Live
FormatsVirtual Classroom Live · Classroom Live

What you’ll learn

Lesson 1: Creating Advanced Formulas

  • Topic A: Apply Range
  • Topic B: Use Specialized Functions

Lesson 2: Analyzing Data with Logical and Lookup Functions

  • Topic A: Use Text Functions
  • Topic B: Use Logical Functions
  • Topic C: Use Lookup Functions
  • Topic D: Use Date Functions
  • Topic E: Use Financial Functions

Lesson 3: Organizing Worksheet Data with Tables

  • Topic A: Create and Format Tables
  • Topic B: Modifying Tables
  • Topic C: Table References

Lesson 4: Visualizing Data with Basic Charts

  • Topic A: Create Charts
  • Topic B: Modify and Format Charts
  • Topic C: Create a Trendline
  • Topic D: Create Advanced Charts

Lesson 5: Analyzing Data with PivotTables, Slicers, and PivotCharts

  • Topic A: Create a PivotTable
  • Topic B: Filter Data Using Slicers
  • Topic C: Analyze Data with PivotCharts

Lesson 6: Working with Graphical Objects

  • Topic A: Insert and Modify Graphic Objects
  • Topic B: Layer and Group Graphic Objects
  • Topic C: Incorporate SmartArt

Lesson 7: Enhancing Workbooks

  • Topic A: Customize Workbooks
  • Topic B: Manage Themes
  • Topic C: Protect Files
  • Topic D: Preparing a Workbook for Multiple Audiences

Upcoming training

Dates and availability are confirmed by Bolt when we follow up. All times are shown in the provider’s stated time zone.

2026-10-06 — 2026-10-069:00 AM - 5:00 PM EDT
Virtual Classroom LiveONLINE · English
2026-11-24 — 2026-11-249:00 AM - 5:00 PM EST
Virtual Classroom LiveONLINE · English
2026-12-08 — 2026-12-089:00 AM - 5:00 PM EST
Virtual Classroom LiveONLINE · English

Related courses

Microsoft Office

Microsoft 365 SharePoint

By the end of this course, users should be comfortable with creating new sites in SharePoint, adding and configuring libraries and other site assets; configuring site settings, assigning permissions and access rights; and working with advanced site options. They should also be familiar with basic user tasks, such as accessing the site, using document libraries, and working with files.

Live onlineClassroom Live
View details
Microsoft Office

Microsoft Access 365: Part 1

By the end of this course, users should be comfortable with navigating the Microsoft Access interface, creating a new database from scratch, querying a database, generating reports, sharing data, and much more.

Live onlineClassroom Live
View details
Microsoft Office

Microsoft Access 365: Part 2

By the end of this course, users should be comfortable managing existing databases and completing light database development and management work. Users should also know how to find information about databases and use the validation techniques covered to ensure the integrity of the data that is collected.

Live onlineClassroom Live
View details