This course is very suitable for students and professionals who have the basic knowledge of MS Excel and would wish to learn and enhance their knowledge about the advance features and functions of MS Excel.

In this course we will be learning 25+ advance concepts in Excel like Goal Seek, Name Manager, Format a Table, Remove Duplicates, Group / un-Group, Sub Total, Advance Sorting Data, Advance Filtering, Data Validation, Conditional Formatting, Formula Auditing, Data Consolidation, Get external data, Calculations, Scenario Manager, Watch window, Insert Charts / Headers / Footers, Pivot Tables, Freeze Pans / New Window / Arrange All etc. and about 90+ advance Excel functions like =ADDRESS(), =AREAS(), =CHOOSE(),     =COLUMN(), =COLUMNS(), =GETPIVOTDATA(), =HLOOKUP(), =INDEX(), =INDIRECT(), =LOOKUP(), =MATCH(), =OFFSET(), =ROW(), =ROWS(), =TRANSPOSE(), =VLOOKUP(), =CEILING(), =FACTDOUBLE(), =FLOOR(), =RAND(), =RANDBETWEEN(), =ROUND(), =ROUNDDOWN(), =ROUNDUP(), =SERIESSUM(), =SUBTOTAL(), =SUMIF(), =SUMIFS(), =SUMPRODUCT(),    =SUMSQ(), =SUMX2MYZ(), =SUMX2PYZ(), =SUMXMYZ(), =TRUNC() and more.        
While attending the class it would be good if you have a pen and a book to note a few important observations with respect to the subject.