Skip to main content

Microsoft Excel: Beginners to Advanced

LIMITED OFFER

Get flat 20% Discount on this course. Use COUPON CODE: TODAY20 To Get 20% Discount Today (Apply this code at checkout)

 

Price: INR 2,000 (2,500)

 

Offer Ending Soon

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:

  1. 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.

  2. 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.

  3. 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.

Syllabus

Excel Basics
  • Introduction
  • Getting Started
  • Excel Formatting
  • Excel Operations
  • Sheet Operations
  • Formulas
  • Paste Special and Format
  • Challenge
  • DataHack Summit 2018 (Sponsored)
Excel Functions
  • Excel Text Functions
  • Excel Math Functions
  • Excel Error Handling and Logical Functions
  • Statistical Functions
  • Date and Time Functions
  • Financial Functions
  • Look-up Operations
Visualization
  • Excel Charts
  • Components of Charts
  • Create a Chart
  • Property of Charts
  • Stacked Charts
  • Area & Pie Chart
  • How to Choose charts
  • Sparklines
  • Thermometer Chart
  • Gauge Chart
  • Waterfall Chart
Advanced Excel
  • Conditional Formatting
  • Pivot table
  • Sorting & Filtering
  • Advanced Filter
  • Excel Tables
  • Data Validation
  • Analysis Tools
  • Hyperlinks
  • Printing
  • Protection
Final Test
  • Exercises
  • Assignments

Course Staff

img
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.

img
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.

Course Staff

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?

Fee for the course is 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

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

Enroll