Basic to Super Advance Excel Training Part1 (13 hours)

Partner: Udemy
Affiliate Name:
Area:
Description: If 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 disucussionUse 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 levelHow 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.Take a deep dive into learning most used and versatile functions in excel like IFERRO
Category: Office Productivity > Microsoft > Vlookup
Partner ID:
Price: 19.99
Commission:
Source: Impact
Go to Course