Advanced Excel Functions
What Will I Learn?
- Data analysis in Excel
- Data manipulation in Excel
- Build dynamic and flexible models
- Data aggregation in Excel
- Data synthesis in Excel
Course Content
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
About the instructor
33 Courses
206 students
Very insightful with practical examples
good
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.