|Last Date of Registration||:|
|No. of Classes/ Sessions||:||16|
|Total Hours||:||200 hours|
|Time||:||6.00 - 8.00 pm|
SESSION 1 (INTRODUCTION TO MICROSOFT EXCEL)
In this session participants will know the essential utilities and necessities of Microsoft Excel. Most of us know the basics of Excel. However, there’re few basics that are unknown to many of us. Knowledge of these unknown basics would change your idea about the power of Excel. This session intends provide the participants about these basics that will build a foundation of the advance Excel skill at later part of the course.
Understanding of Excel Objects
SESSION 2(ADVANCE EXCEL OPTIONS AND CUSTOMIZATION)
Knowing different customization options in Excel can put you in charge of you spreadsheet model. It can save your time and improve your quality of work significantly. This session will provide an extensive idea of all different tools in Excel and all different customization options in Excel.
SESSION 3(ADVANCE SKILLS ON EXCEL FUNCTIONS – I)
Functions are the sources of popularity of Microsoft Excel. Excel provides different types of formula for different types of people at different profession. However there’re few categories of functions essential for all groups of people. Efficient usage of these functions can change your productivity, revolutionize your career and make you successful at work. This session and next session are intended to provide the world best knowledge on Excel functions.
SESSION 4 (ADVANCE SKILLS ON EXCEL FUNCTIONS – II)
This session is a continuation of the last session.
SESSION 5 (ADVANCE DATABASE UTILITIES IN EXCEL)
Relational databases are the building blocks of today’s IT success. Microsoft Access is one of the common RDBMS used in office environment. However some people found the secret of Excel that provides most of the utilities of a simple RDBMS. This session will bring your confidence on Microsoft Excel and after this session you’ll forgot about your need of learning Microsoft Access or any other RDBMS.
SESSION 6 (OPTIMIZATION AND RISK MANAGEMENT TOOLS IN EXCEL)
For a strategic decision maker its essential to know the solution that maximizes his return, optimizes his cost and minimize losses. For investment appraisal problems, its essential to different risks of an investment. This section will give participant an excellent idea of optimization and risk management using excel.