Advanced MS – Excel With MIS Reporting

what you’ll learn

• Fundamentals of MS Excel
• Excel shortcuts
• Conditional formatting
• Data validation
• In-depth understanding of various functions of MS Excel 
• Maintain large sets of Excel data in a list or table
• Formulas with IF, VLOOKUP, INDEX, MATCH functions and many more
• Create dynamic reports by mastering one of the most popular tools, PivotTables