Advanced MS Excel 2016 Online Training

Description

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