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
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 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 = 427
