Facilitated by TJ Badru.

In today’s Agile ecosystem, data-driven decision-making is essential—but powerful analytics doesn’t always require heavy BI tools. Join our June 2025 event, “Advanced Google Sheets & Excel for Agile Reporting and Custom Metrics,” where we explore how lightweight, familiar platforms can be leveraged to deliver impactful insights and drive team performance.

Why Spreadsheets Still Matter

• Ubiquity & Accessibility: Nearly all teams have access to Google Sheets or Excel, making them a natural starting point for reporting.

• Flexibility: From formulas to pivot tables, these tools allow rapid customization without coding.

• Cost-effective: Free for many, and scalable for small- to medium-sized teams.

Core Content & Takeaways

1. Building Agile Dashboards

• Learn to create sprint burndown charts, velocity trackers, and cumulative flow diagrams.

• Use SPARKLINE, conditional formatting, and pivot tables for dynamic visuals.

• Example: importing Jira data into Sheets to build a custom dashboard.

2. Crafting Custom Metrics

• Define key performance indicators: cycle time, lead time, throughput.

• Use formulas (e.g., AVERAGEIFS, COUNTIFS) to calculate sprint averages and trend metrics.

• Automatically enforce data integrity with Data Validation.

3. Automation Tactics

• Explore Google Apps Script to automate data refreshes and notifications.

• Leverage Looker Studio to connect Sheets for more powerful reporting

4. Gaming Excel for Reporting

• Enhance user dashboards using pivot tables and Excel templates like smartsheet.com’s Agile PM templates.

• Use named ranges, slicers, and charts for real-time filtering and drill-downs.

Event Highlights

• Live Demonstrations: Step-by-step builds of Sprint dashboards.

• Hands-on Labs: Follow-along custom metric development.

• Expert Q&A: Troubleshoot your own spreadsheet challenges.

• Templates & Code Snippets: Downloadable assets included.

Transform how your Agile team reports and responds.

Register now.

For “Advanced Google Sheets & Excel for Agile Reporting and Custom Metrics”—unlock the full potential of agile analytics.