About the course

This is Advanced MS Excel Course. This course helps to improve Excel skills and improve your office working and also helps in Data analysis, Data presentation and fast working on MS Excel.

यह एडवांस्ड एमएस एक्सेल कोर्स है। यह कोर्स एक्सेल कौशल में सुधार करने और आपके कार्यालय के कामकाज में सुधार करने में मदद करता है और डेटा विश्लेषण, डेटा प्रस्तुति और एमएस एक्सेल पर तेजी से काम करने में भी मदद करता है।

In this course, we will learn about various important advanced excel formulas and functions for doing different tasks. Sumifs (Advanced Sumif), Sumifs (Between Date Range), Countifs, Averageif, If (Logical Function) Including Nested If (with Or And), Vlookup, Hlookup, Iferror, Trim, Vlookup with Match (Advanced Vlookup), Index Match, Xlookup, Fuzzy lookup.

Syllabus

What you’ll learn

Built for Novices

Just starting out? No need to worry. Let’s take the first step together.

Create a habit

Pick up a new skill and learn why practice makes perfect.

Learn with the best

Stuck on something? Discuss it with your peers in your virtual classroom.

Discover your niche

Learn what makes you tick and how you can use it to your benefit.

You may also be interested in

Advanced MS Excel