# Excel MIS Analytics (Advance Vlookup Match & IFs ) Series 1

• Course provided by Udemy
• Study type: Online
• Starts: Anytime
• Price: See latest price on Udemy

## Course Description

If you thinking of learning Excel - This is the perfect lecture for you. 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 - Vlookup, Match, if functions including nested IFs. 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.

## Who this course is for:

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

## Course content

1 section • 13 lectures • 9h 2m total length
• Introduction to Vlookup and Match - So Powerful Part1
01:03:07
• Introduction to Vlookup and Match - Part2
01:05:58
• Introduction to IF Function
01:02:10
• VLOOKUP IF TRIM Match - All in One - Great Project
01:27:24
• Approximate Vlookup for you
16:24
• Solved Assignment for your confidence
56:51
• XLOOKUP- New function launched in Excel
44:46
• XLOOKUP - Dynamic range
47:04
• New Function OFFICE 365- IFS & Vlookup with Different Workbook
25:26

## Instructor

Instructor - Advance Excel, Excel Vba ,Access, Access Vba
• 4.5 Instructor Rating
• 533 Reviews
• 2,289 Students
• 45 Courses

I have been teaching online from 10 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.