Vineet

Working with UK Based MNC. advanced level MS Excel. Student Friendly approach. work towards development of student. Teaching with help of examples and students will be given proper exercises to develop their learning. will cover following topics MS Excel Functions Sum count sumif countif sumifs countifs Vlookup Hlookup con catenate index match Eomonth sumproduct Index date month year day left right mid length offset transpose subtotal If if or if and if error isblank Max Min Average Average if trim is text is blank text substitute small large rank counta indirect nested if averageifs PMT IPMT FALSE search lower upper edate time week day workday rows columns address round up round down round isnontext isnumber islogical n NA Type INFO Is odd is even Formatting Drag colour both cell and text formatting conditional formatting Pivot table printing of sheet data import data export sort and filter freezing and unfreezing of panes protect unprotect worksheet protect unprotect workbook setting of page layout graphs and charts Evaluating formulas Calculations manual and automatic Drop down lists Group ungroup Inserting of tables shapes smart art pictures hyperlink equations and symbols. array formulas naming of cells Left right centre alignment merge and centre designing and formatting of charts Text to columns section in Data

See more: Microsoft Excel Lessons