Master Excel Functions: Unlock the Power of Formulas for Enhanced Data Analysis
Your Instructor
Hello all! My name is Mihai Petrisor, and I am honored to have the privilege of guiding you through Excel from beginner to advanced techniques. I would like to take a minute and give you a little bit of background about me, and how I became hooked on Excel.
I attended the Economics Studies Academy and earned a Masters in Investments. Having worked in Finance since 2007, I love figures and the dynamic environment of finance. I work daily with big data files, and Excel is my best friend.
Finance is the engine of each business, and Excel is the perfect tool to leverage a company's reports. I know you will find all the content in my courses useful. I will be happy to hear that you use what you learn in your day to day tasks.
I am truly a lifelong learner of all things techy. I look forward to serving all of you, and hope you get the Excel bug just like I did!
Course Curriculum
-
Start1. What will we learn in this section (1:33)
-
Start2. Create An If() Function (3:24)
-
Start3. Nest And() Andor Or() Functions Within Reference Functions (6:37)
-
Start4. Work With Choose(), Vlookup(), Index(), And Match() Functions (6:19)
-
Start5. Create A Vlookup() Function (3:32)
-
Start6. Section Summary (9:37)
-
StartSource Files
-
Start1. What will we learn in this section (2:23)
-
Start2. Aggregate Data Using Both The Sum And Subtotal Functions (5:15)
-
Start3. Calculate minimums, maximums and averages from data sets (3:39)
-
Start4. Use the Forecast function to forecast numbers along a trend (6:57)
-
Start5. Generate a net present value using a formula (6:13)
-
Start6. Section Summary (7:38)
-
StartSource Files