About the 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!

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
    Advanced Excel
    • Highlight Cells Rules
    • TopBottom Rules
    • Advance Formating
    • Exercise
    • Pivot Table I
    • Pivot Table II
    • Pivot Table III
    • Exercise
    • Exercise
    • Sort
    • Filter
    • Exercise
    • Advanced Filter
    • Exercise
    • Excel Table
    • Exercise
    • Data Validation
    • Exercise
    • Goal-Seek & Scenario manager
    • Data Tables
    • Exercise
    • Hyperlink
    • Exercise
    • Printing Worksheet
    • Exercise
    • Protecting Workbook
    • Exercise
  • 5
    Final Test
    • Exercise -1
    • Assignment 1
    • Assignment 2
    • Assignment 3

Instructor(s)

  • Sunil Ray

    Senior Content Officer

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