This Excel course is designed for industry professionals to learn basics to advance tips & tricks for excel to solve complex prolems in simplest manner.

Its a 30 hours session in total covering topics as below stated-

• Each class being 1.5 to 2 hours duration if conducted during weekdays.
• Each class being 3 to 4 hours duration if conducted during weekends.

TOPICS COVERED

• Intoduction to Excel Interface > Menu > Toolbar> Different Category of Functions > How to use Basic Excel Formulae(Shortcut Keys)>Date , Time
• Mathematical Functions- Sum, Sumif, Sumifs, Averageif, Averageifs, Countif, Countifs, Roundup
• Text Functions - Text, Text to columns, Search, Find, Go To, Lower, Upper, Proper, Concat
• Statistical Functions - Iseven,Isodd,Iserror,Istext, Min, Max, Len, Right, Left, Mid
• Logical Functions - And, Or, If, Iferror, Not, Nested if, True, False
• Cell References (absolute, relative, mixed), 3D references)
• LookupFunctions, Filter , Unique, Sorting, Group By
• Filters - custom & advance , Database Management using AI features 
• Pivot Table and Charts , Slicers, Sparklines
• Creating Dashboards & Elements Included
• Assignments & Query session

This course is basically a kick start to professional career , Interactive  learning sessions with Industry experts !!