About this course
Instead of guessing if you are going to make money, don’t you want to know, in advance?
Gross margin is the one (and often) only metric to give you a sense of how you are doing. Like going to the doctor to get a checkup. This is the one thing the doctor will say to you: “How are your gross margins?”. This applies to all businesses.
If you know what they are, then you can manage the busy times and the slow times. You will be able to determine the difference between taking work because you are slow or turning away work because it won’t make financial sense to do this. Using this simple yet powerful excel tool will revolutionize how you and your company think. This tool takes the emotion out of decisions.
And when you share this knowledge with your team, something else happens. There is a shift in their ability to understand the business. They know they can influence outcomes. Ownership thinking is born.
Managers know how to pull the information together and make short and long-term decisions. The health of the company goes beyond numbers. People feel their input matters and are part of the solution.
This tool will take the guesswork out of estimating a solar projects profitability. Your thinking will change about only looking at what something is installed for in the usual language of “cost per watt”. You won’t be just talking about how many million in sales you did but more importantly, how many million did you get to keep.
Ready To Sign Up Today? Click Here to Enroll
Course outline
3 modules • 21 assignments • 2 - 5 hours to complete • 1:33 hours of video lectures
Welcome • 3 assignments
Orientation Materials
- Set up email notifications and your student profile
- Introduce yourself on the discussion board
- Marginator Demo Video (11:13 minutes)
Module 1 • 14 assignments
Solar Cost Estimating ScoreCard
- The Marginator 1 - Introduction (04:42 minutes)
- The Marginator Excel File (.xlsm)
- The Marginator 2 - Workbook Layout (06:34 minutes)
- The Marginator 3 - How to Share Profits (04:51 minutes)
- The Marginator 4 - How to Use Each Worksheet (04:36 minutes)
- Marginator 5 - Estimating your first project (09:28 minutes)
- The Marginator 6 - Data Validation and Macros (04:12 minutes)
- The Marginator 7- Name Ranges and VBA (04:32 minutes)
- The Marginator 8 - Macros and the formulas (08:41 minutes)
- The Marginator 9- Client Data Saving and Retrieving (04:11 minutes)
- The Marginator 10 - Did You Make Money (07:00 minutes)
- The Marginator 11 - Index - Match and Finding Information (09:32 minutes)
- The Marginator 12 - Slicers and Sorting Data (05:25 minutes)
- The Marginator 13 - Deep Analysis - Pivot Tables (08:17 minutes)
Conclusion • 4 assignments
Feedback and Additional Resources
- 1 Year of Access to Course Materials
- Feedback: 2-minute Exit Survey
- Consider Joining as a HeatSpring Member
- Certificate of Completion: Request a Certificate
Instructor
-
Keith Cronin
SunHedge LLCWhat kind of world do you want to live in? Two plus decades of cleantech experience on our journey together to sequester carbon in meaningful ways. Blessed with a multidisciplinary skill set of development, finance, business, and deep connections globally. The road to your destiny is often a curved line. After a decade on the East Coast, it catapulted me to Hawaii to... Learn more