Excel Workshop for Economics Teachers in Business Schools

Excel Workshop for Economics Teachers in Business Schools

 


The workshop intends to introduce excel templates and functions that can be helpful while teaching concepts in micro and macroeconomics. The two day workshop will start with a quick brain storming session on the teaching challenges related to specific economic concepts, and how some of those can be addressed using excel. At the end of the second day of the workshop the participants will have created their own libraries of excel functions that can be used in a standard economics curriculum in Business Schools. The major objectives are:

 

Take stock of challenges in introducing economics concepts in Business School Education

 Introduce advanced excel applications for teaching economics

 Create own library functions for teaching economics

 Build dynamic excel templates that can be deployed while teaching economics

 

    

The workshop will be led by the resource person(s) for each session. Each session will start with a basic review of the economic concepts followed by excel application/introduction to templates for the same.

 

The sessions will be conceptually and computationally intensive. The workshop sessions will have individual as well as group tasks to finish.

 

   

 

Hands on training on financial and mathematical functions in Microsoft excel 2007 or later version

Applications of Solver and Scenario Planning

Introduction to VBA

Introduction to Excel Dashboards

Integration of Excel workbook with online economic data sources

Training on conducting examinations in excel

 

DATES:

November 26 & 27, 2017

 

 

VENUE:
Christ Institute of Management
Lavasa, Pune

 
  Early Bird discounted fee (paid before October 15, 2017) Actual fee (paid after October 15, 2017)
Registration Fee INR. 6400/- INR. 8000/-

The fee covers course material, meals (breakfast, lunch and dinner) and coffee on workshop days.


The participants will also have an option for boating in the beautiful Lavasa Lake.

 

PAYMENT MODE

 

 

Accommodation: Rs. 750/- per night per participant (AC accommodation on twin sharing basis.)

 

EARLY BIRD OFFER: There will be a 20 percent off on registrations before October 15.

 

DAY - 1

Micro Economics (Concepts)

Advanced review of Demand and Supply in the context of Marketing Decisions

Review of Market structures in the context of industry performance

Micro economics as a primer to strategic management

 

 

Micro Economics (Excel Applications Hands on)

Data handling and chart building for marketing decisions using demand and supply data

Application of regression for demand forecasting

Solver applications for calculating equilibrium

Dashboard creation for demand management decisions

Solver applications for optimizing advertisement spending

 

DAY - 2

Macro Economics (Concepts)

Primer on ISLM model as a framework for long term decision making

Advanced review of product market components in greenfield investment decisions

Advanced review of money market components while making capital sourcing decisions

Macro Economics (Excel Applications Hands on)

ISLM excel template creation using VBA

Solver applications in calculating money market and product market equilibrium

Essential financial functions for money market calculations

Application of Goal Seek and Scenario planning in macroeconomic decision making

 

 

Prof. Binu P. Paul Ph.D.

Ph: +91 20 667 53 818

Mob: +91- 9765 095 482/ 9591 346 789

Email: b.p.paul@cimlavasa.in
 

FOR MORE DETAILS

 

 

 

Contact us

    Christ Institute of Management (CIM)
    30 Valor Court, At Post: Dasve Lavasa,
    Taluka: Mulshi
    Pune 412112, Maharashtra.
    Ph.No : 1800-123-2009
    Mob No : 1800-123-2009
    Email : mail@cimlavasa.in

Contact us

MAKE AN APPOINTMENT WITH AN ADMISSIONS COUNSELOR
With this PGDM degree can i apply for govt jobs?
Website Design, Website Development, Web Hosting by INI Technologies Pvt Ltd, Cochin, India