Pre Requisite:  Good understanding and working knowledge of Windows generic functionality and basic Excel 2007/2010/2013/2016

Duration:  This course is scheduled for 3 days 

Target Audience:   This course is designed for students/associates desiring to gain the skills necessary to create reports, understand advanced functions, collaborate data with others, audit and analyze worksheet data, incorporate multiple data sources, and import and export data.

Course Objective: Upon successful completion of this course, you will be able to:

• Perform complex functions and formulas like Vlookup, If, Match, Index etc
• Collaborate with other workbook/Worksheets
• Vlookup/HLookup/Index/Match Functions
• Advanced Logical Functions
• Date and Time Functions
• Formatting worksheets using advanced condition
• Use data validation in worksheets
• Work with multiple workbooks
• Create Chart
• Integrate Excel data with other applications
• Understand new features of Excel 2016
• Create Pivot Table Reports and Pivot charts
• Slicers and Time Lines
• Data Validations
• Understanding Data Modelling using Power Pivot, Power Query
• Perform Business Intelligence in Excel spreadsheet