Advanced Certification in Microsoft Excel
4.0 /5- Offered byIntellipaat
Advanced Certification in Microsoft Excel at Intellipaat Overview
Advanced Certification in Microsoft Excel
at Intellipaat
Duration | 24 hours |
Total fee | ₹9,804 |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Advanced Certification in Microsoft Excel at Intellipaat Highlights
Advanced Certification in Microsoft Excel
at Intellipaat
- Earn a Certificate
- 24 Hrs Instructor Led Training
- 24 Hrs Self-paced Videos
- 48 Hrs Project & Exercises
- Job Assistance
- Flexible Schedule
- Lifetime Free Upgrade
- Mentor Support
Read more
Advanced Certification in Microsoft Excel at Intellipaat Course details
Advanced Certification in Microsoft Excel
at Intellipaat
Skills you will learn
Who should do this course?
- For Business Professionals
- For Accounting Professionals
- For Data Analysts and Programmers
- For Business Intelligence Professionals
- For Statisticians
- For Those looking for a career in analytics
What are the course deliverables?
- Basic and advanced concepts of MS Excel
- Deploying formulae and logical functions
- Using sorting and filtering on Excel spreadsheet data
- Excel charting principles
- Data quality issues
- Using a Pivot table for explaining advanced options
- Advanced functions such as DSUM and DMAX
- Using VBA Editor for editing macros
- Working on practical VBA projects
More about this course
- This advanced Excel course lets you master the most widely used spreadsheet, MS Excel
- This course includes creating dashboards, interactive components, data consolidation, and debugging
Advanced Certification in Microsoft Excel at Intellipaat Curriculum
Advanced Certification in Microsoft Excel
at Intellipaat
Entering Data
Referencing in Formulas
Name Range
Understanding Logical Functions
Getting started with Conditional Formatting
Advanced-level Validation
Important Formulas in Excel
Working with Dynamic table
Data Sorting
Data Filtering
Chart Creation
Various Techniques of Charting
Pivot Tables in Excel
Ensuring Data and File Security
Getting started with VBA Macros
Ranges and Worksheet in VBA
IF condition
Loops in VBA
Debugging in VBA
Dashboard Visualization
Principles of Charting
Getting started with Pivot Tables
Statistics with Excel
Other courses offered by Intellipaat
IntellipaatCertificate
₹1.59 L
7 months
– / –
IntellipaatCertificate
₹62.64 K
146 hours
– / –
IntellipaatCertificate
IntellipaatCertificate
₹60.02 K
6 months
– / –
View Other 34 Courses
Advanced Certification in Microsoft Excel at Intellipaat Students Ratings & Reviews
Advanced Certification in Microsoft Excel
at Intellipaat
4/5
2 Ratings- 3-42
M
Mritunjay Kumar
Advanced Certification in Microsoft Excel
Offered by Intellipaat
4
Learning Experience: It helps me to work on excel frequently.
Faculty: Instructors taught well
Yes, it is step by step and clear course
Course Support: No career support provided
Reviewed on 11 May 2022Read More
View 1 Review
Advanced Certification in Microsoft Excel
at Intellipaat
Student Forum
Anything you would want to ask experts?