Advanced Excel Classroom Training in Kolkata

Our Advantage:

• Excellent review on Google
• Small batch-size
• Complete hands-on learning
• Convenient Locations
• Placement Assistance

Contact:+91-8420594969

Module: Advanced MS Excel

Mode: Classroom

Duration: 20 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.      Formulas – Writing & Fixing Errors

2.      Working with Data

3.      Creating and Working with Charts

4.      Data Analysis & Pivot Tables

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

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