These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Thursday, April 17, 2014

Consultant Tools

Executive Summary

Partners In Leadership, Inc. is a widely respected international leadership training and management consulting company. Founded in 1989, the company is now the world’s premier provider of Accountability Training Services. All training services are based on books (most notably The Oz Principle) written by the company’s founders, which focus on creating greater accountability.

  • The Self Track Training helps people embrace their own accountability for achieving organizational results.
  • The Culture Track Training accelerates the change within organizational culture to produce the results the organization needs now.
  • The Others Track Training teaches people to effectively hold others accountable for results in a positive, principled way so that they successfully deliver on expectations.

The Excel Consultant Tools file I created will allow Partners In Leadership Consultants to assess how a company’s employees view accountability within the three tracks. Before doing a workshop or training session, consultants will send a Google Form link to the employees. The form will ask a series of 46 questions (on a scale of 1 to 10) that are related to the three accountability tracks. The Consultant Tools file will then scrape the data collected by the form online and put it in an Excel spreadsheet. With this data, pivot tables and charts will be automated so that the consultant can evaluate where the company is struggling with accountability. The objective is to give the consultant some direction in their training preparation.

Download the Project Write Up: VBAProject.pdf
Download the Excel file: ConsultantTools.xlsm

No comments:

Post a Comment

Blog Archive