+91 91525 74715 | info@excelinstitute.co.in

Reset Password

Advance Excel – Professional

Advanced Excel skills include the ability to produce graphs and tables, use spreadsheets efficiently, and perform calculations and automation to process large volumes of data. With the rise of big data and data analytics, advanced Excel skills are a real asset both during the job hunt and everyday work tasks.

Whether you are considering a career in data analytics or looking to enhance your skills on the job, Excel training can be valuable in preparing you for a variety of promising roles.

Overview

Whether you are considering a career in data analytics or looking to enhance your skills on the job, Excel training can be valuable in preparing you for a variety of promising roles.

PROFESSIONAL LEVEL

AND, OR, NOT
MATCH, INDEX
CountIf, CountIFS, SumIF, SumIfS
Advanced options of Pivot tables
Slicers
Corporate functions
Professional functions
Database functions
Powered Functions
Auto formatting
Conditional formatting
Analysis
Goal Seek

Data Tables
Scenario Manager
GST Calculation
Balance sheet Calculation
Profit and Loss Calculation
New updates in MS-Excel
Overview of all the new features
Customizing Excel Options
Software Customization
Data Management
MIS
Dashboard
Google Sheets

Eligibility

  1. 10th Standard
  2. 12th Standard
  3. Graduation in Any Stream

Certification

  1. ITC : Information Technology Council Certification.
  2. DiTRP ( Digital Information Technology & Research For Professional)

Duration

1.5 Months
×