Advanced Course on Data Analysis Using Excel

Himanshu Arora

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

Ended on Apr 28

Apr 3 - Apr 28, 2021

8 lessons

0 practices

0 questions by educators

Schedule

Apr 3 - Apr 28

8 lessons

Apr

3

Date & Time Functions - Day, Hour, Minute, Date, Today, Now and more

Lesson 1 • Apr 3 • 1h 1m

Apr

7

Nesting of Functions - Nesting of IF, AND, OR

Lesson 2 • Apr 7 • 1h 1m

Apr

10

Practical Applications of Nesting of Functions

Lesson 3 • Apr 10 • 59m

Apr

14

Real Life cases on Nesting of Functions for making Dashboards

Lesson 4 • Apr 14 • 1h

Apr

17

Conditional Formatting using Formulas

Lesson 5 • Apr 17 • 59m

Apr

24

Data Tools, Drop-Down Lists, Text to Columns & Goal Seek Advanced Filtering

Lesson 6 • Apr 24 • 1h 2m

Apr

27

Creating Sparklines and Mapping Data

Lesson 7 • Apr 27 • 57m

Apr

28

Data Analysis - Doubt Clearing session

Lesson 8 • Apr 28 • 1h 2m