Excel: Advanced Formulas and Functions (Part 2)
Duration20'
No. of mini-lessons7
ResourcesTranscript
Duration 20'
No. of mini-lessons 7
Resources Transcript
Course overview
There’s a lot that Excel can do, but it’s not all about clicking buttons. There are hundreds of formulas and functions employees can use. But knowing the correct formatting of these is crucial to making them work. And the more they know, the more they can get out of their data and Excel.
This course will show them some advanced formulas and functions that they can use in Excel, so they can more easily manipulate their data. It’ll focus on lookups, text strings, and numerical manipulations. Each video will cover a specific formula or function, so they can choose exactly what they want to learn, at a pace that suits them.
What's covered
Lookups: LOOKUP, XLOOKUP, VLOOKUP and HLOOKUP
LEN and LENB functions
Max and Min Offsets
Substitute and Replace functions
Index and Match functions
Text functions including the Left, Right, Mid, Upper, Lower, and Proper functions
Why your teams need this course
There are lots of formulas and functions in Excel, and the more your employees know, the quicker and easier it is to work with their data. This course is perfect for anyone who knows Excel and wants to use it to work with and understand their data more quickly and easily. To get the best out of this course, they’ll need access to a computer and Microsoft Excel.
