#Advaced# #Excel# #Topics#
You will be learning the following topics from this video in Tamil. Step by step explanation in Tamil.
Advanced Excel Topics:
Offset Dynamic Drop-down
Exact & If Exact
Case Sensitive Lookup
How to Freeze Pan
Sum with Indirect Function
Index with Match
Advanced Two-Way Lookup INDEX+MATCH
Pivot Table
Calculated Field in Pivot Table
Pivot Table Tricks
Advanced Networkdays
FIND TAT Status
Conditional formatting to Highlight Weekends
Power BI Basic Videos for beginners - [ Ссылка ]
Basic Excel VBA Macro videos for beginners - [ Ссылка ]
Thank you for reaching out to my channel. I will also provide weekend support on the below topics
Ms Excel, Ms Word, VBA, Power Point, Power BI
Email ID - Krishsexcelanywhere2020@gmail.com
![](https://s2.save4k.ru/pic/yd01nrUEc8A/maxresdefault.jpg)