About this course
Ready To Sign Up Today? Click Here to Enroll
Course outline
3 modules • 21 assignments • 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
-
What 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