2 Hour Live Virtual Training on Microsoft Excel - Basic Formulas Index, Match, and Lookups
Training TypeLive Training
About the Course
If you have wanted to get started with writing formulas in Excel and could not get past a blank spreadsheet, this course will get you started on the path to becoming an Excel expert.
We will begin with simple formulas and the copy command and then you will master the important VLOOKUP, HLOOKUP, XLOOKUP, MATCH, and INDEX functions. With this knowledge, you will be prepared to master all of Excel’s powerful functions.
Who is the Target Audience?
Accountants, Accounts, Audit
Finance, Financial consultants
Logistics & Supply Chain
No prior Excel knowledge is required.
The Copy Command
Basic Formulas and the order of operations
HLOOKUP, VLOOKUP AND XLOOKUP functions
Combining the INDEX and MATCH functions