ICM Advance Course

0% Complete

Last activity on February 8, 2024 10:44 pm

Course Content

Expand All

Study Material of Mentorship Program

Week 1: Basics Of Ms Excel 16 Topics

Expand

Lesson Content

0% Complete 0/16 Steps

Introduction of Ms Excel

Class 1: Basic Functions of Excel Part 1

Class 2: Basic Functions of Excel Part 2

Class 3: Text Function Part 1

Class 4: Text Function Part 2

Class 5: Date Function Part 1

Class 6: Date Function Part 2

Class 7: Date Function Part 3

Class 8: Date Function Part 4

Class 9: Date Function Part 5

Class 10: Data Base Function Part 1

Class 11: Data Base Function Part 2

Class 12: Information Function Part 1

Class 13: Information Function Part 2

Class 14: Information Function Part 3

Class 15: Information Function Part 4

Week 2: Going Advance in Ms Excel 16 Topics

Expand

Lesson Content

0% Complete 0/16 Steps

Class 16: Count Function Part 1

Class 17: Count Function Part 2

Class 18: Count Function Part 3

Class 19: Lookup & Reference Functions Part 1

Class 20: Lookup & Reference Functions Part 2

Class 21: Lookup & Reference Functions Part 3

Class 22: Lookup & Reference Functions Part 4

Class 23: Lookup & Reference Functions Part 5

Class 24: Sorting and Filteration (Feature) Part 1

Class 25: Sorting and Filteration (Feature) Part 2

Class 26: Sorting and Filteration (Feature) Part 3

Class 27: Macros Part 1

Class 28: Macros Part 2

Class 29: Macros Part 3

Class 30: Macros Part 4

Class 31: Macros Part 5

Week 3: Advance Ms Excel Part 1 14 Topics

Expand

Lesson Content

0% Complete 0/14 Steps

Class 33: Logical Function Part 2

Class 34: Logical Function Part 3

Class 35: Logical Function Part 4

Class 36: Logical Function Part 5

Class 37: Logical Function Part 6

Class 38: Logical Function Part 7

Class 39: Data Validation Part 1

Class 40: Data Validation Part 2

Class 41: Data Validation Part 3

Class 42: Data Validation Part 4

Class 43: Data Validation Part 5

Class 44: What If Analysis Part 1 (Goal Seek)

Class 45: What If Analysis Part 2 (Data Table)

Class 46: What If Analysis Part 3 (Solver)

Week 4 : Advance Ms Excel Part 2 17 Topics

Expand

Lesson Content

0% Complete 0/17 Steps

Class 47: Filtration Function Part 1

Class 48: Filtration Function Part 2

Class 49: Filtration Function Part 3

Class 50: Auditing Part 1

Class 51: Auditing Part 2

Class 52: Auditing Part 3

Class 53: Auditing Part 4

Class 54: Data Protection Part 1

Class 55: Data Protection Part 2

Class 56: Data Protection Part 3

Class 57: Data Protection Part 4

Class 58: Financial Functions Part 1

Class 59: Financial Functions Part 2

Class 60: Financial Functions Part 3

Class 61: Financial Functions Part 4

Class 62: Financial Functions Part 5

Class 63: Financial Functions Part 6

Week 5 : Starting with PowerBI 15 Topics

Expand

Lesson Content

0% Complete 0/15 Steps

Study Material For PowerBi

PowerBI software Installation

Introduction Of Data Analytics expert and Course Flow

Class 1: Introduction To Power BI

Class 2: Power BI Architecture

Class 3: Components

Class 4: Power Bi Desktop

Class 5: Formatting the chart

Class 6: Formatting Inserting Textbox and Image

Class 7: Data From Excel & Stacked File

Class 8: Data hierarchy

Class 9: Maps and User defined Hierarchy

Class 10: Cards interaction

Class 11: Scatter & interactions chart

Class 12: Filters pane

Week 6: Going Advance in Power BI 12 Topics

Expand

Lesson Content

0% Complete 0/12 Steps

Class 13: Themes

Class 14: Different Charts

Class 15: Introduction Power Query( data transformation)

Class 16: Split Column

Class 17 : Group By

Class 18 : Data cleansing Activity

Class 19 : Appént Data

Class 20: Merge Queries

Class 21 : Replace value

Class 22 : Transform and add column

Class 23 : Data Profiling & Column profiling

Class 24 : pivot and unpivot

Week 7: Advance Power BI 12 Topics

Expand

Lesson Content

0% Complete 0/12 Steps

Class 25: Data Modeling concept

Class 26: Data Modeling Implement

Class 27: Cross filter Direction

Class 29: Dax Time Intelligence and Map shorting

Class 30: DAX SWITCH AND IF

Class 31: Dax measures and calculate

Class 32: Dax Time Intelligence

Class 33: Power Bi Service

Class 34: Power gateways and workspace

Class 35: Row level Security

Class 36: Connection to sequel server

Week 8 : Powerpoint 7 Topics

Expand

Lesson Content

0% Complete 0/7 Steps

Week 9 : Advance Powerpoint (Bonus) 6 Topics

Expand

Lesson Content

0% Complete 0/6 Steps