Contact : 9911459630 / 8586880821

Building No. 1 , Near Auto Stand - Saraswati Complex , New Railway Road - Gurgaon
Register

New Railway Road-Gurgaon Old-Dlf, Sector-14 Gurgaon

07:30 - 19:00Monday to Sunday

9911459630 / 8586880821info@tcagurgaon.com

Best advanced excel Course in Gurgaon | Best advanced excel Training Institute in Gurgaon|Best advanced excel Training in Gurgaon

We provide best advanced excel training in gurgaon which includes Protecting sheets, Pivot Table, MIS Reporting, Dashboard Training & Advanced Formulas like vlookup, hlookup, index match and many more. Our practical approaches of teaching help students to practice the same right from the first day itself. The trainers are highly experienced with industries experience in their respective technologies.

Our advanced excel training course is a job oriented course mapped with the industry standard and conducted by corporate trainers only. The course is designed to help students acheive their goal in advanced excel training course. We are doing it complete differently to train students on the cutting-edge technologies like advanced excel Pivot Table, MIS Reporting in our advanced excel course in gurgaon. The Advanced modules like Pivot Table, MIS Reporting etc. are conducted in way that anybody can adapt and learn it because it's all about practical implementation which starts here from the beginning itself.

When it comes to placement we have our dedicated placement team to look after your placement activity. We beleive in quality education and TCA is fully responsible and dedicated for the quality delivery of every course we conduct. Hence we say what matters is your knowledge at the end of the day and we are ready to build you as a complete package technically and of course our placement team will do their best in getting you placed finally. We have our dedicated placement team looking after grooming sessions, personality development sessions, resume building activities and off campus - on campus interview scheduling for the students.

Adavnced Excel Training

Basic Microsoft Excel

Format Cells

  • Managing Row Height
  • Column Width
  • Merge
  • Alignment

Managing Worksheet

  • Creating
  • Renaming
  • Colouring
  • Printing Sheets

Statistical Functions

  • sum()
  • min()
  • max()
  • average()
  • round()

Graphically representing data

  • Charts
  • Charts

Analyzing data

  • Filter
  • Sorting
  • Subtotal
  • Advanced Filter
  • Freeze Panes

Formatting worksheets

  • Securing
  • Protecting spreadsheets

Working with functions & formulae

Adavnced Excel Training

Advanced Microsoft Excel

Lookup Functions

  • VLOOKUP, HLOOKUP,DOUBLE VLOOKUP
  • VLOOKUP with INDEX MATCH
  • HLOOKUP with INDEX MATCH

Logical Functions

  • IF
  • Nested IF, SUMIF, COUNTIF,
  • SUMIFS, COUNTIFS, SUMPRODUCT

Data Validation

  • Basic Data Validation
  • Create List in Data Validation

Text Functions

  • Left, Right, Find, Replace,
  • Concatenating, Upper,
  • Trim, Lower, Len

Date Functions

  • Today(), Now(), Date(),
  • Datedif(), Text(), Weekday(),
  • (Concatenating) function

Financial Functions

  • PMT(), IPMT(), PPMT(), PV(),
  • What-If Analysis types

Charts & Advanced Chart

  • Basic,Comparison & Combination Charts

PIVOT Tables

  • Basic Pivot Table
  • Advanced Pivot Table

MIS Reporting

MACROS

  • Definition and use, Record a macro
  • Assign a macro, Run a macro
  • Store a macro, Introduction to VBA Programming

Dashboards

  • Dashboard using Pivot Table & Charts

Special Operations

  • Paste Special
  • Protecting sheets
  • Locking sheets
  • Linking Multiple Sheets
  • Sheet Referencing
  • Absolute Value & Reference Value
  • Age Calculations
  • Condition Formatting

Being the industries first choice advanced excel has been regarded as the ever growing technology so far which offers the best platform for fresher students to begin with. It adds many more feather in your cap by providing various job opportunity which involves wide varity of sectors/industries. Today Advance excel has become need of every company when it comes to managing their various day to day work reports.

We also provide recorded video sessions, ppts, pdfs for every module of advanced excel training in gurgaon course which helps students to revise things easily even after completion of the course. Our membership card enables you to attend revision sessions on week ends for regular basis as long as you want. The trainers in this advanced excel course in gurgaon are always available to help/support in your practical assignments through skype, email or phone. In this age of digital era students find many platform to learn theory of anything so our entire course sessions are divided into weekly schedule in which the training approach followed to deliver the practicals and theory is into a ratio of 80:20.

Placement Assistance

Job-Oriented Sessions
  • Employebiliy Orientation Sessions
  • Grooming Sessions & Technical Seminar
  • Inteview Trick & Tips by Experts
  • Resume Writing Sessions
  • Session on Naukri.com
  • Personality Development Sessions
  • Group Discussion Sessions
  • Week-End Seminars

Live Video Sessions

Attend Video Classes
  • Online Classes Available
  • Recorded Sessions Demo Download
  • Lession on Demand Available
  • Live Streaming of Selective Sessions
  • You can schedule your class online
  • Special Videos from Experts
  • Check Classes Live Schedule
  • Book your online Demo

Our Membership

One Year Membership
  • One Year membership card
  • Revision Sessions for one year
  • You can come on Week-ends
  • Special Sessions Notifications
  • All workshop free for one year
  • Pratice anytime on anyday
  • Trainers connect for one year
  • Online Content Access for one year