Excel: Advanced Formulas and Functions (Part 2)
Train your employees on Excel advanced functions like LOOKUP, VLOOKUP, XLOOKUP, LEN, Index, Match, and text functions like Left and Upper.
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.
Accredited by CPD
TalentLibrary is recognized as reaching the standards and benchmarks required by the Continuing Professional Development (CPD) Certification Service.
The CPD Certification Service is the world’s leading and largest independent accreditation organization for professional development courses across all industry sectors.
Other courses in this collection
Excel: Custom Templates and Add-Ins
Train your employees on creating, saving, and managing Excel custom templates, and using Power Query, Power Pivot, and VBA add-ins effectively.
Excel: Scenario Analysis and What-If Analysis
Train your employees on Excel’s Scenario Manager, Goal Seek, Data Tables, Solver Add-In, Forecast Sheets, and Monte Carlo simulations.
Excel: Integration with Other Tools
Train your employees on linking Excel data to Word, PowerPoint, and Google Sheets, exporting to PDF, and using Power Query and APIs.
