Introduction2:57
Download the excel template for the exercises0:03
Understanding the list function5:45
Explore the list function in Excel to create a drop-down via data validation. Link the source data (B5 to B8) to let users select from four scenarios, enabling dynamic models.
Understanding the offset function8:30
Understanding the sumproduct function8:24
Learn how the sumproduct function multiplies arrays and sums the results to compute totals, including conditional use with a double hyphen sign to filter by stock in a trading example.
Understanding goal seek functionality8:29
Understanding index-match function18:54
Learn to extract data from three-dimensional data in Excel using index and match, by locating state, month, and year positions and retrieving the corresponding value.
Understanding the pivot function11:14
Understanding the indirect function11:31
Practice Assignment: DIFFICULTY LEVEL - MEDIUM0:37
SOLUTION TO PRACTICE ASSIGNMENT0:04
Please review our course - we need your feedback0:19
Queries - contact us0:10
Please provide us your valuable feedback0:43

Requirements

Description

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.