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