Data Analytics & Story-Telling Techniques in Excel

Data Analytics & Story-Telling Techniques in Excel, available at $34.99, has an average rating of 4.29, with 47 lectures, based on 217 reviews, and has 4879 subscribers.

You will learn about 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 This course is ideal for individuals who are Business analysts or Data analysts or Financial analysts or Investment bankers or Consultants or Executive Assistants or Start-up founders It is particularly useful for Business analysts or Data analysts or Financial analysts or Investment bankers or Consultants or Executive Assistants or Start-up founders.

Enroll now: Data Analytics & Story-Telling Techniques in Excel

Summary

Title: Data Analytics & Story-Telling Techniques in Excel

Price: $34.99

Average Rating: 4.29

Number of Lectures: 47

Number of Published Lectures: 46

Number of Curriculum Items: 47

Number of Published Curriculum Objects: 46

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will 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

Who Should Attend

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

Target Audiences

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

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course introduction: 5 step framework for Data to Insights

Lecture 2: Step 1: Comprehend the DATA

Lecture 3: Download the spreadsheet for this course

Lecture 4: Step 1: Data set to be used for the project in the course

Lecture 5: Step 2: Ask right QUESTIONS

Lecture 6: Step 2: Questions for the project in the course

Lecture 7: Step 3: Data Analysis #1 – Part 1

Lecture 8: Step 3: Data Analysis #1 – Part 2

Lecture 9: Step 3: Data Analysis #1 – Part 3

Lecture 10: Step 3: Data Analysis #1 – Part 4

Lecture 11: Step 3: Data Analysis #1 – Part 5

Lecture 12: Step 3: Data Analysis #2 – Part 1

Lecture 13: Step 3: Data Analysis #2 – Part 2

Lecture 14: Step 3: Data Analysis #2 – Part 3

Lecture 15: Step 3: Data Analysis #2 – Part 4

Lecture 16: Step 3: Data Analysis #2 – Part 5

Lecture 17: Step 3: Data Analysis #2 – Part 6

Lecture 18: Step 3: Data Analysis #2 – Part 7

Lecture 19: Step 3: Data Analysis #2 – Part 8

Lecture 20: Step 3: Data Analysis #2 – Part 9

Lecture 21: Step 3: Data Analysis #2 – Part 10

Lecture 22: Step 3: Data Analysis #3 – Part 1

Lecture 23: Step 3: Data Analysis #3 – Part 2

Lecture 24: Step 3: Data Analysis #3 – Part 3

Lecture 25: Step 3: Data Analysis #4 – Part 1

Lecture 26: Step 3: Data Analysis #4 – Part 2

Lecture 27: Step 3: Data Analysis #4 – Part 3

Lecture 28: Step 3: Data analysis #4 – Part 4

Lecture 29: Step 3: Data Analysis #4 – Part 5

Lecture 30: Step 4: Deriving INSIGHTS from data analysis

Lecture 31: Step 4: Deriving insights from data analysis #1 – part 1

Lecture 32: Step 4: Deriving insights from data analysis #1 – part 2

Lecture 33: Step 4: Deriving insights from data analysis #1 – part 3

Lecture 34: Step 4: Deriving insights from data analysis #1 – part 4

Lecture 35: Step 4: Deriving insights from data analysis #2 – part 1

Lecture 36: Step 4: Deriving insights from data analysis #2 – part 2

Lecture 37: Step 4: Deriving insights from data analysis #3 – part 1

Lecture 38: Step 4: Deriving insights from data analysis #3 – part 2

Lecture 39: Step 4: Deriving insights from data analysis #3 – part 3

Lecture 40: Step 4: Deriving insights from data analysis #3 – part 4

Lecture 41: Step 4: Deriving insights from data analysis #4

Lecture 42: Step 4: Conclusion

Lecture 43: Quick recap of the course

Lecture 44: Practice Assignment : DIFFICULTY LEVEL – MEDIUM

Lecture 45: SOLUTION TO PRACTICE ASSIGNMENT

Lecture 46: Please provide us your valuable feedback

Instructors

Ashish Agarwal
15+ years in Business & Finance, ex-McKinsey & ex-BlackRock

Rating Distribution

1 stars: 8 votes
2 stars: 7 votes
3 stars: 33 votes
4 stars: 82 votes
5 stars: 88 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu