Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Data Analytics & Story-Telling Techniques in Excel
Rating: 4.5 out of 5(1,042 ratings)
6,991 students

Data Analytics & Story-Telling Techniques in Excel

Learn story-telling with data skills to derive insights from raw data using slicers, pivot-tables and graphs in Excel
Created byAshish Agarwal
Last updated 3/2026
English

What you'll learn

  • Create pivot-tables and pivot-graphs in Excel
  • Use slicers in Excel for data mining
  • Undertake data analysis in Excel
  • Create data visualization charts in Excel
  • Derive actionable insights from data analysis
  • Undertake management level discussions on data insights

Course content

1 section • 46 lectures • 1h 30m total length

  • Course introduction: 5 step framework for Data to Insights2:37
  • Step 1: Comprehend the DATA1:10
  • Download the spreadsheet for this course0:34
  • Step 1: Data set to be used for the project in the course3:18
  • Step 2: Ask right QUESTIONS2:10

    Analyze the dataset to answer questions about student enrollments and course ratings, using the data to insights framework to explore year-on-year trends, best selling courses, and yearly performance.

  • Step 2: Questions for the project in the course1:41
  • Step 3: Data Analysis #1 - Part 12:10

    Analyze year-on-year student enrollment trends using pivot tables and pivot charts in Excel, selecting the data range and placing the PivotTable on the worksheet to reveal answers to key questions.

  • Step 3: Data Analysis #1 - Part 22:18
  • Step 3: Data Analysis #1 - Part 31:25
  • Step 3: Data Analysis #1 - Part 41:54
  • Step 3: Data Analysis #1 - Part 52:46
  • Step 3: Data Analysis #2 - Part 11:56
  • Step 3: Data Analysis #2 - Part 22:41
  • Step 3: Data Analysis #2 - Part 32:53

    Add data labels to the pivot chart, convert enrollments to a percentage of the grand total, and interpret the doughnut chart to reveal top and bottom courses over six years.

  • Step 3: Data Analysis #2 - Part 40:35

    Edit the chart title textbox to 'Course wise enrollment' and analyze which course was the best selling over the last 6 years by comparing enrollment percentages across five courses.

  • Step 3: Data Analysis #2 - Part 52:49
  • Step 3: Data Analysis #2 - Part 61:33

    Create a pivot table and pivot chart to display the percentage enrollments for all courses across all years in a single stacked column chart, enabling year-by-year comparison.

  • Step 3: Data Analysis #2 - Part 73:03
  • Step 3: Data Analysis #2 - Part 81:31

    Convert the absolute enrollments by course and year into a 100% stacked column chart to reveal proportional shares from 2012 to 2017, using the pivot chart method.

  • Step 3: Data Analysis #2 - Part 93:30
  • Step 3: Data Analysis #2 - Part 101:04
  • Step 3: Data Analysis #3 - Part 13:46
  • Step 3: Data Analysis #3 - Part 21:37

    Convert a pivot chart from a column to a plain line chart to reveal year-over-year ratings, then add data labels above the line to show 2012–2017 ratings.

  • Step 3: Data Analysis #3 - Part 33:10

    Add a course name slicer to a pivot chart to view year-over-year ratings by course, toggle or multi-select courses, and analyze course-wise trends from 2012 to 2017.

  • Step 3: Data Analysis #4 - Part 11:47
  • Step 3: Data Analysis #4 - Part 22:11
  • Step 3: Data Analysis #4 - Part 32:15
  • Step 3: Data analysis #4 - Part 41:16
  • Step 3: Data Analysis #4 - Part 53:35

    Learn how to use an Excel slicer to filter course ratings by year and compare average ratings across years to identify top courses.

  • Step 4: Deriving INSIGHTS from data analysis3:04

    Apply the data to insights framework to derive actionable observations from enrolments and ratings, using a rankings approach and color indicators to guide corrective actions.

  • Step 4: Deriving insights from data analysis #1 - part 11:57
  • Step 4: Deriving insights from data analysis #1 - part 21:29

    Analyze year-over-year trends for course number 1, noting a strong rise from 2012 to 2016 and a muted 2017, with an orange circle highlighting the six-enrolment change.

  • Step 4: Deriving insights from data analysis #1 - part 31:00

    Analyze year-on-year enrolment trends for course 2, noting a 2017 drop from 900 to 860 and prompting management to consider corrective actions.

  • Step 4: Deriving insights from data analysis #1 - part 43:03
  • Step 4: Deriving insights from data analysis #2 - part 11:03
  • Step 4: Deriving insights from data analysis #2 - part 21:17
  • Step 4: Deriving insights from data analysis #3 - part 11:41
  • Step 4: Deriving insights from data analysis #3 - part 20:54
  • Step 4: Deriving insights from data analysis #3 - part 30:59
  • Step 4: Deriving insights from data analysis #3 - part 42:37
  • Step 4: Deriving insights from data analysis #42:27
  • Step 4: Conclusion2:29
  • Quick recap of the course2:27
  • Practice Assignment : DIFFICULTY LEVEL - MEDIUM0:15
  • SOLUTION TO PRACTICE ASSIGNMENT0:04
  • Please provide us your valuable feedback0:44

    Share your valuable feedback on the course so far to help us improve data analytics and storytelling techniques in Excel for students worldwide.

