Basic to Super Advance Excel Training Part1 (13 hours)
XLOOKUP, Nested IFs ,VLOOKUP, Match,Index fx, Error Handlers, Practical situations-Basic to Super Advance
4.59 (37 reviews)
198
students
13 hours
content
Feb 2023
last update
$74.99
regular price
What you will learn
This Part1 is a Perfect start for Beginners in Excel. 13 hours course building slowly from basic to advance level side.
Please see Course Description down below to know more.
From Vlookup, Hlookup ,Use of Logical functions like IF Functions , Nested IFs, IF AND, IF OR. From Basic IF to complex IF functions.
New Function in Office 365 like IFs , XLOOKUPs.
Complex situations with VLookup & Match combinations or vlookup and IF logics. We are doing exercises in this live session to understand real world situations
Limitations of Vlookup and solutions. From Basic Vlookup to advance vlookup.
Why and how to use Vlookup and match functions together. Its benefits.
What are static formulas ,dynamic formulas.
Explained Constants and formulas , their role and difference.
Controlling the cells and formula direction using dollar sign and other spreadsheet fundamentals.
New Function XLookup is also discussed in detail with different examples.
Assignment solutions also provided to you in the form of excel file as well as lecture videos.
Error Handlers with practical examples
Screenshots
Related Topics
1666742
udemy ID
4/28/2018
course created date
2/8/2020
course indexed date
Bot
course submited by