Course Description:
This Course is specially designed for those who are already working in financial institution and involve directly or indirectly in accountancy matters. Further, this course is also effective for those students, who want to improve their skills in Microsoft Excel.
The main objective of the course is to enhance the skills of a person, in MS EXCEL ENVIRONMENT to solve their official financial matters freely as per their requirement.
Course Content:
The Excel Basics Introduction to Excel
MS-Excel Interface
Starting a New Workbook
Using Toolbars
Dashboard Reporting the Named Range
The Lookup Functions
The If Functions
Financial Functions
Data Base Concepts & Its Functions
Misc. Valuable Functions
The Sorting
The Filters
The Advance Filters
The Subtotals
The Data Validation
The Form
Charts Concept
Working with Chart
Macro
Converting Numeric into Text Adding Controls
The Conditional Formatting
The Grouping and Outlines
The Pivot Table
The Solver
Course Information:
- Course Duration: 3 Months
- Daily Hours: 2 Hours
- Class Schedule: 3 Days in a week (Mon,Wed,Fri)
- Class Timing: Evening
Certificate:
Certificate from Skill Development Council (Government of Pakistan)
Admissions Requirement:
Minimum Academic Qualification: Matric / MS Office
Exit Profile:
Professional Excel Expert
