Create A Project Tracker Using Spreadsheet Software

Track and monitor your projects by creating professional spreadsheets including a project tracker and budget.

What you’ll learn
Plan and preparation before building and using a project tracker
Build a project tracker using spreadsheet software
Learn how to use a project tracker for a project
Build a project budget using spreadsheet software
Learn how to control costings and the budget for a project
Create a project status report using spreadsheet software
Understand the importance of the project status report to stakeholders

Requirements
Project management experience or working as part of a project team would be beneficial
Understanding of project management in practice
Microsoft Excel or LibreOffice Calc
Experience of working with spreadsheets

Description
Are you a project manager? Or a project administrator? Or are you a business student who wants to become a project manager? Do you want to add impressive skills to your resume? Do you need help creating tools that will track and monitor your projects? Do you want to be able to communicate effectively with your project team?If So, Then Continue To Read And Find Out How This Course Will Benefit Your Career And Improve Your IT Skills For Project Management.Here is a summary of what you will learn:Learn what a project tracker is and why it is critical to project management.Develop a project plan before moving on to creating the project trackerLearn how to build a professional presentation for monitoring and tracking by creating the project trackerDevelop skills with spreadsheet software such as formatting, conditional formatting, and design.Create a project budget to complement the project tracker for cost analysis and budget control.Create a project status report and learn its importance for stakeholder involvement and communication.Developing skills with spreadsheets and project management software is something that all project team professionals should do. This practical course will teach you how to create professional productivity tools designed to track and monitor the progress of a project. Not only that, you will create something visually impressive and you will be the go-to in the team for making the project’s spreadsheets and monitoring tools.Recent statistics from a research organisation suggest that only 22% of project managers use project management software. That means that most project managers are likely to use spreadsheet software such as LibreOffice Calc or Microsoft Excel.One of the main reasons that project managers do not use project management software is the lack of support from an organisation. Learning how to use spreadsheets to create effective management tools means that you will not have this problem. There will be no need to use expensive software that nobody knows how to use!Projects require ongoing monitoring and tracking. You will already understand this but have you got the skills to work with spreadsheets and create something effective? By the end of this course, the answer will be ‘yes’.One of the essential tools you, and your project team, are going to need is the project tracker. The project tracker is a critical tool to monitor and manage various aspects of a project. You will use this tool to monitor progress, tasks, schedules, and resources. There are various software solutions out there but being able to create a tracker enables you to build something specific to your project.A project tracker is an invaluable tool that will help you and your team stay organised. The tracker is also an effective communication tool. You can communicate to your team how progress is going and highlight any issues with tasks.You will learn how to plan the layout, add formatting, and include conditional formatting to your project tracker. This will provide you with an excellent visual presentation of your tasks, schedules, resources, and progress. Your team will easily be able to view the progress of the project and have no difficulties in understanding the information.The course also provides additional tools that will complement the project tracker. The first tool is the plan. You will need to create a project plan before building the tracker. This will enable you to plan the tasks, deliverables, milestones, and outcomes of the project. From the plan, the project tracker can be developed.Another essential tool is the project budget. You will learn how to create one. The project budget should be used to complement the project tracker. The project tracker focuses on the general management of schedules and resources. The budget focuses on cost analysis and budget control, the financial management of the project.The course includes tutorials that will teach you how to create a project status report. You will learn what the status report is and why it is essential for communication. Think of the project status report as a snapshot of the project tracker.Enrolling on this course will allow you to progress through easy-to-follow tutorials broken down into short video lengths. You will easily be able to learn at your own pace. This course will take you through each step of creating a professional project tracking tool. You will also be provided with spreadsheet templates that you can review and play around with. However, it is recommended that you learn how to build a project tracker from scratch to improve your spreadsheet development skills.The tutorials feature LibreOffice Calc as the spreadsheet software of choice. However, Microsoft Excel has the same functionality and you will be able to create the tools shown in the tutorials. The navigation may be a little different but you will be expected to have spreadsheet experience before enrolling on this course.The course is not going to teach you all about project management. There will be several tutorials included that will teach you about the jargon associated with project tracking such as deadlines, deliverables, milestones, and risk management. But you should already have a good understanding of project management in practice either through experience or studies.This course is all about you developing spreadsheet skills that most modern organisations will be looking for. Enrol now and add those essential IT skills to your resume. You will be an asset to your organisation or future employers!

Overview
Section 1: Introduction

Lecture 1 Introduction to Project Management

Lecture 2 Applying Project Management Skills to an Industry

Lecture 3 Course Summary

Lecture 4 About the Course Tutor

Lecture 5 Improve Team Performance with a Project Tracker

Section 2: Project Planning

Lecture 6 Project Planning

Lecture 7 Creating the Project Plan

Section 3: Creating the Project Tracker

Lecture 8 Layout and Column Titles

Lecture 9 Formatting Cells

Lecture 10 Conditional Formatting

Lecture 11 Demonstrating the Project Tracker

Lecture 12 Introducing Gantt Charts

Section 4: Project Budgeting

Lecture 13 The Project Budget

Lecture 14 Creating the Project Budget

Lecture 15 Demonstrating the Project Budget

Section 5: The Project Status Report

Lecture 16 Reporting to Stakeholders

Lecture 17 Creating the Project Status Report

Lecture 18 Demonstrating the Project Status Report

Section 6: Key Terms and Jargon

Lecture 19 Knowledge Applied to Project Management Tools

Lecture 20 The Difference Between Deadlines and Milestones

Lecture 21 What are Project Deliverables?

Lecture 22 What is Risk Management?

Lecture 23 Professional Project Management Tools

Project Managers,Project Team Members,Office Support Staff,Resource Managers,Business Students