Advanced Excel Functions

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

Categories Excel
4.89(9 Ratings)

What I will learn?

  • Data analysis in Excel
  • Data manipulation in Excel
  • Build dynamic and flexible models
  • Data aggregation in Excel
  • Data synthesis in Excel

Course Curriculum

Module 1: Intermediate Excel Functions To Analyze Large Data

  • 01:07
  • 02:53
  • Download the Excel spreadsheet for this module
    00:00
  • 05:46
  • Understanding the OFFSET function
    08:31
  • Understanding the SUMPRODUCT function
    08:25
  • Understanding the GOAL SEEK function
    08:30
  • Understanding the INDEX-MATCH function
    18:55
  • Understanding the PIVOT function
    11:12
  • Understanding the INDIRECT function
    11:32
  • Practice Assignment #1: DIFFICULTY LEVEL – MEDIUM
    00:00
  • Solution to Practice Assignment #1
    00:00
  • End of course
    00:51

Student Feedback

Excellent
8
Very Good
1
Average
0
Poor
0
Terrible
0
4.9
9 Reviews

Perfect explanations to all of the complex excel functions which are listed in the module.

I recently completed the "Advanced Excel Functions" course, and I found it to be a valuable resource for expanding my proficiency in Microsoft Excel. This course is suitable for individuals looking to deepen their understanding of Excel and leverage its advanced functions for data analysis and automation.

While the course was highly informative and expanded my Excel skills, I've rated it four stars because there's always room for improvement, particularly in terms of providing more complex real-world scenarios for practice. Nevertheless, it was a valuable course for enhancing Excel proficiency and is recommended for those seeking to take their Excel skills to the next level.

It is very useful course and advance excel functions like indirect, goal seek and 3 dimensional Index Match.. Very Clear to Explained.

Explain Useful Techniques and Practical Examples also Provided

it's good

I am thrilled to share my glowing review of the "Mastering Advanced Excel Functions" course. This course offers a comprehensive and in-depth exploration of Excel's advanced functions, catering to both beginners and experienced users looking to enhance their data analysis and manipulation skills. The course content, expert instruction, and practical application make it an invaluable resource for anyone seeking to excel in data-driven tasks.

Great to learn these advance excel functions like indirect, goal seek and 3 dimensional Index Match.. This requires a lot of practice although to get comfortable in these.. thank you. Highly recommended.

Good practical examples provided

Requirements

  • None. We will teach everything from scratch.

Material Includes

  • 30 day access
  • 1.5 hours on-demand video
  • Access on mobile
  • Certificate of Completion

FAQ's

How does the certification program work?

We have created short courses on specific skills that you will need to master in the business and finance domain. Once you go through the recorded lessons and attend practice sessions online, you will need to finish a short assessment like a quiz and an assignment and send it over. We will review your submission and send you back a score. If you obtain more than 80% result, we will award you a certification for the same.

How long does it take to complete the certification?

We have divided the certifications into very specific modules to make it very easy for you to complete any one certification in the least time possible. But really the pace of completing the certification is up to you. As soon as you send us your assignment, we will take 2-3 days to review and send over your result. So whenever you are ready, you should complete the assessment and get certified.

Can you retake the assessments?

Yes you can, we allow you to make 10 submissions per certification to ensure you have enough opportunities to clear and get certified.

Do I have access to the materials even after completing the certifications?

Yes, as long as you have an active membership, you will continue to have access to all resources to the certification.

Will I get a certification for the individual courses?

Yes, each course will have a certification provided on successful completion and taking the assessment successfully at the end of the program

Can I upload my certification online?

Yes, we will provide a LinkedIn verifiable certificate in different formats that you can add on your social media profile to get access to more opportunities. For example, You can add the certificate under the certification section of LinkedIn where recruiters look at to understand the different skills you possess.

How will we support me to find more opportunities?

We have a very active LinkedIn presence where we will showcase your certifications on completion. Ideally the more the certifications you complete the better will your chances to be noticed by other members of our LinkedIn community. Our push to your profile will potentially lead to more opportunities coming your way.

Ashish is a Business and Finance Expert with around 10 years of experience in this domain. Previously, he has worked with BlackRock, the world’s largest asset management company, as a Vice President in the Financial Markets Advisory (FMA) team. Prior to that, he worked at McKinsey in the Strategy and Corporate Finance practice. He is also the founder of the website skillfinlearning.com which creates online programs in Business, Finance and Data Analysis topics. At Skillfin Learning, we believe we can change the way we adults learn.

Student Ratings & Reviews

4.9
Total 9 Ratings
5
8 Ratings
4
1 Rating
3
0 Rating
2
0 Rating
1
0 Rating
D
3 months ago
Perfect explanations to all of the complex excel functions which are listed in the module.
J
6 months ago
I recently completed the "Advanced Excel Functions" course, and I found it to be a valuable resource for expanding my proficiency in Microsoft Excel. This course is suitable for individuals looking to deepen their understanding of Excel and leverage its advanced functions for data analysis and automation.
LG
7 months ago
While the course was highly informative and expanded my Excel skills, I've rated it four stars because there's always room for improvement, particularly in terms of providing more complex real-world scenarios for practice. Nevertheless, it was a valuable course for enhancing Excel proficiency and is recommended for those seeking to take their Excel skills to the next level.
A
7 months ago
It is very useful course and advance excel functions like indirect, goal seek and 3 dimensional Index Match.. Very Clear to Explained.
J
8 months ago
Explain Useful Techniques and Practical Examples also Provided
JA
8 months ago
it's good
D
8 months ago
I am thrilled to share my glowing review of the "Mastering Advanced Excel Functions" course. This course offers a comprehensive and in-depth exploration of Excel's advanced functions, catering to both beginners and experienced users looking to enhance their data analysis and manipulation skills. The course content, expert instruction, and practical application make it an invaluable resource for anyone seeking to excel in data-driven tasks.
R
9 months ago
Great to learn these advance excel functions like indirect, goal seek and 3 dimensional Index Match.. This requires a lot of practice although to get comfortable in these.. thank you. Highly recommended.
ashish_agarwal
1 year ago
Good practical examples provided

Pick a plan

Enrollment validity: Membership Wise
This content is for Free Trial members only.
Login Join Now