Advanced Excel Training

Advanced Excel Training Course

Our Advanced Excel Training Course is delivered in classroom and online batches held on weekdays and weekends. Batches are held in regular class-room and fast-track mode.

Click on the buttons inside the tabbed menu to view details of this course:

Course Description

The Advanced Excel program is designed to lead the participant to understand how this works and to successfully work in this domain.

There are multiple courses available to fit the requirement of students and working Professionals.

1. Advanced Excel on weekends.

2. Advanced Excel on weekdays  

3. Advanced Excel on weekdays - fast-track 

What skills will the student gain?
After the completion of this course, the student will be able to:

  • ·   Understand what is Advanced Excel features and its use
  • ·   Use of Pivot Tables
  • ·   Use of Charts & Graphs
  • ·   Use of formulas and functions
  • ·   Use of vlookup, hlookup, index,match and other functions
  • ·   Recording of macros and linking with buttons
  • ·   Handle different controls on a Webpage
  • ·   Implement TestNG
  • ·   Describe Page Object Modelling
  • ·   Learn Parametrization and different frameworks like Maven

Mode of Training

The Advanced Excel training is delivered in the following modes - Regular Classroom, Fast-track and Online live trainer

Locations:

The training is offered in locations like Chennai, Bangalore, Kolkata, Mumbai and NCR.

To know more about the schedules in those cities click here -->

Schedule for Kolkata

Outside the country it is delivered in Dhaka, Thimpu, Singapore, Kuala Lumpur, Middle East, Africa and Australia.

The course outline delivered during the class is as follows -

Introduction

  1. Freeze panes
  2. Charts (Bar, Column, Line, Pie, Area, 3d
  3. Auto Sum on the Task-bar
  4. Usage of Top Ribbon Menu

Using Sort, Filter, Text-to-Column

  1. Sorting (number. alphabets, color, date, custom)
  2. Filter, Advanced Filter
  3. Text to column: Importing .txt files / CSV into excel (Bhav Copy)
  4. What-If Scenarios
  5. Solver
  6. Grouping and Sub-grouping

Creating Graphs & Chart

Formula Writing & Fixing Errors

  1.  Time Value of Money (PV, FV, nper, rate, PMT) + IRR, NPV
  2. Lookup: Vlookup, Hlookup
  3.  Sum, Sumproduct, Absolute, Integer, Round, Average, Count, Minimum, Maximum
  4.  IF, nested if, sumif, Count, CountIf, CountBlank, iferror and, or,
  5. Case, Position, Search, Trim, Right, Left, Concatenate
  6. Date & Time: Day and Time, Representation of Date in Excel, Conversion, Today, Day
  7.  Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power

Working with Data

  1. Data Validation (List, Error Message)
  2. Identifying Invalid Data
  3. Dependent Data List
  4. Pivot Table (Pivot Chart)

Review and Security

  1. Password Protection
  2. Cells Lock
  3. Making excel as a form
  4. Track Changes

Using Macros

  1. Recording macros
  2. Running macros

Schedule

If you are located outside Kolkata or would like to attend our session during your visit to Kolkata then please feel free to write us at palium.skills@gmail.com for any queries related to program,
upcoming schedule and fee. Call: +91-9051092035 or WhatsApp: +91-9051092035

Schedule for Advanced Excel Training in 2019 is as follows:
Month Dates Type Status
January --
February 17th Feb Classroom Full
March 17th Mar Weekend Classroom Enrollment going on
April 14th Weekend Classroom Enrollment going on
May 3rd week Online
June 3rd week Classroom
July 3rd week Online
August 3rd week Classroom
September 3rd week Online
October 3rd week Classroom
November 3rd week Online
December 3rd week Classroom

Study Mode & Fees

Course Name Delivery Mode Fees Special Offers
Advanced Excel - Regular Class Classroom Rs. 4,000+ 18% GST Discount for 3+ enrollments
Advanced Excel - Fast-track Class Classroom Rs. 5,000 + 18% GST Discount for 3+ enrollments
Advanced Excel Training Online Live Trainer Rs. 5,000 + 18% GST Discount for 3+ enrollments at same time
Advanced Excel + Powerpoint + Macro Online Live Trainer Rs. 10,000 + 18% GST Discount for 3+ enrollments

FAQs

The commonly asked questions pertaining to Advanced Excel training are -

Q: What are the pre-requisites for taking the Advanced Excel course?

The requisites for this course are

A: Basic computer knowledge is required

Knowledge of Basic Excel

Palium offers separate courses for the above. If one desires to learn more intensely then they can enroll for the same.

Q: Will this be theoretical or hands-on?

A: This is a complete hands-on training where the trainer will demonstrate each feature and participants will follow and do the same on the system.

Q: How will I get access to the system?

A: After you enroll, you will be guided on how to access the system.

Q: Where will I get the software?

A: No. You will need to arrange software for your use

Q: What if I have doubts after completing the class?

A: You can gather your doubts and come by prior appointment to get your doubts cleared.

Q: Is there any official Certification Exam?

A: Yes, one can appear for thee Microsoft Certification Exam

Q: Will I receive a certificate for the course?

A: Yes, participants receive a certificate after completing the course provided they have attended 90% of the class.

Get help now
CONTACT US +91-9051092035 (24×7)
WhatsApp +91-9051092035 (24×7)
Enquire Now

A Few Things You’ll Love!

  • Accredited Training Partner
  • Certified & Industry Experts Trainers
  • Multiple Training Delivery Models
  • Customized Course
  • 24/7 e-Learning Access
  • Assessments and Mock Tests
  • Placement Assistance

Palium Skills