Advanced Excel functions (Udemy.com)
Learn advanced [ excel to extract information from large data, aggregate data meaningfully & make dynamic models
Created by: Ashish Agarwal
Last updated August 2026
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
How it compares
Against the other 355 rated Udemy courses in Excel on CourseDuck:
- Rating4.6 out of 5higher than 63% of them
- Reviews1,559#137 of 356 by number of reviews
- Length1.3 hoursshorter than 92% of them
- Last updatedAugust 2026more recently than 91% of them
Course 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.
Instructor Details
- 4.6 Rating
1,559 Reviews
Ashish Agarwal
Ashish Agarwal is a Business and Finance Expert with around 15 years of experience in this domain. He is currently a full-time instructor helping participants sharpen Business, & Finance skills through video courses and live programs.
He started his career in 2009 at McKinsey & Co. in the Strategy & Corporate Practice at the Firm. He has advised clients globally on various Strategy and Finance engagements. In 2016, he joined BlackRock, the world’s largest asset management company, as a Vice President in the Financial Markets Advisory (FMA) team. Since 2017, he has been conducting online training programs on Udemy as well as conducting live virtual and in person business and finance programs for large companies globally.
More courses by Ashish Agarwal
Excel: Data cleaning and analysis techniques (2026)
4.5 (5,467 Reviews)
Provider: Udemy
Time: 1h
$69.99
Data Analytics & Story-Telling Techniques in Excel (2026)
4.5 (1,379 Reviews)
Provider: Udemy
Time: 1.5h
$34.99
Finance Training for Financial Analysts (2026)
4.4 (1,354 Reviews)
Provider: Udemy
Time: 9.8h
$12.99
More Excel courses
Microsoft Excel Data Analysis - Learn How The Experts Use It (2026)
5.0 (5,696 Reviews)
Provider: Udemy
Time: 3h
$39.99
Microsoft Excel: Advanced Dashboard Design (Project-Based!) (2026)
4.9 (4,868 Reviews)
Provider: Udemy
Time: 6.4h
$99.99
Master NEW Excel Functions in Office 365 & Office 2021+
4.8 (5,262 Reviews)
Provider: Udemy
Time: 7.1h
$15.99
Microsoft Excel Certification Exam Prep: MO-201 Excel Expert (2026)
4.8 (3,239 Reviews)
Provider: Udemy
Time: 8.6h
$119.99
Reviews
By Hadeel M.N. Al-Sadiq on 11/4/2025
It was so helpful to me and thought me a lot about advanced functions in Excel which will help me to make a good progress in my job.
By Richard Sollers on 10/29/2025
Great course with plenty of examples of forumlas and how to create different tables and visuals with Excel. Sound was a little hard to hear even with the volume on high. I took plenty of notes which will allow me to refer back to these formulas to use them in the future.
By Vebbie Chan on 8/1/2025
The case studies in the course is pretty easy and straight forward, but the assignments are complicated to apply back to the understanding learnt from the course.
By Anonymized User on 2/25/2025
Yes ! I already knew some of the functions, but discovering index-match with 3 dimensions, the indirect function and goal seek was great
By Bharathram C N on 12/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
By Shadrack Sihlangu on 4/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.
By Jadde Rowe on 5/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.
By Anonymized User on 2/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.
By Aditya Vikram on 2/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.
By Simon James on 1/14/2016
Inclusion of the spreadsheet is particularly helpful for enabling the student to practice what they are learning, thereby reinforcing the lessons.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100












