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
Event venue
Palium Skills Professional Training Institute in Kolkata, 1/22 Poddar Nagar, Near South City Mall, Kolkata, India
Concerts, fests, parties, meetups — all the happenings, one place.