About this Event
Microsoft® Excel® New and Essential Features and Functions in Excel 365 (1 Day Course)
Upcoming Dates: May 17, 2024 (Online in virtual classroom)| Check for more dates >
Duration: 1 day (9 am - 4 pm ET)
Microsoft Excel Versions: 365 (Windows)
Delivery Methods (Instructor-led): In-person (live classroom) training or Online (Virtual classroom)
Course Fee: $295 CDN per person + HST (Virtual classroom), $325 CDN per person + HST (Bring your own device for live classroom courses) or $345 CDN per person + HST (Avantix Learning provides device for live classroom courses)
Virtual Classroom: Virtual classroom courses are led by a live instructor and run from 9 am to 4 pm (Eastern Time) with a 15 minute break in the morning and in the afternoon and a 1 hour break for lunch.
In-person (Live Classroom) Course Location: Our live classroom courses are offered in downtown Toronto at the Toronto Eaton Centre (some Avantix Learning courses may be held at an alternate downtown Toronto location). Location will be confirmed when you register.
Learning Path: Level 3
Prerequisite: Microsoft Excel: Intermediate / Advanced or equivalent knowledge and skills.
Custom training: Available on request. Contact us to arrange a date.
Public scheduled courses are delivered as live instructor-led classroom training or virtual classroom training (as indicated). Bring your own device rates apply to live classroom courses. Some courses / formats may have a minimum enrollment requirement.
*Some courses and formats may be subject to a minimum enrollment requirement.
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, the instructor will include numerous tips, tricks and shortcuts. Each student will also receive a full course manual.
Note: This course does not include Power Query (Get and Transform) or Power Pivot which are offered as separate courses. Some features and functions are also available in Excel 2019.
Course topics
Extracting Text
- Extracting text using the TEXTBEFORE, TEXTAFTER and TEXTSPLIT functions
Using Functions that Return Conditional Results
- Calculating minimum or maximum values using multiple criteria with MINIFS or MAXIFS
- Using the IFS or SWITCH function vs the IF 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
- Using the SEQUENCE function
- Creating calculations to total dynamic arrays
- Creating dynamic drop-down menus using dynamic arrays
- Creating charts from dynamic arrays
- Sharing files containing dynamic arrays with users with older Excel versions
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
Importing Data from a Picture or PDF
- Importing data from a picture and converting it to editable Excel data
- Converting a PDF into an editable Excel document
Using Rich Data Types
- Inserting live stock data
- Inserting linked geographic data
Administative Tools
- Navigating quickly between worksheets, charts and other objects
- Inserting an image into a cell
VIEW FULL COURSE OUTLINE >
Who will benefit
This course has been designed for Microsoft Excel users who have completed the Microsoft Excel: Intermediate / Advanced training or have comparable knowledge and skills.
Can I bring my own device?
Absolutely! If you choose to bring your own device to a live classroom course, you will receive a reduced rate. Be sure to bring a power cord and a mouse is helpful.
What's included
Included in this course:
- Comprehensive course manual
- Keyboard shortcuts quick reference
- Sample and exercise files
- Refreshments (for classes conducted in Avantix Learning classrooms)
- Certificate of completion
- Follow-up email support
Microsoft Office training series
Other courses in this series include:
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools
Microsoft Excel: Introduction to Power Pivot and Data Modelling
Microsoft Excel: Introduction to VBA (Visual Basic for Applications)
Microsoft Project: Introduction
Micosoft Access: Introduction
VIEW MORE COURSES >
Check out these helpful articles
10 Excel Tips for Working with the Subtotal Feature >
10 Timesaving Excel Tricks and Shortcuts for Copying and Pasting >
How to Lock and Unlock Cells in Excel >
7 Microsoft Excel Shortcuts for Selecting in Tables >
Avantix Learning offers live instructor-led classroom courses and virtual classroom courses allowing personal interaction between the students and the instructor. We specialize in small classes, typically ranging from 6 to 10 students to ensure an optimal student to instructor ratio.
Live classroom courses are offered in downtown Toronto at 18 King Street East, Suite 1400, Toronto, Ontario, Canada. Some courses may also be offered at an alternate downtown Toronto location.
Virtual classroom courses are delivered online by a live instructor in a virtual classroom environment.
Our top-notch instructors have years of experience in the business world and students are encouraged to ask questions during our courses. Avantix Learning senior instructors have 15 or more years of experience. A complete profile of the instructor leading a specific course is available on request.
Have a question? Email us at [email protected].
You can also find information about all of our courses on our web site at www.avantixlearning.ca.
Refunds/Cancellations
We understand that your plans may change. Check out our refund policy for information regarding refunds and transfers.
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.
Event Venue & Nearby Stays
Avantix Learning | Toronto Eaton Centre or Online in Virtual Classroom, 250 Yonge Street, Toronto, Canada
CAD 295.00
