

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