Day 1: Foundations of Project Management in Google Sheets

• Introduction to Project Management Concepts

• Google Sheets Essentials for PM

• Data entry, formatting, and basic formulas

• Conditional formatting for progress indicators

• Creating a Project Timeline and Gantt Chart in Sheets

• Using Data Validation for Status and Task Assignment

• Task Dependencies and Priority Settings

• Using Named Ranges and Protected Ranges

• Collaboration & Version Control in Google Sheets

• Hands-on: Create a Basic Project Tracker Template

Day 2: Automation and Analysis in Google Sheets

• Intermediate Functions for Project Monitoring

• IF, VLOOKUP, ARRAYFORMULA, FILTER, IMPORTRANGE

• Using Google Forms for Task Updates and Feedback

• Setting Up Alerts and Notifications with Google Apps Script

• Automating Status Dashboards with Pivot Tables

• Integrating Multiple Sheets for Departmental Views

• Progress Tracking with Burndown and Velocity Charts

• Hands-on: Build a Multi-Sheet Project Tracker with Automation

Day 3: Visualizing Projects with Looker Studio

• Introduction to Looker Studio

• Connecting Google Sheets as a Data Source

• Designing Project Dashboards

• Task completion charts, timelines, milestones

• Stakeholder-specific views

• Using Filters, Scorecards, and Date Controls

• Embedding Dashboards in Google Sites or Docs

• Real-Time Reporting and Sharing

• Best Practices for Dashboard Design

• Final Activity: Build and Present a Project Dashboard