Mar 23, 2017

Dynamic Salesmen Goal Tracking Model in Excel

I find that making models is increasingly important for general organization management. What I have gone and built today is a straight forward goal tracking template. The idea is to see how growth is changing on a monthly/quarterly/annual basis. The annual is included but I didn't talk much about it in the video.

Mar 7, 2017

Using Excel to Perform Survey Analysis

Excel is a great way to take responses from a survey and to complex statistical analysis. What I have shown in the video and in this excel template is the count formulas that are required to report on various sub-groups for a given question or multiple questions. There are a wide variety of ways to go about survey analysis, but this captures the fundamental mechanics of understanding your respondents answers.

Mar 4, 2017

Break-Even Financial Model

This is a great tool for any business or organization to use in order to see how much money they need to make in sales to break even. It will be effective and useful no matter what you are doing. The user interface is super easy and there are some nice charts to make things a bit more visual.