Requirements
- You will need Microsoft Excel Application
- No Previous Experience / Knowledge is required
- Little Familiarity with Microsoft Excel is enough
- No High-level Computer Skill is required
- Demonstration is done with Excel 2016 and Excel 2019, but the techniques work with any version of Excel.
- Excel on Windows (some techniques might work on mac, but I will not be able to support you).
- Great for students who want to learn at their own pace
Features
- Full lifetime access
- 3.5 hours on-demand video
- 19 Tutorials
- Downloadable resources
- Access on mobile and TV
- Certificate of completion
- You can apply Coupon
Target audiences
- Learners with limited knowledge on the subject
- Junior staff
- Students
- Microsoft Office Beginners
- Learners who require an introduction to Microsoft Excel.
- Excel from Beginner to Advanced
- Excel Skills for Business Specialization
- Excel Master Tutorial
Multiple Excel Related Tasks for you to expertise in VLOOKUP
- VLOOKUP Basic Part 1
- VLOOKUP Basics Part 2
- True Concept – 0 and 1
- Data Validation with VLOOKUP
- HLOOKUP & VLOOKUP – Comparison
- Finding Missing Data
- Advanced & Combined VLOOKUP
- Vlookup, IF AND, CountIF, Pivot Table, Line Chart
- Getting Data from WorkSheet (or) WorkBook
- Compare Data
- Pull Data from Multiple Excels
- Automatic Data Sourcing
- Unity of IF, Index, Match and VLOOKUP
- Sort Excel Data Automatically – Part 1
- Sort Excel Data Automatically – Part 2
- Left Vlookup or Reverse Lookup
- Vlookup to Get 1st, 2nd, and 3rd Matches
- VLOOKUP vs. XLOOKUP
- Use VLOOKUP Formula like a PRO
- VLOOKUP Alternatives
A complete tutorial for mastering in VLOOKUP which is suitable for MIS Executive, Accountants, Managers, Admins, Students and Freshers.
Course Features
- Lectures 20
- Quizzes 0
- Duration 4 hours
- Language Tamil
- Students 48
- Certificate Yes
- Assessments Yes
Mani
Excellent Teaching
They way the trainer teaching the course is awesome. Practice material is provided for most of the lessons. Really it can help me to move forward.
