Advanced Microsoft Excel Training Program

Online Professional Excel Training from basic to Advanced level in guideline of professional Trainer, • Pivot Table &Excel Dashboard • Lookup Function: VLookup, HLookup, Reversal VLookup & Index & Match Function • Summarizing Functions: SumProduct, Sumifs, Sumif Functions • Count Functions: Countifs, Countif, CountA, & Countblank Functions • Offset Function, Indirect Function, Choose Function • Database Function: Dsum, Daverage, Dcount, Dmax, & Dget Functions • Whatif Analysis, Hyperlink, Data Consolidation, Data Sorting, Subtotal Options • Data Validation, Logical Function IF, AND & OR • Conditional Formatting: Highlighted Cell, Data Bars, Color Scale, Icon Set, New Rules • Time, Days, Date, Year, Month Function, Elapsed time calculation • Text Function: Trim, upper, Lower, Proper, Concatenate, Replace, substitute function • Auto Format, Paste Special, Data Entry form, Text to Column • Macro View & Record, Filter & Advance Filter • Protection of Sheet, Cell, file & Workbook • Large, Small, Mix & Max, Row & Column Function • Name Manager: Define Name & Create from Selection • Comment, Insert, Edit, Show & hide Comments • Use & Benefit of Table, Smart Art, Shapes • Fill Option