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 of this 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

• 1
##### Excel Basics
• Introduction
• Excel Interface
• Keyboard short cuts
• Exercise
• Excel Basic Formatting
• Exercise
• Cell & Worksheet options
• Auto Fill feature
• Insert & Delete
• Hide & Unhide
• Exercise
• 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
• Data & 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 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

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