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