Introduction Excel
Part 1 :- Excel Introduction
Part 2:- Tabs and Groups
Part 3:- Home Tab
Part 4:- Insert Tab
Part 5:- Tab View and Review and page layout
Part 6:- Filter and Advance Filter
Part 7:- Formulas (Sum, Count, Max, Min, IF, SumIF,CountIF, MaxIf, MinIF, AvgIF,Subproduct, Isnumber, Vlookup, Hlookup, Xlookup, Lookup, Index, Match, txt, concat, split, Switch, Iferror, or, and, Date, Year , Month, Day , Hours, Minutes, Second, Eomonth, Datediff, Networking days, filter, short, uniqe, Row, rows, columns , columns, Offset etc)
Part 8:- Name Manager
Part 9:- Pivot Table
Pert 10:- Charts
Part 11:- Advance Logical Formula
Part 12:- Basic of Mecros
Part 13:- Tab Data basic
Advance Excel
Part 1:- Advance Pivot Table
Part 2:- Advance Charts
Part 3:- Advance Formatting
Part 5:- Power Query
Part 6:- Pawer Query Get data from Folder
Part 7:- Power Query Data Modeling
Part 8:- Power Query Transform
Part 9:- Power Pivot
Part 10:- Basic of M-Code
Part 11:- Get Data from Different source
Part 12:- Edit Query
Part 13:- Creating Advance formula Using Existing formula
Part 14:- Understanding Logics of Formula
Part 15:- Creating a Dashboard