Advanced Excel

The Advanced Excel program is short duration course designed to lead the participant to understand how to work successfully work in this domain. Our Advanced Excel Training Course in Kolkata is delivered in classroom and live online batches held on weekdays and weekends. Batches are held in regular class-room and fast-track mode. Besides, we also conduct Excel training through live online trainer.
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 Bhubaneswar, Bhopal, Chennai, Bangalore, Hyderabad, Indore,  Kolkata, Mumbai, Pune, NCR and other Indian cities.
Our past students have reviewed us highly and voted us as the best institute for Excel Training in Kolkata and India. They have also reviewed our trainers and our institute as one of the top Excel training institutes in India. Palium offers multiple such short term courses in Kolkata for the benefit of professionals to enhance their skills.
So whether it is Finance, SCM, HCM or Technical - our faculty members have received great appreciation from participants. Our faculty members work with top tier IT companies like Cognizant, IBM, Infosys, Mindtree, TCS, Wipro and many others. They are passionate about teaching and sharing their knowledge with others. Hence make it a point to ensure participants learn the application in the right way.
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
Advanced Excel batchOnline ₹2,000 per participantFor batch of 10 participants

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