Advanced MS Excel 2016 Certification Training
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.
Upcoming start dates
Inquire for more information
Who should attend?
There are no prerequisites for this course. However a basic understanding of Microsoft Excel will be supportive.
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
Certification / Credits
edureka certifies you as an expert in Advanced Excel based on the project reviewed by our expert panel.