Excel 365 New Features
Build practical, job-ready Excel skills with hands-on, instructor-led training focused on real business tasks.
Scheduled dates
This course is available for private and onsite training - delivered for your team anywhere in the U.S., or virtually on your schedule. You can also ask us to add it to the public calendar, or let us know you’re interested and we’ll reach out when a date is set.
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
- The new Ideas Pane
- Natural Language Queries
- Workbook Statistics
- Geography
- Stock
- Build out specific data fields using these formats
- Automatic, real-time file saving
- Comments and Notes
- 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
- Waterfall Chart
- Funnel Chart
- Filled Map (2D Map)
- Sunburst Chart
- Treemap Chart
- Box and Whisker Charts
- 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