Advance Excel Certification Course
SINCE 15 YEARS, TRUSTED BY STUDENTS
Advance Excel Certification Course
SINCE 15 YEARS, TRUSTED BY STUDENTS
Introduction
Advance Excel certification Course globally recognised as proficient in MS Excel
Advanced application of excel in accounts and finance, Power BI Model, dash Board, ASAP Utilities, Google Drive, Real Life Projects.
Course Name: Advance Excel
Course Duration: 1 Month
Eligibility: Graduate / Under Graduate
Admission Helpline: +91 9321317700
Course Fee: Enquire Now
Course Features
Free Books & Materials
Authorized Certification
Extra Hour for Practice
Course Tracking System
Flexible Batch Timings
Student Development
A.C. Lab
After Course Support
Campus Interviews
Job Assistance
Course Details
Basic Formulas
- Advantages of excel, Application, Sorting Data.
- Filtering List, Auto Filter, Pivot Table, Pivot Charts.
Logical Function
- Using Name, Conditional Logical Function, Advance Filter
- Data Consolidation, Goal Seek, etc..
Advance Logical Function
- Look-up, H-LookUp, V-LookUp, Scenario Manager,
- Math Function, Data Function, Character Function.
Advanced Macros & VBA
- Introduction OF Macros Dialogue Box
- User Form & Class Module etc….
Validation & Look-up Function
- Number & Text Validation, Drop Down.
Data Conversion and MIS Report
- Data Conversion (Data Import & Export)
- Creating MIS Report and Its Functions.
Security Point
- sharing/Conversion (PDF & Image)
Real Project On: Reports & Form Designing.
Exit Profile
This course gives you the chance to work with Accenture, Wipro, HP, Siemens, TCS, TATA, L&T Infotech, Carwale,Shaadi.com, ICan, JP Morgan, IBM, Mahindra and Many more…
- Executive Officer
- Content Writer
- Data Entry Operator
- Key Account Manager
- Back Office Work
