Advanced MS Excel 2016 Certification Training
5.0 /5- Offered byEdureka
Advanced MS Excel 2016 Certification Training at Edureka Overview
Total fee | ₹7,627 |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Advanced MS Excel 2016 Certification Training at Edureka Highlights
- Earn a certificate of completion from Edureka
Advanced MS Excel 2016 Certification Training at Edureka Course details
- For Data Analyst
- For Financial Analyst
- For Advanced Excel User
- For Fresher seeking jobs in Analytics/Consulting job streams
- 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
- Through this course, you?ll learn the advanced functions that are used by analysts on a day to day basis
- You?ll also get accustomed to even more advanced stages of excel use like Macros which further come handy
- Throughout the course, you?ll be given hands-on assignments and case-studies to put the theoretical knowledge to practical
- This 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
Advanced MS Excel 2016 Certification Training at Edureka Curriculum
Overview of Advanced MS Excel 2016
What?s New in MS Excel 2016
Advanced Concepts
Custom and Conditional Formatting
Customizing Quick Access Toolbar
Conditional Formatting
Advance Functions and Formulas
Logical Functions
Text Functions
Lookup and Reference Functions
Formula Auditing
Randbetween
Name Ranges and application
Advanced Data Tools
Text to Column
Data Validation
What-If Analysis
Duplicate Removal
Data Sanitation through excel - Sorting, Filtering
Data Analysis
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
Introduction to Macros
Introduction to Macros
Record Macros
Run Macros
Edit Macros
Advanced MS Excel 2016 Certification Training at Edureka Entry Requirements
- Pre-requisites: Basic understanding of Microsoft Excel will be supportive
- Not mentioned
Other courses offered by Edureka
Advanced MS Excel 2016 Certification Training at Edureka Students Ratings & Reviews
1 Rating- 4-51
Student Forum
Anything you would want to ask experts?