Page Content

# Advanced MS Excel Classroom Training in Kolkata

## Kolkata, India

### Ticket Information

 Ticket Type Remaining Sales End Price Fee Quantity General Admission 1000 Tickets Jan 6, 2017 \$60.00 \$2.49 Ticket Quantity Select 1 2 3 4 5 6 7 8 9 10

### Who's Going

Share Advanced MS Excel Classroom Training in Kolkata

### Event Details

Mode: Classroom

Duration: 16  hours

The course is designed for professionals and graduate students who need to learn about the advanced ways of using spreadsheets to resolve day-to-day issues experienced at workplace and to solve complex issues in an easy manner.

Course Outline:

1. 1.       Formulas – Writing & Fixing Errors
2. 2.       Working with Data
3. 3.       Creating and Working with Charts
4. 4.       Data Analysis & Pivot Tables
5. 5.       Review & Security

Formula Writing & Fixing Errors

Working with Data

• Ø  Financial: Time Value of Money (PV, FV, nper, rate, PMT) + IRR, NPV
• Ø  Look up: Vlookup, Hlookup
• Ø  Math: Sum, Sumproduct, Absolute, Integer, Round, Average, Count, Minimum, Maximum
• Ø  Logical: IF, nested if, sumif, Count, CountIf, CountBlank, iferror and, or,
• Ø  Text: Case, Position, Search, Trim, Right, Left, Concatenate
• Ø  Date & Time: Day and Time, Representation of Date in Excel, Conversion, Today, Day
• Ø  Others: Even, Exact, Exp, Find, Int, IsBlank, Left, Len, Lower, Upper, Proper, Now, Power
• Ø  Sorting (number. alphabets, color, date, custom)
• Ø  Text to column: Importing .txt files / CSV into excel (Bhav Copy)
• Ø  Importing from internet (Web Query)
Data Validation (List, Error Message)
• Ø  Grouping and Sub-grouping
• Ø  Subtotal
• Ø  What if Analysis (Goal Seek, Scenario)

Working with Data

Review and Security

• Ø  Precedents, Dependents, Error Checking
• Ø  Evaluation of Formula – Stepwise
• Ø  Formula hiding
• Ø  Cells Lock
• Ø  Making excel as a form
• Ø  Track Changes

Miscellaneous

• Ø  Using Circular Formula (Storage of Data)
• Ø  Iterations and array
• Ø  Recording macros
• Ø  Pivot Table (Pivot Chart)
• Ø  Sharing of excel (Collaboration)
• Ø  Sample Models
• Ø  Freeze panes
• Ø  Charts (Bar, Column, Line, Pie, Area, 3d
• Ø  Auto Sum on the Task-bar
• Ø  Usage of Top Ribbon Menu
• Ø  Formatting

Have questions about Advanced MS Excel Classroom Training in Kolkata? Contact PALIUM SKILLS

# Event Saved

## PALIUM SKILLS

Who are we?

Palium is a training organization conducting trainings on Functional, Soft-Skills, IT and Project Management areas. We have conducted trainings for leading corporates like ITC, JUSCO, CMS and many others.

We also conduct trainings on Primavera P6, MS Project and other Project Management related topics.

Palium works with Infocareers, an approved REP of Project Management Institute.  Infocareer has conducted  numerous such programs and has helped individuals to achieve certification and work successfully in the Project Management domain.

Palium Software Services Private Limited

1st Floor, ‘Sheeba Bhavan’,

1/22, Poddar Nagar

(Near South City Mall/Dominos Pizza),

Kolkata, West Bengal 700068

P: +91-842 059 4969 L: +91-33-4001 7947

E: trainings@paliumsoftware.in

www.paliumtrainings.biz

Advanced MS Excel Classroom Training in Kolkata