Microsoft Excel: New and Essential Features and Functions in Excel 365
Microsoft Excel Training Series | Level 3
Duration: 1 day (9 am – 4 pm)
Microsoft® Excel® Versions: 365 (Windows)
Delivery Methods (Instructor-led): In-person (Live classroom) | Virtual classroom
Course Dates: Check back soon for new dates (Virtual classroom) | View schedule
Course Fee: $275 CAD per person + HST (Virtual classroom), $295 CAD per person + HST (Bring your own device for in-person courses) or $345 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 email@example.com for more information including savings for custom group training.
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.
Prerequisite: Microsoft Excel: Intermediate / Advanced or equivalent knowledge and skills.
Note: This course does not include Power Query (Get and Transform) or Power Pivot which are available as separate courses. Some features and functions are also available in Excel 2019.
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
Combining Text Strings
- Combining text strings using the CONCAT function
- Using the TEXTJOIN function to combine text strings
Using Functions that Return Conditional Results
- Calculate 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 vs VLOOKUP
- Looking up matching values using XMATCH vs INDEX and MATCH
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 in formulas using the LET function
Creating Custom Functions Using the Lambda Function
- Creating a custom function
- Creating a custom function to split text
- Creating a custom function to generate a report without using macros
Creating Innovative Charts for Visualization
- Inserting funnel, waterfall and histogram charts
- Creating map charts
- Inserting 3D map charts
Collaborating with Other Users
Collaborating with other users in real time
Viewing and restoring changes in real time
Setting Pivot Table Default Layouts
- Setting default layouts for pivot tables
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
Viewing workbook statistics
- Getting insights for analyzing data using Ideas
Register Now for a public course at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.
Do you have any other questions? Contact us!
If you are looking for more information regarding versions, check out our Microsoft Excel version overviews.
To request this page in an alternate format, contact our staff.
*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 firstname.lastname@example.org if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.
Copyright 2022 Avantix® Learning
Register now for a public scheduled course or contact us at email@example.com for more information about any of our courses or to discuss custom training options (virtual classroom or live classroom).
You may like
It's easy to lock and protect cells in Microsoft Excel to prevent users from changing data or formulas. This involves a two-step process …
In Microsoft Excel, errors are flagged with small green marker or triangle in the upper left corner of the cell. However, these indicators display when there may be an error but is, in fact, not an error.
You can lock and protect an Excel workbook by adding a password using your security options. If you want to prevent users from accessing or changing a workbook, password protection can be added to your Excel file in a number of ways.
There are several mouse and keyboard shortcuts you can use to zoom in and out in Excel worksheets. Some of these shortcuts are built-in and others can be created by customizing Excel Options.
You can apply cell styles in Excel worksheets to quickly format cells in a consistent way and automate repetitive formatting. Excel includes several built-in styles (such as Heading 1, Heading 2 and so on) and you can modify styles before or after you apply them. If none of the built-in styles fit your needs, you can also create a new style.
You may also like
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.
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.
You can reorder objects on a PowerPoint slide using keyboard shortcuts, the context menu, the Ribbon or the Selection Pane. When objects are placed on a slide, they are stacked on top of each other. It's common to reorder objects to change the stacking order. When you select an object and Send to Back, it's moved to the bottom of the stack. If you choose to Send Backward, it's moved back by object. When you select an object and Bring to Front, it's moved to the top of the stack. If you choose to Bring Forward, it's moved forward by object.
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 firstname.lastname@example.org