Part 1:

● Introduction to Data Analytics

● Component of Data Analytics

● Tools need to be a Data analyst

● Scope of a Data Analyst

● Why Data Analyst

● Cell formatting: Copy, Cut and Paste

● Formatting Shortcut

● Text function (Join and Split)

● Freezing Panes

Part 2:

● Cell referencing (Relative vs absolute)

● Self-Finance handle in Excel

● Conditional formatting

● Data Structure: Shorting and Filtering

● Customizing header and footer

● Using Print area and print related tutorial Excel 

Part 1:

● Logical Function(Filter ,IF, And , OR )

● Carefulness of VLOOKUP, HLOOKUP

● Using SUMIF, COINTIF, SUMIFS, COUNTIFS, COUNTA, INDEX & MATCH function

● MAXIFS, MINIFS, AVERAGEIFS

Part 2:

● What if analysis

● Inserting calculated filed and calculated items

● Shorting and filtering technique with pivot table

● Slicer in Pivot table (creating, changing and formatting)

● Dynamic pivot table using slicer 

Part 1:

● Understand table structure

● Understand various relationships

● Understand primary key and foreign key

Part 2:

● Using Measure in power pivot

● Data Analysis with Power pivot

● Dax in power pivot

Part 1:

● What is power query

● Understand the table structure

Part 2:

● Creating data model

● Data analysis with Powerpivot 

Part 1:

● Using power query | Power Pivot| Web scrapping data | Dax