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!

This course is an ideal course for people looking to learn about basics as well as advanced techniques of Excel.

### Key takeaways from Microsoft Excel: Beginners to Advanced Course

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

### Pre-requisites

This course assumes no past knowledge of MS Excel.

### Course curriculum- Microsoft Excel: Beginners to Advanced

• 1
##### Excel Basics
• Introduction
• Excel Interface
• Keyboard short cuts
• Excel Basic Exercise
• Excel Basic Formatting
• Basic Formating Exercise
• Cell & Worksheet options
• Auto Fill feature
• Insert & Delete
• Hide & Unhide
• Cell Operations Exercise
• Sheet_Operations
• Sheet Operations Exercise
• Excel Formula & Reference
• Exercise
• Paste_Special & Format_Painter
• Exercise
• Challenge
• DataHack Summit 2018
• 2
##### Excel Functions
• Left,Right,Mid,Len,Concatenate,Rept
• Find & Search
• Exercise
• Sum,Product,Mod,Sqrt
• Rounding Numbers
• SumIF & SumIFs
• Exercise
• Logical Function (If,AND,OR,iferror)
• ISERROR,ISNUMBER,ISBLANK,ISTEST
• Exercise
• Statistical Functions
• Exercise
• Date & Time Function
• Exercise
• Financial Functions
• Exercise
• Vlookup_Hlookup
• Match
• Index
• Offset & Indirect
• Exercise
• 3
##### Visualization
• Excel Charts
• Components of Charts
• Create a Chart
• Property of Charts
• Exercise
• Stacked Charts
• Area & Pie Chart
• Exercise
• How to Choose charts
• Sparklines
• Thermometer Chart
• Gauge Chart
• Gauge Chart Continues
• Waterfall Chart
• Exercise
• 4
• Highlight Cells Rules
• TopBottom Rules
• Exercise
• Pivot tables data
• Pivot Table I
• Pivot Table II
• Pivot Table III
• Exercise
• Exercise
• Sort
• Filter
• Exercise
• Exercise
• Excel Table
• Exercise
• Data Validation
• Exercise
• Goal-Seek & Scenario manager
• Data Tables
• Exercise
• Exercise
• Printing Worksheet
• Exercise
• Protecting Workbook
• Exercise
• 5
##### Final Test
• Exercise -1
• Assignment 1
• Assignment 2
• Assignment 3

### Course of Completion

Upon successful completion of the course, you will be provided a block chain enabled certificate by Analytics Vidhya with lifetime validity.

### Instructor(s)

#### 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.
• #### Manish Saraswat

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

### FAQ

• 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 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 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. 2500/-.

• How long I can access the 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

### Customer Support for our Courses & Programs

#### We are there for your support when you need!

• Phone - 10 AM - 6 PM (IST) on Weekdays (Mon - Fri) on +91-8368808185

• Email [email protected] (revert in 1 working day)

• Discussion Forum - answer in 1 working day