Let’s to know, what table of content we ill discus step by step with practical example in this tutorial. Let say,
*Advance sorting & Filtering data by (Color, Number Amount)
*Conditional data formatting
*Remove Unfell cell data
* Goal seek
* Crating Table in Excel
* Crating Hyper link in Excel
* Sum IF
*PMT Function
*Page break up
* Share Work book
* Count & Count IF Function
* Linking Excel data
* Remove duplicate data
* Text to Column Function
* Consolidation function
* Data validation
* Past Special
* Freeze Unfreeze Excel data
* Group + un group Data
* Execute Subtotal data
* IF & nested if Function
* H Lookup + V lookup
* Creating $& formatting Chart
* Exact Function
* Index & Match Function
* Protect Excel sheet
* Pivot Table