Web Analytics

Mastering Microsoft Excel Advanced Skills (Part 2)

  • teacher
    Mr. Ravelino Dsouza - Microsoft & Sap Coach

Mastering Microsoft Excel Advanced Skills (Part 2)

This course will help you solve all your queries related to aspects of Autofill & Sum If, Filters & VLookup, Pivot Tables & Charts, Macros and How to be an Excel Pro

  • COURSE BENEFITS
  • COURSE VIDEOS
  • TEACHER PROFILE
  • REVIEWS
  • GIFT COURSE

This course consists of the following chapters: - Chapter 1 - Autofill & Sum If Chapter 2 - Filters & VLookup Chapter 3 - Pivot Tables & Charts Chapter 4 - Macros Chapter 5 - How to be an Excel Pro

Requirements

    Minimum qualification required is HSC / XIIth std. in addition to a reasonable work experience LEARN | UPSKILL | GET CERTIFIED Gyaan.com launched in 2021 is a new way of Online Skill based Learning in India where one can learn online courses and certify themselves in Short Term Certificate Courses as well as Job or Career Oriented Certification Programs and get the best knowledge on Popular Trending Topics which are highly in demand. With this the students can get themselves Certified & Upskill or Re-skill themselves. As Gyaan is affiliated with Government recognised National Board of Vocational Training Education (nbte.in) as well as with the Govt recognized Education Board of Vocational Trainings & Research (ebitr.com) affiliation, Gyaan.com is authorised to run approved Vocational Courses for school or college students in fields of MBA, Strategy, Management, Business, Entrepreneurship, Sales, Marketing, Accounting, Finance, Insurance, Human Resources (HRM), Information Technology (IT), Microsoft, SAP, Fashion, Beauty, Makeup, Hair, Personal Styling, Fitness, Spiritual Wellness, Health, Fitness, Yoga, Graphic Designing, Interior Designing, Sports, Games, Languages, Culture, Intellectual Property Law, Business Law, Commerce, Economics, Arts, Science and many more Soft Skills such as Personality Development, Communication Skills, Interview Skills, Group Discussion Skills and Entrance Exam Preparation.

Certification

On successful completion of this course, you will be able to take an Online Exam/Quiz in which you will have to score 50% in order to Pass. Once you secure more than 50%, you will be declared as "Pass" and your Certificate will be generated automatically which will be saved in your Login ID as well as emailed to you on your registered Email Id

This is the first chapter of this course and in this chapter you will learn all about "Autofill & Sum If" which will ensure that you get the right knowledge with respect to this topic

This is the second chapter of this course and in this chapter you will learn all about "Filters & VLookup" which will ensure that you get the right knowledge with respect to this topic

This is the third chapter of this course and in this chapter you will learn all about "Pivot Tables & Charts" which will ensure that you get the right knowledge with respect to this topic

This is the fourth chapter of this course and in this chapter you will learn all about "Macros" which will ensure that you get the right knowledge with respect to this topic

This is the fifth chapter of this course and in this chapter you will learn all about "How to be an Excel Pro" which will ensure that you get the right knowledge with respect to this topic

teacher

Mr. Ravelino DSouza

Microsoft & Sap Coach

Who put out the fire? - At once we answer the firefighter. well Mr. Ravelino D'souza is that guy, who is called in when all hell breaks loose. He is a hard-working dedicated person ready to help, learn and grow not just by himself but with others as well. He is a Technology Expert with vast experience in Softwares as well as Hardwares