About this course
Ready To Sign Up Today? Click Here to Enroll
Course outline
1 module • 21 assignments • 1:33 hours of video lectures
Welcome • 3 assignments
Orientation Materials
This course is self-paced, so you don’t need to be logged in at any specific time. You can get started immediately after you enroll and the course materials will remain in your account with minimum guaranteed access for 12 months (1 year) after enrollment.
- 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
Want to know the difference between sales and profits? You've come to the right place. This is an extensive excel tool to help you wrap you and your team around performance. It will help you make better team decisions from this day, forward.
- 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
This is our last module but you still have access to the all of course materials for 12 months (1 year), so keep working and you'll be able to complete the course at your own pace. After your year of access expires you can optionally extend access with a HeatSpring Membership. Enjoy the course and keep in touch!
- 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