Course description
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.
Do you work at this company and want to update this page?
Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
1 start date available
Who should attend?
There are no prerequisites for this course. However a basic understanding of Microsoft Excel will be supportive.
Training content
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.
Contact this provider
Ads