| |
| Training |
|
Financial Modeling in Excel: This course is designed especially for CA/CPA/CFA/MBA Finance professionals to understand the usage of advance Excel functions to eliminate repetition of tasks and build user friendly models for enhancing productivity. Following topics are covered this course : 1) Building OLAP queries in Excel 2) Web queries in Excel 3) What-If & Scenario analysis 4) Understanding macro 5) Building models by combining multiple Excel functions 6) Preparing DCF model &nbs202" style='position:absolute;left:141.2pt;top:126.05pt;width:416.8pt;height:1052.95pt; z-index:27;visibility:visible;mso-wrap-edited:f;mso-wrap-distance-left:2.88pt; mso-wrap-distance-top:2.88pt;mso-wrap-distance-right:2.88pt; mso-wrap-distance-bottom:2.88pt' filled="f" fillcolor="black [0]" stroked="f" strokecolor="#cc9 [2]" strokeweight="0" o:cliptowrap="t"> Financial Modeling in Excel: This course is designed especially for CA/CPA/CFA/MBA Finance professionals to understand the usage of advance Excel functions to eliminate repetition of tasks and build user friendly models for enhancing productivity. Following topics are covered this course : 1) Building OLAP queries in Excel 2) Web queries in Excel 3) What-If & Scenario analysis 4) Understanding macro 5) Building models by combining multiple Excel functions 6) Preparing DCF model MIS Automation in Excel : This course is designed especially for MIS professionals to enhance day to day reporting . Following topics are covered in this course : 1) Designing standard templates 2) Applying data validation to restrict users 3) Collecting large amount of data in one file using Macro 4) Creating GUI interface to allow multiple users to enter data in Excel file 5) Creating auto populated report from Excel database Excel VBA for All : This course is designed for those who are interested in reducing their manual efforts by automising various possible tasks in their day to day functioning. · VBA Basics · VBA Editor · Recording Macros ·MIS Automation in Excel : This course is designed especially for MIS professionals to enhance day to day reporting . Following topics are covered in this course : 1) Designing standard templates 2) Applying data validation to restrict users 3) Collecting large amount of data in one file using Macro 4) Creating GUI interface to allow multiple users to enter data in Excel file 5) Creating auto populated report from Excel database Excel VBA for All : This course is designed for those who are interested in reducing their manual efforts by automising various possible tasks in their day to day functioning. · VBA Basics · VBA Editor · Recording Macros · Excel Object Models · Procedures · Functions · Looping · Condition Statements · User form & control toolbox Fast Track Course : For those who have to appear for interviews or want to up skill on specific topic/s in Excel BASE SAS : This course is designed for those who are interested in undergoing BASE SAS certification. |