Requirements

  • None. We will teach everything from scratch.

Description

Hey, welcome to our latest course Advanced Data Analytics in Excel online course. 

We are glad to see you visit this course. 

If only we could shake hands!


What is this course about?

In this course, we will teach you the comprehensive data analysis skills to derive insights from data.

We will illustrate the following broad content topics in great detail in this course:

1) Data mining using slicers, pivot-tables and pivot-graphs in Excel

2) Data analysis in Excel

3) Deriving actionable insights from data analysis

4) Undertake management level discussion on key insights from data analysis

It is a very comprehensive course that will teach you the complete skills to do advanced data analysis in Excel.


How is this course useful for YOUR purpose?

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

 Are you are or aspiring to be a Data Analyst, Business Analyst, Financial Analyst or a BI Analyst?

Do you love to play with large data sets?

If yes, then this course may be a great one for you to start building your expertise in advanced data analysis in Excel. 

Analysts are required to play with large data all the time.

You need to analyze, aggregate, extrapolate, etc with the data sets to identify meaningful trends in the data. 

Fortunately, there are lots of tools that can make your work easy if you knew how to use them.

In this course, we teach you how to do all of the above using advanced data analysis tools in Excel 

The course covers Pivot Tables, Pivot Graphs & Slicers. 

These are some of the very cool and powerful functionalities in-built in Excel that can help you do your work better.

You have lifetime access to the course once you enroll. 

So even if you don't plan to start now, you can still enroll and come back anytime later.


What makes this course different than others?

This course content is unique!

You will learn exactly what you are required to do in your daily work.

You get access to practical real life illustrations of all key skills to derive insights from data analysis.

It is a completely hands-on course.

You need to carry out the illustrations in the course along with the instructor.

We provide you the same set up as the instructor. 

All illustration spreadsheets can be downloaded at your end.

You will feel as if somebody is guiding you step by step in all illustrations.

It is a very practical on the job training for you.

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

He makes it very engaging and fun learning experience.

You will have practice assignments to test your learning from the course

The Practice Assignments are marked with varying difficulty levels - High, Medium and Low.

You will have unlimited access to our support.

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

Feel free to refer to them in case you feel the need.

And of course, the price is competitive. 


What are other students saying about this course?

Check our our reviews below.

Read what student Erika Loots wrote - 

"I really enjoyed the course and was sad when it ended, would love to learn more on the topic of Data Analysis. The instructions are clear and very easy to follow. Thank you very much for a great course! Looking forward to learning more from you."

Go to the reviews section below to read more such stories.


What if YOU do not like the course?

Well, we will be very sad to hear that you did not like the course.

But you are well protected.

You have a 30 day money back guarantee in case you are not happy with the course.

No questions asked.

But we sincerely hope, you will definitely like the course!



What  next?

If there are any doubts, don't hesitate to reach out to us.

Start learning now.

See you inside the course.


Who this course is for:

  • Business analysts
  • Data analysts
  • Financial analysts
  • Investment bankers
  • Consultants
  • Executive Assistants
  • Start-up founders

Report abuse