Learn Advanced Excel - Weekday & Weekend batches fast-track mode available
Learn Advanced Excel - Weekday & Weekend batches fast-track mode available in Kolkata

From: 01 Jan 2020 To: 31 Dec 2020

Start Time: 10:00 AM End Time: 12:00 PM

Venue: Palium Skills Professional Training Institute in Kolkata, Katju Nagar, Jadavpur, Kolkata, West Bengal, India

Created By: Palium Skills Professional Training Institute

Learn Advanced Excel - Weekday & Weekend batches fast-track mode available

Event Description




Module: Advanced MS Excel


Mode: Classroom

Duration: 16 hours    (The program repeats every month)


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 

Ø  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, Left, Len, Lower, Upper, Proper, Now, Power 

Working with Data 

Ø  Precedents, Dependents, Error Checking 

Ø  Evaluation of Formula – Stepwise 

Ø  Formula hiding 

Other Features 

Ø  Pivot Table (Pivot Chart) 

Charts (Bar, Column, Line, Pie, Area, 3d, Sparklines) Working with Data


Ø  Sorting (number, alphabets, color, date, custom)

Ø  Filter, Advanced Filter

Ø  Text to column: Importing .txt files into excel

Ø  Data Validation (List, Error Message)

Ø  Grouping and Sub-grouping

Ø  Subtotal


Review and Security


Ø  Password Protection

Ø  Cells Lock

Ø  Track Changes


Miscellaneous


Ø  Freeze panes, Custom View

Ø  Auto Sum on the Task-bar

Ø  Usage of Top Ribbon Menu

Ø  Formatting

Contact:

Palium Skills

1st Floor, 'Sheeba Bhavan'

1/22 Poddar Nagar,

Kolkata - 700068

Email: palium.skills@gmail.com

Website: www.paliumskills.com


Share This Event


Total Event Views = 198
Organizer Details

Name: Palium Skills Professional Training Institute


Similar Events in Kolkata

Discover the Reasons Why You Should Hire Event Planners in India

Discover the Reasons Why You Should Hire Event Planners in India event in Kolkata

Azure Training and Certification

Azure Training and Certification event in Kolkata

Certificate Course on R Programming

Certificate Course on R Programming event in Kolkata

Foreign Language Speaking course - French, German, Japanese, Spanish -- Classroom & Online

Foreign Language Speaking course - French, German, Japanese, Spanish -- Classroom & Online event in Kolkata