Advanced Excel

The Advanced Excel program is designed to lead the participant to understand how to work successfully work in this domain. 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.
What skills will the student gain?
  • 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
Mode of Training
  • The classes are delivered during Weekday or Weekend in classroom or online modes.
Locations:
  • The training is offered in locations like Chennai, Bangalore, Kolkata, Mumbai and NCR.
Introduction
  • Freeze panes
  • Charts (Bar, Column, Line, Pie, Area, 3d)
  • Auto Sum on the Task-bar
  • Usage of Top Ribbon Menu
Using Sort, Filter, Text-to-Column
  • Sorting (number. alphabets, color, date, custom)
  • Filter, Advanced Filter
  • Text to column: Importing .txt files / CSV into excel (Bhav Copy)
  • What-If Scenarios
  • Solver
  • Grouping and Sub-grouping
Creating Graphs & Chart
Formula Writing & Fixing Errors
  • Time Value of Money (PV, FV, nper, rate, PMT) + IRR, NPV
  • Lookup: Vlookup, Hlookup
  • Sum, Sumproduct, Absolute, Integer, Round, Average, Count, Minimum, Maximum
  • IF, nested if, sumif, Count, CountIf, CountBlank, iferror and, or,
  • Case, Position, Search, Trim, Right, Left, Concatenate
  • Date & Time: Day and Time, Representation of Date in Excel, Conversion, Today, Day
  • Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power
Working with Data
  • Data Validation (List, Error Message)
  • Identifying Invalid Data
  • Dependent Data List
  • Pivot Table (Pivot Chart)
Review and Security
  • Password Protection
  • Cells Lock
  • Making excel as a form
  • Track Changes
Using Macros
  • Recording macros
  • Running macros
Course NameDelivery ModeFeeSpecial Offer
Advanced Excel - Regular Class Classroom Rs. 4,000+ (including GST) Discount for 3+ enrollments
Advanced Excel - One to OneClassroom Rs. 10,500 (includes GST)Discount for 3+ enrollments
Advanced Excel TrainingOnline Live TrainerRs. 5,000 (including GST)Discount for 3+ enrollments at same time
Advanced Excel + Powerpoint + Macro Online Live Trainer Rs. 14,000 (including GST) Discount for 3+ enrollments

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.

  • Delegate pack consisting of study material and exercises
  • Live Instructor training with a proficient, industrially-rich and seasoned expert

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.

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

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

Yes, one can appear for the Microsoft Certification Exam

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

Related Courses

Course Categories

A Few Things You’ll Love!

  • Experienced Training Partner
  • Certified & Industry Expert Trainers
  • Multiple Training Delivery Models
  • Customized
    Course
  • 24/7 e-Learning Access
  • Assessments and Mock Tests
  • Placement Assistance
Training Calendar
Whatsapp Logo