Microsoft Excel Skills - Intermediate Level
Learn advanced Excel to extract information from large data, aggregate data meaningfully & make dynamic models
What will I learn in this course?
- Data analysis in Excel
- Data manipulation in Excel
- Build dynamic and flexible models
- Data aggregation in Excel
- Data synthesis in Excel
- None. We will teach everything from scratch.
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 with the Strategy and Corporate Finance practice at McKinsey, the world’s most prestigious consulting company. He has advised clients globally on various Strategy and Finance engagements.
Ashish is also the founder of an education firm SKILLFIN LEARNING which curates content in Business, Finance and Data Analysis topics. He conducts corporate trainings in a leading global consulting firm. He is passionate about teaching and strongly believes education should be accessible and affordable to all.
PreviewLecture 1: Introduction to the course (2:57)
StartLecture 2: Download the excel template for this module (0:34)
PreviewLecture 3: Understanding the LIST function (5:45)
StartLecture 4: Understanding the OFFSET function (8:30)
StartLecture 5: Understanding the SUMPRODUCT function (8:24)
StartLecture 6: Understanding the GOAL SEEK function (8:29)
StartLecture 7: Understanding the INDEX-MATCH function (18:54)
StartLecture 8: Understanding the PIVOT function (11:14)
StartLecture 9: Understanding the INDIRECT function (11:31)
StartLecture 10: Practice Assignment #1: DIFFICULTY LEVEL - MEDIUM
StartLecture 11: Solution to Practice Assignment #1
StartLecture 12: End of course
StartLecture 13: Please provide us your valuable feedback on the course thus far