Advance Excel Skills-Take your Analytical Skills to the Next Level
Objectives
The objectives of this training is to expand analytical capabilities of participants by mastering the power of formulas and functions; add a whole new level of depth and analysis to their worksheets and to discover how to take data validation and analysis to an advanced level using the extensive array of tools built into Excel.
Who should attend?
- Sales Agents
- Business Development Officers
- Human Resource Department (HR)
- Sales Representatives
- Accountants
- MIS
- Financial Analysts
How we deliver?
FDC believes on training for transformation and its methodologies changes with the change in corporate culture.
- Participatory-led oral presentation
- Demonstrations and practice exercises
- Problem based learning/Sharing
- Direct instruction
- Trainer-led instruction
Contents I :
- How to differentiate between Good & Bad Data
- Excel Tables
- Sort
- Filter
- Subtotal
- Advanced Filter
- Paste Special
- Sheet Protection & Hidden Function
Contents II:
- Import Data
- Scenario Manager
- Conditional Formatting
- Errors
- Average & Freeze Panes
- Custom Number Formatting
- Vlookup & Hlookup
- Pivot Table
Training Details:
Training Cost: NRs. 6000 plus levied tax per head
Training time: 3 Days
Contact Number : 01-5707271, 9801898005, 9801048455
