Basic Course on Data Analysis

Himanshu Arora

In this course, Himanshu Arora will cover Data Analysis. All the important topics will be discussed in detail. Learners at any stage of their preparations will be benefited from the course. The course will be co... Read more

Ended on Mar 27

Mar 3 - Mar 27, 2021

8 lessons

0 practices

0 questions by educators

Schedule

Mar 3 - Mar 27

8 lessons

Mar

3

Mathematical Functions- Sum, Sumif, Sumifs, Countif, Countifs, Averageif/ifs

Lesson 1 • Mar 3 • 1h 2m

Mar

6

Logical Functions- AND, OR, NOT, TRUE, FALSE, IF, IFERROR, IS

Lesson 2 • Mar 6 • 1h 3m

Mar

10

Lookup functions- Vlookup, Hlookup

Lesson 3 • Mar 10 • 1h

Mar

13

Lookup Functions Alternatives - Index, Match & Doubt Clearing Session

Lesson 4 • Mar 13 • 1h 3m

Mar

17

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

Lesson 5 • Mar 17 • 1h 3m

Mar

20

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

Lesson 6 • Mar 20 • 1h 2m

Mar

24

Practical Application of Financial Functions - Loan Amortization Schedule

Lesson 7 • Mar 24 • 1h 1m

Mar

27

Text Functions - Left, Right, Mid, Upper, Lower, Substitute, Replace & Doubt Clearing Session

Lesson 8 • Mar 27 • 1h 2m