Advanced Excel Duration - 2 Month OBJECTIVE :- Provide Basic Understanding of Excel, Make user Familiar to Create Formula and give Platform to Make Good Analysis and Introduce Powerful Tools of Advance Excel so that user can Make Advance Analysis with the help of Those Tools. TOPICS COVERED :- Introduction of Excel and Basic Understanding. Menu Tab Understanding and Printing worksheet. Basic Formula :- Sum, Sumif, Sumifs. Count, Counta, Count blank. Countif. Average, Max, Large Min, Abs, Lower, Upper, Proper, Trim, Len, Left, Right, Mid, Concatenate, Subtotal, And, Or, Day, Year, EOmonth, Edate, Net workdays, Substitute Today, Weekday, Week number, Workday, Find, Advance Formula :- Search. V-lookup, H-lookup, Day and Time Calculation, Numeric Calculation If Logical Condition Pivot Table Pivot Chart Dynamic Pivot Dynamic Chart Conditional Formatting Dated if What If Analysis Match Index Index Match Index Match Match Offset Fu...