Courses Categories: Computer Skills and Microsoft Office
Advanced MS Excel 2016 Certification Training
Advanced MS Excel 2016 Certification Training
Address: 254 Broadway
New York
New York
10007
United States
New York
New York
10007
United States
What You Will Learn :
- Learn new features in MS Excel 2016 and implement advanced excel concepts
- Apply advanced functions and formulas to enhance Excel’s productivity
- Design Pivot tables and Pivot charts to analyze data and apply slicer and timeline to add more interactivity
- Integrate passwords to protect Excel files
Description
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
Who is this course for?
There are no prerequisites for this course. However a basic understanding of Microsoft Excel will be supportive.
Course Supplier
Similar Courses
Last Viewed
Loading...