2 Hour Live Virtual Training on Microsoft Excel - Basic Formulas Index, Match, and Lookups
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.
-
Training TypeLive Training
-
CategoryMS Excel
-
Duration2 Hours
-
Rating4.9/5
Course Introduction
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.
Course Objective
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
Aviation
Banking, CFOs
Controllers, CPAs
Education
Energy
FDA
Finance, Financial consultants
Human Resource
Insurance
Investments
IT
Logistics & Supply Chain
Marketing
Medical Devices
Pharmaceutical
Retail
Sales
Telecom
Basic Knowledge:
No prior Excel knowledge is required.
Related Virtual Classroom
Available Batches
Request a Batch That Is Most Convenient For You
Pricing
Live
Single Attendee
149
249
Live Session
Recorded
Single Attendee
199
332
6 month Access for Rec
Live+Recorded
Single Attendee
249
416
6 month Access for Rec
Curriculum
Total Duration : 2 Hours
Index
-
The Copy Command
-
Basic Formulas and the order of operations
-
HLOOKUP, VLOOKUP AND XLOOKUP functions
-
INDEX FUNCTION
-
MATCH FUNCTION
-
Combining the INDEX and MATCH functions