Excel 365 New Features

Half DayHalf DayVersion 365Official CPE Provider

Build practical, job-ready Excel skills with hands-on, instructor-led training focused on real business tasks.

Course Objective

Excel 365 has many exciting new features which are not included in other versions of Office (2019 and earlier). These either have been a part of Excel 365 for years, or have been added through monthly updates to the software. In this class, students will learn how to use these new features to quickly analyze and chart data, identify what is in the Excel file, collaborate and apply new formats.

Prerequisites

Students should be familiar with how to navigate in Excel, as well as how to create charts and PivotTables.

Course Outline

6 lessons · 25 topics

1Lesson 1: Quickly Gain Insight into Your Data

The new Ideas Pane
Natural Language Queries
Workbook Statistics

2Lesson 2: New Data Types

Geography
Stock
Build out specific data fields using these formats

3Lesson 3: Collaboration using Excel

Automatic, real-time file saving
Comments and Notes

4Lesson 4: Get & Transform Data Queries with Column Analysis

Profile Data in Query Editor
Use Column Quality to check for valid data, errors, or empty cells
Identify distinct and unique data with Column Profile

5Lesson 5: New Charts in Excel 365

Waterfall Chart
Funnel Chart
Filled Map (2D Map)
Sunburst Chart
Treemap Chart
Box and Whisker Charts

6Lesson 6: General Enhancements in Excel

Default Styles for PivotTables
Search PivotTable Fields
Automatic Relationship creation in Data Model for PowerPivot PivotTables
Save PowerPivot Relationship Diagram View
Publish to Power BI
Slicers for Tables
Import professional images
Import icons into Excel

Excel Solutions Team
Kirkwood Tower, 11757 Katy Fwy, Suite 1300, Houston, TX 77079
(713) 589-2655 · contactinfo@excelsolutionsteam.com · excelsolutionsteam.com

Official CPE Provider (TX State Board of Public Accountancy)
BBB Accredited since 2006 · 20+ years training Houston professionals