Walk through building and managing a comprehensive project task list for Commercial Sites using Microsoft Excel. Track progress, responsibilities, deadlines and insights. Get real time clarity on how your project is operating.
With over 700+ detailed steps, save weeks of trial and error and use the spreadsheet we use here at Greenwood.
You will learn how to analyze real project data from employee performance through too task efficiency.
This course bridges the gap between solar project management theory and hands on execution.
By the end of the course, you will have a repeatable, customizable framework to track and optimise any renewables project.
RUN TIME: 42 mins
CPD POINTS: 20
CPD POINTS: CPD387
✔ How to Build a Comprehensive Project Task List
✔ Use Categories and Data Validiation for Deep Analysis
✔ Apply Automations for task tracking
✔ Analyse employee workload and performance
✔ Build Fast Visual Dashboards and Charts
✔ Integrating Broader Project Management Tools
This course is for you if you’re serious about managing solar projects with precision instead of guesswork.
It gives you a ready-to-use framework that tracks hundreds of moving parts without needing expensive software.
You’ll gain the skills to analyze data, measure performance, and make smarter project decisions on the fly.
Whether you’re a project manager, installer, or designer, it’s the system that turns chaos into clarity.
COURSE SNEAK PEAK
Over 700 different tasks
Inside what tasks to focus on
TASK CELL BREAKDOWN
SIMPLE TRICKS DEPENDING ON PROJECT
INTERROGATE DATA FOR BETTER INSIGHTS
REAL WORLD EXAMPLE PROCESS
You’ll learn how to set up and structure a comprehensive project task list with hundreds of detailed steps.
This isn’t just data entry - it’s building the backbone of your project tracking system.
By the end, you’ll know how to create a repeatable framework that adapts to any solar project size.
The course shows how to use multiple categories with validation lists to sort and filter tasks.
This gives you the power to instantly spot bottlenecks, analyse trends, and drill into specific areas like DC installation or commissioning.
You’ll move from raw data to meaningful, actionable insights.
From COUNTIFS to conditional formatting and even custom LAMBDA formulas, you’ll see how to automate reporting.
Completed tasks tick off automatically, deadlines trigger calculations, and incomplete tasks are highlighted for attention.
This transforms a static spreadsheet into a live project dashboard.
You’ll discover how to assign tasks to employees and measure their contributions.
The system shows exactly who’s completing work, what percentage of the load they’re carrying, and which tasks dominate their time.
This ensures fair accountability while highlighting opportunities for upskilling or reallocation.
Data means little without clarity, so you’ll learn to turn numbers into visuals.
Donut and pie charts will show completion rates at a glance, while summary dashboards highlight progress across multiple projects.
These tools give stakeholders an instant, professional-level project snapshot.
The spreadsheet doesn’t exist in isolation - it’s built to work alongside Gantt charts, punch lists, and even platforms like Airtable.
You’ll learn how to connect these systems for a complete project management toolkit.
This integration ensures that you can scale from a single project to managing entire portfolios.
Principal Engineer (MIEAust) | Arigo Consulting
"Greenwood Academy’s courses cater from entry level to high end engineering. 10 Years of experience in an ever growing industry is captured perfectly in relevant course content."
North Electrical
"I've been a Sparky for 15 years with no major focus on solar or batteries. Doing the courses has given me huge confidence to price up jobs and we are winning more work as a result."
DRL Electrical
"Straight to the point training. Relatable course content that is genuine. Learning a lot and I'm only half way through the list."