Basic to Super Advance Excel Training Part1 (13 hours)

XLOOKUP, Nested IFs ,VLOOKUP, Match,Index fx, Error Handlers, Practical situations-Basic to Super Advance

Created by: ajay parmar
Instructor -Excel,Vba ,Access, Access Vba,BI,PQ,G SHEETS

What Will I 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

Requirements

• You need to have Excel installed on your computer or laptop. Excel 2007 or above version

Target audience

• Who want to learn Excel from zero level and gradually want to know advance excel. This is the beginning of your excel formulas.