Create a Custom Project Tracker in Excel Video Course

What you'll learn

• Build a Custom PM Tracker: Learn to design an Excel-based project tracker tailored to your workflow.
• Streamline Project Monitoring: Use formulas, charts, and conditional formatting to track progress and deadlines.
• Optimize Resource Allocation: Create actionable insights to manage tasks, budgets, and resources effectively.
• Automate Tracking: Create automated features to streamline project management tasks.

This course includes:

• 1-hour on-demand video
• 2 downloadable resources

• Access on mobile and TV
• Certificate of completion

Who this course is for:

• This course is perfect for beginners, aspiring project managers, and professionals looking to master project tracking in Excel with no prior experience needed.

Top companies offer this course to their employees
This course is trusted by businesses worldwide.

30-Day Money-Back Guarantee

Full Lifetime Access

I'm Justin, and I’ll be your instructor of record for this course.  My team at Projects Right, led by me, has also prepared some tutorials for you in the course.

Together, we’ll unlock the power of Excel to help you create an efficient, user-friendly project management tracker from scratch.

We’ll tackle the common challenges faced when organizing and tracking projects, like juggling deadlines, monitoring progress, and managing resources. Each concept will be broken down step by step, with clear explanations and hands-on examples to ensure you can apply these skills confidently.

In this course, you’ll explore:

• Data Entry and Organization: Learn how to structure your project data for maximum clarity and ease of use.
• Task Dependencies: Set up links between tasks to manage timelines effectively.
• Resource Allocation: Track resources and ensure projects stay on schedule.
• Progress Tracking: Create visual dashboards to monitor and showcase progress.
• Automation Basics: Simplify your workflow with Excel’s built-in tools.

By the end of this course, you’ll have a professional project management tracker customized to your needs, equipping you to organize and manage projects with ease, even if you’re new to Excel or project management.

Also included are two copies of the completed tracker I created, so even if you don’t want to build one yourself, you’ll still have a ready-to-use tracker at your fingertips.

Course content

9 video lectures • 53m total length

Build Your Own Tracker in Excel

2. Mastering Excel Basics: A Quick Refresher (02:45)
3. Creating Dynamic Dropdown Menus in Excel (03:28)
4. Unlocking the Power of Color Coding for Better Data Visualization (06:28)
5. Formulas Simplified: Boost Your Excel Productivity (02:37)
6. Building Data Hierarchies: Organize Like a Pro (04:31)
7. Step-by-Step Guide to Creating a Gantt Chart in Excel (11:52)
8. Visualizing Progress: Crafting Effective Diagrams in Excel (10:50)
9. Linking Data Seamlessly: Mastering Dependencies in Excel (09:58)

Join me, and let’s simplify project management—one Excel sheet at a time!