Project Management Dashboard

📊 KEEP EVERY PROJECT ON TRACK, IN ONE PLACE

Stop juggling sticky notes and scattered to do lists. This Project Management Dashboard brings all your projects, tasks, deadlines, and progress together in one organized spreadsheet, with an automatic dashboard and a Gantt style timeline that update as you work.

Works in BOTH Microsoft Excel and Google Sheets, with NO macros, so the timeline works in both (unlike many macro based templates that break in Google Sheets). Buy once, use forever.

WHAT'S INSIDE (6 connected tabs)

• DASHBOARD: Everything at a glance: total tasks, completed, in progress, overall progress, active projects, and high priority open items, plus charts for task status, progress by project, and tasks per project.
• TASKS: Your full task tracker: task, project, owner, priority, start & due dates, status, and % complete, with easy dropdowns and an automatic "days left" countdown.
• PROJECTS: An automatic summary of each project: task counts by status and average progress.
• TIMELINE: A formula based Gantt chart. Bars fill in automatically from each task's start and due dates, a clear, week by week view with no setup and no macros.
• SETTINGS: Customize your projects, team members, statuses, and priority levels.
• START HERE: Simple step by step setup instructions.

WHY YOU'LL LOVE IT

• See every project and deadline in one dashboard
• Automatic Gantt timeline, no macros, no setup
• Track progress, owners & priorities at a glance
• Spot high priority and overdue tasks instantly
• Beautiful charts that update automatically
• Works in Excel AND Google Sheets
• Comes pre filled with examples so it makes sense instantly
• Fully editable, no monthly subscription

PERFECT FOR

• Freelancers & consultants juggling clients
• Small teams & business owners
• Solopreneurs managing multiple projects
• Anyone who wants order instead of chaos

INSTANT DIGITAL DOWNLOAD

Your files are available immediately after purchase. Nothing is shipped.

You'll receive:

• The spreadsheet file (.xlsx, opens in Excel & uploads to Google Sheets)
• A Start Here guide with setup instructions

HOW TO USE IN GOOGLE SHEETS

1. Go to Google Drive, New, File Upload, select the file
2. Open it, then choose File, Save as Google Sheets
3. Done! All formulas, charts, and the timeline carry over.

(Full instructions are included on the Start Here tab.)

NEED HELP?

Questions or a hiccup? Just message the shop, we respond quickly and we're happy to help. Your success (and a kind review!) means everything to a small shop like ours. 💚

This tool is for informational and organizational purposes only.

© McGuigan Software · Smart Sheets. Powerful Insights.