IIRF Online > Finance & Accounting > Financial Modeling & Analysis > Excel > Advanced MS Excel 2016 Certification Training
Advanced MS Excel 2016 Certification Training by Edureka
Skills you will learn!
Curriculum
2 Topics
What’s New in MS Excel 2016
Advanced Concepts
2 Topics
Customizing Quick Access Toolbar
Conditional Formatting
6 Topics
Logical Functions
Text Functions
Lookup and Reference Functions
Formula Auditing
Randbetween
Name Ranges and application
5 Topics
Text to Column
Data Validation
What-If Analysis
Duplicate Removal
Data Sanitation through excel - Sorting Filtering
4 Topics
Data analysis using normal charts formatting of charts secondary axis use scatter plots
Data analysis using a Pivot table and pivot charts sparklines
Running Regression in excel ANOVA etc.
Cover basic stats through excel - Functions like correlation stddev average regression functions
4 Topics
Introduction to Macros
Record Macros
Run Macros
Edit Macros
4 Topics
Protect Cells
Protect Sheet
Protect Workbook
Protect Ranges
1 Topic
Implement Excel 2016 abilities and techniques
Advanced MS Excel 2016 Certification Training
Related Excel Courses
Thank You!
Your review has been submitted successfully.