Advanced Excel Training

Advanced Excel Training Course

Click on the buttons inside the tabbed menu:

Course Description

The Advanced Excel program is designed to lead the participant to work successfully with Excel in the data analysis and MIS domain.
 
What skills will the student gain?
After the completion of this course, the student will be able to:

  • Understand the way to do conditional formatting
  • ·   Learn about page layout and formatting details
  • ·   Learn about the data validation, error message and input messages
  • ·   Learn about Pivot Tables and data tables
  • ·   Learn how to use different types of formula and functions
  • ·   create graphs and charts

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 2018 is as follows:
Month Dates No of Hours
January Completed
February Completed
March Completed
April Completed
May Completed
June Completed
July Completed
August 26th Aug (Fast-track) 16
September 4th - weekday, 23rd - fast-track 16
October TBA 16
November 4th - fast-track,6th - weekday 16
December 2nd - fast-track, 4th - weekday 16

Study Mode & Fees

Certification Name Delivery Mode Fees
Advanced Excel Classroom Rs. 3,000 + 18% GST
Advanced Excel Fast-track Rs. 3,000+ 18% GST
Advanced Excel Online live trainer Talk to us

FAQs

The commonly asked questions pertaining to Advanced Excel training are -

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

A: Basic computer knowledge is the only pre-requisite

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: Will Pivot Table be covered in the class?

A: Yes, learning how to create Pivot Table is part of the syllabus.

Q: Will vlookup and hlookup be covered?

A: Yes, formulas and functions will be exhaustively covered alongwith vlookup and hlookup.

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: Will there be an exam at the end of the course?

A: Yes, an evaluation exam is conducted on the last day of the course.

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