Microsoft Excel: New Features and Functions in Excel 365

Microsoft Excel Training Series | Level 3

Course Details

Duration: 1 day (9 am – 4 pm)

Microsoft® Excel® Versions: 365 (Windows)

Delivery Methods (Instructor-led): In-person (Live classroom) | Virtual classroom

Course Dates: August 22, 2023 (Virtual classroom or In-person) | View schedule Course schedule

Course Fee: $295 CAD per person + HST (Virtual classroom), $325 CAD per person + HST (Bring your own device for in-person courses) or $375 CAD per person + HST (Avantix Learning provides device for in-person courses)*

Timing: Public scheduled courses run from 9:00 am to 4:00 pm (Eastern Time).

Virtual classroom courses: Our instructor-led virtual classroom courses are delivered in a virtual classroom environment. Students will be sent a virtual classroom invitation prior to the course.

In-person classroom courses: Our instructor-led, live classroom (in-person) courses are held in downtown Toronto at 18 King Street East, Suite 1400, Toronto, Ontario, Canada. Some courses are also held at an alternate downtown Toronto location.

Custom training: This course may be delivered at your site or ours as an instructor-led virtual classroom or in-person solution. Contact us at info@avantixlearning.ca for more information including savings for custom group training.

Register for this training course.

Course Overview

This course is designed for Excel users who have upgraded to Excel 365 or who have been using 365 but have not used some of the key new features and functions available in this version. Students will learn to use new functions such as CONCAT, TEXTJOIN, IFS, SWITCH, MAXIFS, MINIFS, XLOOKUP and XMATCH. Workbooks will be created with dynamic arrays and then transformed using SORT, SORTBY, UNIQUE and FILTER functions. Dynamic drop-down menus will also be created using dynamic arrays. Students will learn new ways to collaborate, create map charts and use new smart data types. During this hands-on course, students will practice their skills and have the opportunity to ask questions and interact with the instructor. Each student will also receive a full course manual with tips, tricks and shortcuts as well as sample and exercise files.

Note: Some features and functions may also be available in Excel 2019 or 2021.

Prerequisite: Microsoft Excel: Intermediate / Advanced or equivalent knowledge and skills.

Location and timing: Public scheduled courses are held online in virtual classroom format or in downtown Toronto and run from 9:00 am to 4:00 pm (Eastern Time).

Related training: View all Microsoft Excel courses >

INCLUDED IN THIS COURSE

  • Comprehensive course manual
  • Keyboard shortcuts quick reference
  • Sample and exercise files (new samples added frequently)
  • Refreshments (for classes conducted in Avantix Learning classrooms)
  • Certificate of completion
  • Follow-up email support

Course Topics

Manipulating Text

  • Using the TEXTJOIN function to combine text strings
  • Extracting text using the TEXTBEFORE, TEXTAFTER and TEXTSPLIT functions (availability based on release date)

Using Functions that Return Conditional Results

  • Calculating minimum or maximum values using multiple criteria with MINIFS or MAXIFS
  • Using the IFS function vs the IF function
  • Using the SWITCH function
  • Looking up values using XLOOKUP
  • Looking up matching values using XMATCH

Using Dynamic Arrays and Functions

  • Understanding dynamic arrays
  • Extracting data into spill ranges
  • Using the FILTER and UNIQUE functions with dynamic arrays
  • Using the SORT and SORTBY functions with dynamic arrays
  • Creating dynamic drop-down menus using dynamic arrays
  • Sharing files containing dynamic arrays with users with older Excel versions

Using Smart Data Types

  • Inserting live stock data
  • Inserting linked geographic data

Creating Variables

  • Creating variables in formulas using the LET function

Using the Lambda Function

  • Creating a custom function
  • Using new Excel functions with the Lambda function
  • Creating a custom function to generate a report without using macros

Creating Map Charts for Visualization

  • Creating map charts
  • Inserting 3D map charts

Inserting Data from Pictures or PDFs

  • Taking pictures on a smart phone and converting to editable Excel data
  • Converting a PDF into an editable Excel document

Administrative Tools

  • Viewing workbook statistics
  • Getting insights for analyzing data using Ideas

*Prices subject to change.

Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.

Copyright 2023 Avantix® Learning

Instructor in Microsoft Excel Intermediate / Advanced training course in Toronto.

You may like

How to Use Flash Fill in Excel (4 Ways with Shortcuts)

How to Use Flash Fill in Excel (4 Ways with Shortcuts)

You can use Flash Fill in Excel to extract, combine, clean or format data quickly without using formulas. In order to use Flash Fill, Excel must be able to understand a pattern in a column to the left of the column where you want to fill the data so the source data should be entered in a consistent way. You can use Flash Fill by clicking a button, using shortcuts or by using the Fill handle.

How to Insert Multiple Rows in Excel (4 Fast Ways with Shortcuts)

How to Insert Multiple Rows in Excel (4 Fast Ways with Shortcuts)

You can quickly insert multiple rows in Excel using the context menu, keyboard shortcuts or the Home tab in the Ribbon. The key to inserting multiple rows at once, rather than one by one, is to select the number of rows you want to insert first and then insert rows. Excel will insert the same number of rows you selected.

You may also like

How to Show or Unhide the Quick Access Toolbar in Word, Excel and PowerPoint

How to Show or Unhide the Quick Access Toolbar in Word, Excel and PowerPoint

In 2021 and 365 versions of Word, Excel and PowerPoint, you now have the ability to hide or unhide the Quick Access Toolbar. So if your Quick Access Toolbar seems to have disappeared, it may simply be hidden. In 2021, Microsoft also removed Undo and Redo / Repeat  from the Quick Access Toolbar and moved these commands to the Home tab in the Ribbon.

5 Ways to Insert or Type the Square Root Symbol (√) in PowerPoint (with Shortcuts)

5 Ways to Insert or Type the Square Root Symbol (√) in PowerPoint (with Shortcuts)

You can insert or type the square root symbol in PowerPoint presentations using built-in commands or keyboard shortcuts. The square root symbol or radical sign can be entered in placeholders, text boxes or in equation blocks on PowerPoint slides. You can use an Alt code shortcut, a Math AutoCorrect entry or create an AutoCorrect entry as a custom shortcut.

Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.

Avantix Learning |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca

Upcoming Training
Course
Microsoft Excel: New Features and Functions in Excel 365 (in-person in Toronto or online in virtual classroom format)
Location
Avantix Learning, 1 Yonge Street, Suite 1800 (Toronto Star Building),Toronto, Ontario,Canada
Next course starts
August 22, 2023
Next course ends
August 22, 2023
Description
This course is designed for Excel users who have upgraded to Excel 365 or who have been using 365 but have not used the key new features and functions available in this version. Students will learn to use new functions such as CONCAT, TEXTJOIN, IFS, SWITCH, MAXIFS, MINIFS, XLOOKUP and XMATCH. Workbooks will be created with dynamic arrays and then transformed using SORT, SORTBY, UNIQUE and FILTER functions. Dynamic drop-down menus will also be created using dynamic arrays. Students will learn new ways to collaborate, create map charts and use new smart data types. During this hands-on course, the instructor will include numerous tips, tricks and shortcuts. Each student will also receive a full course manual.

Pin It on Pinterest