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 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
    • 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
    • Assignment: Share your learning and build your profile
  • 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
    • Assignment: Share your learning and build your profile