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



November 26 & 27, 2017



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.





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





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

How can I make a gift to CIM?
Website Design, Website Development, Web Hosting by INI Technologies Pvt Ltd, Cochin, India