Mastering Excel 365 – Advanced Part 2: Functions
$5.95
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.
Description
Audience:
This training course will benefit Microsoft Excel 365 users who would like to learn how to use its advanced functions.
Workplaces:
Not Specified
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
Languages:
en
Video Format:
HD
Quiz Questions:
3
Number of Lessons:
11
Training Time:
80-83 minutes
Closed Captioning:
No
Devices Supported:
Windows, Apple, Android, Chrome
Required Plugins:
None
Interactive Producer:
Mastery Training Content Network
Original Content Producer:
Bigger Brains
