Advance Excel Certification Course

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.5 Month

Course Fee: Enquire Now

Eligibility: Graduate /Under Graduate

Admission Helpline: +91 9321317700

Course Features

open-book (4)

 Free Books & Materials

diploma (1)

 Authorized Certification

training

 Extra Hour for Pratice

font

 Course Tracking System

time

 Flexible Batch Timings

360-degrees (1)

 Student Development

air-conditioner (1)

 A.C. Lab

customer-service

 After Course Support

interview (1)

 Campus Interviews

employee (1)

 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…

Get Admission Now
  • Executive Officer
  • Content Writer
  • Data Entry Operator
  • Key Account Manager
  • Back Office Work

Scroll Down