Advanced Level Course in MS Excel - Part I

Himanshu Arora

Master the Excel domain, so that you can use your data for what it is truly needed for - for analysis. Analyzing Data and putting it into use, is an efficient mindset, where you work smarter and grow faster. Read more

Ended on Sep 24

Sep 3 - Sep 24, 2021

4 lessons

0 practices

0 questions by educators

Schedule

Sep 3 - Sep 24

4 lessons

Sep

3

Editing Formula, Mathematical Functions- Sum, Sumif, Countif, Countifs, Averageif/ifs

Lesson 1 • Sep 3 • 58m

Sep

10

Statistical Functions- Correlation, Std Dev, Mean, Variance, Covariance

Lesson 2 • Sep 10 • 1h

Sep

17

Financial Functions, PMT, PV, FV NPV, IRR, NPER

Lesson 3 • Sep 17 • 1h 3m

Sep

24

Practical application of Financial Functions-Loan amortization schedule

Lesson 4 • Sep 24 • 59m