Course Overview
Microsoft Excel 365 has advanced functions that quickly and accurately analyze data. This course is facilitated by an experienced Microsoft trainer who walks learners through the various functions.
Using a practice employee info sheet throughout the course, the instructor shows how the various functions operate. She explains how to get the most out of using dynamic arrays with XLOOKUP. By using dynamic array functionality, the XLOOKUP function can arrive at a range of results from a single function.
Viewers are shown how to summarize a database on multiple conditions using multiple criteria functions. This course also shows how to use text, date, math, and database functions as well as complicated time formulas.
Take this training course to learn how to use the advanced functions of Microsoft Excel 365.
Key Audience
This training course will benefit Microsoft Excel 365 users who would like to learn how to use its advanced functions.
Course Topics
Dynamic Arrays
VLOOKUP
XLOOKUP, Part 1
XLOOKUP, Part 2
MATCH, INDEX
Multiple Criteria Functions
Text Functions
Date Functions
Time Formulas
Math Functions
Database Functions
Course Detail
Course ID
bbrnmead2_vod
Time
80-83 MIN
Questions
3
Languages
en
video format
HD
captions
No
Resources
Yes
Lessons
11
Remediation
Yes
Bookmarking
Yes
Feedback
No
Microlearning
No