Rating 4.45 out of 5 (22 ratings in Udemy)
What you'll learn- Perfect start for Beginners in Excel. 9 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 …
Rating 4.45 out of 5 (22 ratings in Udemy)
What you'll learn- Perfect start for Beginners in Excel. 9 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.
DescriptionIf you thinking of learning Excel - This is the perfect course for you. It has 9 hours plus long duration which means Deep dive into each aspect.
We are starting the excel in this program and covering use of $ signs in formulas and also a complete discussion on most used formula in excel
Know first the basic terms like Cells, rows, columns, address bar, formula and constants, name box , shortcut keys.
How to use Vlookup and what are rules to be followed while using Vlookup. From its limitations to its advantages - Deep disucussion
Use vlookup within sheets, across sheets and from different workbooks.
Why locking the cells and unlocking is important to learn . Practical example is given using Vlookup.
How to sort out issues in Vlookup if Lookup is repeated, What happens if lookup are more than one - Which one to use and Why?
Vlookup using constants , using helper columns or rows and finally using Match function.
How to use Match function as a standalone and why it is important to learn Match - Vlookup with Match Magic waiting for you,
How to use IF Functions including nested IFs. Covering everything about IF - Basic Single IF , IF AND, IF OR and IF inside IF - Nested ones - Super advance level
How to use IF with Vlookup and match , How to use MATCH with IFs. Practical questions you face in your office.
New function IFs which is launched in 2021 - see the difference between new IF and old IFs.
Learn how to use new function in Office 365 - XLOOKUP - deep discussion. It is another lookup function and you will love it.
You will have assignments also to practice along-with classwork files. Discussion starts from basic level but gradually moving towards extremely advance side. Have a great learning today.
