BEST MIS TRAINING INSTITUTE IN GURGAON WITH JOB ASSISTANCE IN INDIA

ADVANCE EXCEL TRAINING Lookup & Information Functions • Vertical Lookup (Vlookup) • Horizontal Lookup (Hlookup) • Match and Index • IsText, IsNumber, IsDate, IsNull, IsErr, IsError, IsNa Advanced List Management • Advanced Filters • Using List Features • Dynamic Lists Pivot Tables • Using the Pivot Table Wizard • Changing the pivot table layout • Formatting • Grouping items • Inserting calculated fields • Pivot Table Options • Display and hide data in fields • Lay out reports directly on worksheet • Pivot Chart What If Analysis • Scenarios • Goal Seek • Solver Protecting & Sharing Files • Sharing a file • Tracking changes • Accepting or rejecting changes • Applying Data validation rules • Inserting comments Mail merge, Macros Etc