Advanced Excel functions

Learn advanced [ excel to extract information from large data, aggregate data meaningfully & make dynamic models

4.25 (69 reviews)

Udemy

platform

English

language

Money Management Tools

What you will learn

Data analysis in Excel

Data manipulation in Excel

Build dynamic and flexible models

Data aggregation in Excel

Data synthesis in Excel

Why take this course?

Welcome to our awesome Advanced Excel functions course

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 some advanced Excel functions, 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?

(Large) Data Analysis techniques, Data Manipulation methods in Excel

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.

Screenshots

Advanced Excel functions - Screenshot_01

Advanced Excel functions - Screenshot_02

Advanced Excel functions - Screenshot_03

Advanced Excel functions - Screenshot_04

Reviews

Bharathram

December 14, 2019

Your Advanced excel functions to analyze large data was good As the name tell advance Excel course Sumproduct you had said to use minus sign, you could have also told the usage of * and + in sumproduct Pivot i was expecting you will tell the usage of Analyze & Design tab in the Pivot Indirect i liked the way you had described the usage with the helper columns & row. I liked the course very much it gave me to rethink the usage of index & match with indirect function Thanks

Shadrack

April 1, 2019

It was great, i think it covered all the important functions for any finance professional who wants to be better at their excel knowledge. i really learned a lot and will definitely use the knowledge to be better at my workplace. thank you.

Kristin

August 22, 2018

The concepts were clear and taught concisely, and the instructor was easy to follow and understand. However, the practice assignments that were provided were a huge disappointment. Being able to complete the assignments would have helped connect the functions just learned to some real-world applications, but unfortunately, they were presented using examples that require more than a basic understanding of the calculations needed for stock returns and market capitalization - there was no forewarning that knowledge of the banking industry would be required to complete the course, so it was very disappointing to have the assignments be geared only toward this one industry when banking has nothing specific to do with utilization of the Excel functions that were being taught.

Jadde

May 30, 2017

Very informative course. Really enjoyed being able to follow along as instructor taught the material. Would have enjoyed a slightly louder audio of the videos, but other than that course was extremely helpful.

jach

July 30, 2016

Good Course, too many assumptions, the practice test are great - but how did they create those great excel sheets! that is a mystery

Don

April 6, 2016

I didn't find this particularly useful. I am an advanced user of Excel and have experience in analysis that goes beyond what is presented in this course. I also found that the content of this course is not well presented for my style of learning.

Patrick

February 23, 2016

The audio improved since the first course. I liked the examples and the extra assignments at the end. Detailed content in the lecture videos.

Aditya

February 2, 2016

Was introduced to some of the functions used for Analytics in an effective cum efficient manner. Instructions were loud and clear. Thank you, for this course. Looking forward to other courses from you.

Emmanuel

January 27, 2016

You will learn the complex workings of each functions, however more examples of how to apply the functions would be useful

Simon

January 15, 2016

Inclusion of the spreadsheet is particularly helpful for enabling the student to practice what they are learning, thereby reinforcing the lessons.

Charts

Price

Rating

Enrollment distribution

Advanced Excel functions - Distribution chart