Advanced Excel 2016 training course will help you facilitate and gain expertise in Advanced Excel techniques covering concepts like Lookup functions Logical functions Formula Auditing Data validation What-if Analysis Pivot tables Pivot charts Advanced Filters Sparklines Macros and Data Security.

After the completion of this training you will be able to:

• Learn new features in MS Excel 2016 and implement advanced excel concepts
• Customize Quick Access toolbar and apply conditional formatting to personalize the sheet
• Apply advanced functions and formulas to enhance Excel’s productivity
• Perform What-if analysis command to experiment with data
• Apply data validation to restrict data input
• Design Pivot tables and Pivot charts to analyze data and apply slicer and timeline to add more interactivity
• Use Macros to automate routine tasks in Excel
• Integrate passwords to protect Excel files
• Use Excel shortcuts wherever applicable