Skip to main content
img

May 11,2018 - December 31,2018

Microsoft Excel: Beginners to Advanced

MS Excel is the most widely used tool for day to day analysis across the world. By end of this course, you will have mastered Excel, Pivot Tables, Conditional Formatting and will be ready to crunch numbers like a pro!

About This Course

If you want to work with numbers, there is no better tool to start with than MS Excel - which is still the most popular tool around.

In this course, we will take you through the basic excel operations, leading up to the advanced features, such as pivot tables, conditional formatting etc. By the end of the course, you will have mastered Excel and will be ready to crunch numbers and prepare data!

Requirements

This course assumes no past knowledge of MS Excel.

Why take this course

This course is an ideal course for people looking to start a career in data science. Several features which make it exciting are:

  • Easy to understand content - All the material in this course was created by Analytics Vidhya instructors who bring in immense experience of data science with them.
  • Industry collaboration - Entire course has been vetted by industry experts. This ensures relevance in industry and enabling you with the content which matters the most.
  • Real life problems - All projects in the course are based on real life problems. No academic datasets are being used to ensure that you are ready for real life problems.

Support

For people undergoing the course, you can call us any time between 9 a.m. - 5 p.m. on Weekdays Monday - Friday on +91-8368253068 or email us on training_queries@analyticsvidhya.com

Course Staff

Course Staff Image #1

Sunil Ray

Sunil Ray is Chief Content Officer of Analytics Vidhya. He brings years of experience of using data to solve business problems for several Insurance companies. Sunil has a knack of taking complex topics and then breaking them into easy and simple to understand concepts – a unique skill which comes in handy in his role at Analytics Vidhya. Sunil also follows latest developments in AI & ML closely and is always up for having a discussion on impact of technology on years to come.

Course Staff Image #1

Manish Saraswat

Manish has comprehensive knowledge of Microsoft’s suite of products, like Excel, Word, PowerPoint, Access, among others. He is an MBA graduate and a keen learner.



Frequently Asked Questions

Who should take this course?

This course is meant for people looking to learn Excel. We will start out from the basics and make our way to the advanced features.

Do I need to install any software before starting the course?

You will need to have Microsoft Excel installed in your machine.

What is the refund policy?

The fee for this course is non-refundable.

Do I need to take the modules in a specific order?

We would highly recommend taking the course in the order in which it has been designed to gain the maximum knowledge from it.

Do I get a certificate upon completion of the course?

Yes, you will be given a certificate upon satisfactory completion of the course.

What is the fee for this course?

Enroll before July 31st, 2018 at an introductory price of Rs. 2,299. Post this, the revised fee for the course will be Rs. 3,999.

How long can I access this course?

You will be able to access the course material for 6 months since the start of the course.

Is there any placement support with this course?

This is a beginner course and comes without any placement support. You can check various opportunities on Analytics Vidhya Jobs portal and participate in our Hiring Hackathons

.

ABOUT THE INSTRUCTORS

Analytics Vidhya

Analytics Vidhya

Learn Everything about Analytics

Analytics Vidhya offers a high engagement community of data scientists and analytics professionals. You can connect with them to solve cutting-edge problems to hire them or turn them into evangelists of your products and services

SYLLABUS

  • Introduction
  • Getting Started
  • Excel Formatting
  • Excel Operations
  • Sheet Operations
  • Formulas
  • Paste Special and Format
  • Challenge
  • DataHack Summit 2018 (Sponsored)
  • Excel Text Functions
  • Excel Math Functions
  • Excel Error Handling and Logical Functions
  • Statistical Functions
  • Date and Time Functions
  • Financial Functions
  • Look-up Operations
  • Visualization
  • Conditional Formatting
  • Pivot table
  • Sorting & Filtering
  • Advanced Filter
  • Excel Tables
  • Data Validation
  • Analysis Tools
  • Hyperlinks
  • Printing
  • Protection
  • Exercises
  • Assignments

CERTIFICATE

  • A certificate will be offered after successful completion of this course.
REVIEWS
5.0(2)
2 Reviews

2 months 11 days ago

syedamir.raza

very much useful in day to day professional life.

2 months 19 days ago

sourabh1106

perfect course for beginner to start with.

VIEW ALL REVIEWS

INR 3999

Enroll Now

KEY HIGHLIGHTS

  • Learn how to use Excel from scratch
  • Master Visualization and Manipulation of Data using Excel
  • Demonstrate your skills on real life use-cases
×
Enroll