Skip Main Navigation
Page Content

Save This Event

Event Saved

Advanced MS Excel Classroom Training in Kolkata

PALIUM SKILLS

Thursday, December 1, 2016 at 10:30 AM - Tuesday, December 31, 2019 at 6:30 PM (IST)

Advanced MS Excel Classroom Training in Kolkata

Ticket Information

Ticket Type Remaining Sales End Price Fee Quantity
General Admission 1000 Tickets Jan 6, 2017 $60.00 $2.49

Who's Going

Loading your connections...

Share Advanced MS Excel Classroom Training in Kolkata

Event Details

Module: Advanced MS Excel

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)
  • Ø  Filter, Advanced Filter
  • Ø  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)
  • Ø  Solver (addin)

Working with Data

Review and Security

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

Advanced Excel

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

Save This Event

Event Saved

When & Where


Palium Skills Professional Training Institute in Kolkata
1/22 Poddar Nagar, Near South City Mall
Kolkata, WB 700068
India

Thursday, December 1, 2016 at 10:30 AM - Tuesday, December 31, 2019 at 6:30 PM (IST)


  Add to my calendar

Organizer

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 

  Contact the Organizer
Advanced MS Excel Classroom Training in Kolkata
Things to do in Kolkata Class Business

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.