Mastering Excel 365 - Advanced Part 2: Functions
- Product ID
- bbrnmead2_vod
- Training Time ?
- 80 to 83 minutes
- Language(s)
- English
- Video Format
- High Definition
- Required Plugins
- None
- Number of Lessons
- 11
- Quiz Questions
- 3
- Question Feedback
- Wrong Answer Remediation
- Lesson Bookmarking
- Downloadable Resources
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.
This course is in the Video On Demand format, to read about Video On Demand features click here.
- Full-screen video presentation
- Print certificate and wallet card
- You have 30 days to complete the course
This training course will benefit Microsoft Excel 365 users who would like to learn how to use its advanced functions.
- Dynamic Arrays
- VLOOKUP
- XLOOKUP Part 1
- XLOOKUP Part 2
- MATCH INDEX
- Multiple Criteria Functions
- Text Functions
- Date Functions
- Time Formulas
- Math Functions
- Database Functions
© Mastery Technologies, Inc.
