Data Analytics Module 1

0% Complete

0/21 Steps

Course Content

Expand All

Study Material for mentorship program

Welcome, Watch me first!

Starting with Microsoft Excel 8 Topics

Expand

Lesson Content

0% Complete 0/8 Steps

Class 1: How to start MS Excel

Class 2: File option (Home & New)

Class 3: Save and publish option in MS Excel

Class 4: Formula Part 1(Sum, Average, Minimum, Maximum, Count)

Class 5: Formula Part 2(Small, Large, Basic Charts)

Class 6: Conditional Formatting

Class 7: Filter & Sorting

Class 8: Data Validation

Going Advance in Microsoft Excel 9 Topics

Expand

Lesson Content

0% Complete 0/9 Steps

Class 9: Subtotal Copy

Class 10: Text Function

Class 11: Vlookup

Class 12: Pivot Part 1 Copy Copy

Class 13: Pivot Part 2 Copy Copy

Class 14: Pivot Part 3 Copy Copy

Class 15: Simple IF Copy Copy

Class 16: Advance IF Copy Copy

Class 17: Date & Time Copy Copy