Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Excel functions to analyze and visualize data
Rating: 4.3 out of 5(564 ratings)
3,918 students

Excel functions to analyze and visualize data

Learn basic yet powerful [ excel functions for data analysis and visualization on real life data
Created byAshish Agarwal
Last updated 8/2026
English
EnglishFrench [Auto],

What you'll learn

  • Complete overview of Microsoft Excel interface
  • Data analysis in Excel
  • Data visualization in Excel

Course content

1 section • 18 lectures • 1h 56m total length

  • Introduction - brief overview on the course3:44

    Explore essential Excel functions for analyzing large data sets, including SUMIF, VLOOKUP, HLOOKUP, Index Match, and COUNTIF, and learn to visualize results with charts and conditional formatting.

  • Download the excel spreadsheet we will use in the course0:01

    Please download this file

  • The dataset we will analyze in this course2:55

    Explore the raw data template for this course, analyzing quarterly GDP by industry from 2004-05 to 2014-15 in rupees billions, and learn basic Excel functions to extract insights.

  • Extraction of data: Using the SUMIF function8:14

    Apply the SUMIF function to aggregate the total GDP by sector for each year, using fixed ranges and criteria, and extend the formula across years and sectors to verify results.

  • Extraction of data: using VLOOKUP function11:40

    Use the vlookup function to extract gdp data and gdp growth rate from a dataset by looking up a year in the leftmost column and returning the exact matching column.

  • Extraction of data: using the HLOOKUP function9:31
  • Extraction of data: using the INDEX and MATCH function13:56

    Explore how the index and match functions overcome vlookup and hlookup limitations by enabling dynamic year and sector lookups to compute GDP and its percentage increase.

  • Extraction of data: using the IF, COUNTIF and COUNTIFS function9:09

    Explore how the IF, COUNTIF, and COUNTIFS functions in Excel determine positive GDP growth, count years, and assess simultaneous positive GDP and mining sector growth.

  • Presentation of data: using the LINE graph12:33

    Learn to create a line chart in excel to visualize sector growth over years, using transpose and vlookup for dynamic data, and format titles, axes, legends, and labels.

  • Presentation of data: using the PIE chart11:45
  • Presentation of data: using the COLUMN chart13:03

    Learn to depict a sector's absolute GDP contribution in India with an Excel column chart. Then plot its year-on-year growth as a line on a secondary axis.

  • Presentation of data: using the STACKED chart10:56
  • Presentation of data: using CONDITIONAL FORMATTING in Excel6:58

    Explore how to create a heat map in Excel using conditional formatting to visualize high, medium, and low performing sectors across years by rates above 8%, 5–8%, and below 5%.

  • Practice Assignment: DIFFICULTY LEVEL - MEDIUM0:36
  • SOLUTION TO PRACTICE ASSIGNMENT0:04
  • Please review our course - we need your feedback0:22
  • Conclusion - contact us0:10
  • Please provide us your valuable feedback0:43

Requirements

  • None. We will teach everything from scratch.

Description

Welcome to our first ever course Excel functions to analyze and visualize data 

We are glad to meet you. If only we could shake hands! 


Are you wondering how is this course going to be useful to you? 

Hey, did you watch the promo video? If not, please do. 

If you are looking to learn Microsoft Excel basics, this course will teach you exactly that.

Look, Microsoft Excel is ubiquitous. It is used in almost every job we do in today's world.

So your job will also possibly require you to do analysis on large heaps of data.

Our course does exactly that - we make you job ready for your prospective project / daily work.


What makes our course different from others?

Our course content is unique - you learn exactly what you are required to do in your daily work.

You get 1.5 hours of crisp synthesized practical real life illustrations of all concepts.

You will be carrying out the real life illustrations along with the instructor.

Same set up as the instructor. All illustration spreadsheets are shared.

It's almost like as if somebody is guiding you in person to carry out the various analysis.

You are going to love our instructor's teaching style. 

He makes it very engaging and fun learning experience.

You will have practice assignments / course challenges with varying difficulty levels to test your learning from the course.

Our support team responds to any course queries within 24 hours of your request. 

And of course, the price is competitive. 


What will you learn in this course?

An overview of Microsoft Excel functions

(Large) Data Analysis techniques and Data visualization in Excel

This one single course will be comprehensive to cover the basic knowledge of Excel required for day to day work

You can watch the FREE course previews in the CURRICULUM section.

Read through the entire CURRICULUM section if you can.

All modules with details of lectures are provided.


What  next?

Well, we sincerely hope to see you inside the course.

We wish you well and good luck.

Still confused? Don't hesitate to reach out.

Who this course is for:

  • Anyone who wants to learn Excel completely
  • Business analysts
  • Financial Analysts
  • Consultants
  • Start up founders
  • Project Managers
  • College students

Report abuse