The “PSL Excel Template”, or “PSL” for short, is a powerful tool designed to facilitate project management within the familiar environment of Microsoft Excel. It empowers project managers and development teams to plan, track, and manage projects efficiently, fostering collaboration and productivity.
This user guide is intended for professionals involved in project management, including but not limited to project managers, product owners, developers, and team members. Whether you're new to traditional or agile methodologies or a seasoned practitioner, this guide will help you harness the full potential of the “PSL Excel Template”.
Before installing the PSL Excel Template, ensure you have the following system components:
Furthermore, because PSL is an Excel Template, you must have some basic experience and knowledge of the MS-Excel tool.
Before diving into the PSL Excel Template, it is essential to familiarise yourself with the fundamental Microsoft Excel concepts that are integral to using this template effectively, namely:
Workbook: A workbook is an Excel file that contains one or more worksheets. Think of a workbook as a digital notebook where you can store and organise data. In the context of the PSL Excel Template, your project data is stored within a workbook.
Worksheet: A worksheet, also called a spreadsheet, is a single grid of cells organised into rows and columns. Each worksheet within a workbook is a separate tab where you can input, calculate, and visualise data. This template uses worksheets for various purposes, such as project definition, managing product and sprint backlogs, and reporting.
Tables: Tables in Excel are structured ranges of data that include headers. They make managing, sorting, filtering, and analysing data easier. The “PSL Excel Template” utilises tables extensively to keep your project data organised and accessible.
Charts: Excel offers various chart types to help you visualise data, from simple bar and pie charts to complex graphs. Charts are delivered within the template to provide visual insights into your project's progress and performance.
Formulas: Excel's real power lies in its ability to perform calculations using formulas. Formulas are expressions that can perform various mathematical, logical, and text operations on your data. The template employs formulas to automate calculations, such as sprint velocity and burndown rates.
Macros: Macros are sequences of actions recorded in a scripting language, like VBA (Visual Basic for Applications), that allow to automate tasks. While the PSL does not require extensive macro knowledge, it includes macros to streamline specific processes or tasks.
Ribbon: The Ribbon is the toolbar at the top of the Excel window that houses various tabs, each containing a group of buttons and actions. Excel's functionality is organised into tabs, such as Home, Insert, Page Layout, Formulas, Data, Review, and View. The PSL also includes a “PSL” custom ribbon tab with groups of buttons for template-specific actions.
Group of Buttons: Groups of buttons in Excel are collections of related functions grouped within a tab on the ribbon. For instance, the Data tab includes groups like Sort & Filter and Data Tools. The PSL also introduces custom groups with buttons tailored to support or automatise project management tasks.
Understanding these MS-Excel general concepts will support a smoother PSL experience. You can navigate in the workbooks, manipulate data, and leverage Excel's features more effectively to manage your projects.
Welcome to the user guide for the “PSL Excel Template”. This guide will walk you through everything you need to know to effectively utilise this template for your project management needs. In the following sections, you'll find details about installation instructions, configuration guidance, and project definition, and then start configuring and managing your project based on Kanban, Scrum or similar approaches that you may customise.