Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS

Learn Beginner to Advanced tricks on VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, INDIRECT - multi dimensional, reverse
4.39 (147 reviews)
Udemy
platform
English
language
Microsoft
category
instructor
Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS
1 193
students
2.5 hours
content
Apr 2020
last update
$34.99
regular price

Why take this course?

🚀 [Course Title] - Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, INDIRECT, OFFSET


🎓 Course Access Includes:

  • 1-on-1 instructor support 🤝
  • Self practice files to hone your skills 🖥️
  • LIFETIME access to the course material 🕰️
  • A 100% money-back guarantee if you're not satisfied 💰

Student Testimonials:

  • "I am very impressed with [Instructor's Name]'s courses so far, especially the short videos that allow me to get to a topic quickly and then move on. The course also includes shortcuts I found no other course with the same insights." - Peter Klugsberger, Australia, ex-McKinsey & Co., served various senior roles (CEO, COO)

  • "You solved the exact problem which I face at my office in your course" - Rajesh Dhoot, India, ex-Sr. Manager, Finance and Accounts, Ultratech Cements – An Aditya Birla Group Co.


Why This Mini-Course? The top seven functions for data lookup in Excel are VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, INDIRECT, and OFFSET. These functions will cover more than 50% of your Excel tasks related to data analysis and MIS reporting.

Our course offers 26 videos, totalling 2 hours of content, tailored to take you from beginner to Ninja level with practical examples. 🧙‍♂️


Your Question - Why should I take this mini-course on Excel?

Our Response:

  1. Understanding the Necessity: We explain why certain formulas are used and how they can be beneficial for your work.
  2. Efficiency: Learn to save time with efficient methods for data lookup and manipulation.
  3. Expert Guidance: Enjoy the feeling of one-to-one attention through personalized support from the instructor.
  4. Continuous Learning: Get instant and free access to any updates added to the course material.
  5. Practical Application: Practice with over 📈 worksheets included for immediate application of your new skills.
  6. Accessibility: Learn anytime, anywhere, with 24 x 7 access to all videos.
  7. Risk-Free Commitment: With a 30-day money-back guarantee, you have nothing to lose and a lifetime of Excel skills to gain! 🌟

Course Scope: This course covers Lookups (1D, 2D, 3D, Combo, Reverse), VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, OFFSET & Conditional Calculations (Sum, Average, Count, and Special Running Total). 📊


Important Information Before You Join:

  • Lifetime Access: Once enrolled, you have unlimited, lifetime access to the course!
  • Updates & Support: You will have free access to any updates I'll add to the course and my full support regarding any issues or suggestions related to the course.
  • Guided Practice: Over 📄 workbooks included for immediate practice.
  • Access Anytime: Access all videos 24 x 7 and learn online from anywhere.
  • Satisfaction Guarantee: A 30-day money back guarantee to ensure you're completely satisfied with the course. ✂️

Ready to become an Excel Ninja? 🥋 Join us now and invest just 2 hours to enhance your skills for a lifetime! Let's embark on this journey together. 🚀

Course Gallery

Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS – Screenshot 1
Screenshot 1Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS
Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS – Screenshot 2
Screenshot 2Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS
Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS – Screenshot 3
Screenshot 3Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS
Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS – Screenshot 4
Screenshot 4Excel For Beginners: VLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS

Loading charts...

Related Topics

831240
udemy ID
25/04/2016
course created date
22/11/2019
course indexed date
Bot
course submited by