IT Project Triangle, Scope, Timeline and Budget

Proper Contingency Planning

Top 10 Conditional Calculations in Microsoft Excel

Top 10 Conditional Calculations in Microsoft Excel

Project Management Templates bundle with free upgrades

Mark Whitfield’s Project Management templates are a comprehensive, editable suite of over 200 documents designed for Agile, Waterfall, and PRINCE2 methodologies, based on over 30 years of project delivery experience. Available through his website (click banner link above), Etsy, Flevy and Eloquens, these templates are designed to be used across the project lifecycle—from initiation to closure—and include lifetime free updates and additions.

Full Overview of Mark Whitfield Template Bundle

The bundle, priced at around £38.00 (as of April 2026), provides tools for MS Excel, Word, PowerPoint, and MS Project (.mpp).

1. Planning & Scheduling

MS Project (MPP / MSP): Includes full PRINCE2 7th Edition, Agile Scrum, and SDLC (Software Development Life-cycle) plans.
Excel Detailed Plans: Includes Gantt chart tracking for users without MS Project.
Plan on a Page (POaP): Over 30 PowerPoint examples for executive summaries.

2. PRINCE2 & Governance

Full set of over 200 documents including Project Initiation Document (PID), Business Case, Work Packages, Risk Management Strategy, and Configuration Item Records.
Reporting: Highlight reports, exception reports, and end-stage reports.

PRINCE2 Delivery Plan in MS Excel Example

3. Tracking & Risk Management

RAID Logs: Comprehensive trackers for Risks, Assumptions, Issues, and Dependencies (includes simple and detailed versions).
Finance Trackers: Simple and full project finance trackers (forecasting, actuals, variance, rate lookups).
RACI Matrix: Resource Responsibility Assignment Matrix.

Many Project Budget / Financial Tracker examples

4. Execution & Delivery

SDLC: Detailed Software Development Life-cycle plans.
Deployment/Runbook: Execution and release planning documents.
Agile: Burn down and burn up charts.

Detailed Timeline by Project Life Cycle

Templates provide detailed MS Project (.mpp) and Excel schedules that map out the standard project life cycle over time. The plans include notes and color-coded tasks (black: standard task, blue: artifact creation, brown: decision/event, purple: artifact update).

1. Project Startup / Initiation Phase

Tasks: Project Mandate, Project Brief preparation, Appoint Project Board, Define Project Approach.
Key Templates: Project Brief, PID, Business Case, Project Board Structure.

2. Planning Phase

Tasks: Develop the PID, Create Detailed Gantt Plans, Create Budgeting/RAID Logs, Setup Communication Strategies.
Key Templates: Detailed MS Project Plans (Waterfall/Agile), RACI Tracker, RAID Log.

3. Project Execution / Control Phase

Tasks: Weekly Status Reporting, Risk Management, Managing Product Delivery, Stage Assessments.
Key Templates: Highlight Report, Issue Register, Daily Log, Financial Tracker.

4. Project Close Phase

Tasks: Handover, Project Evaluation, Lessons Learned, Finalize Costs, Close Project.
Key Templates: End Project Report, Lessons Log, Benefits Realization Plan.

Summary of Key Features

Fully Editable: Designed to be tailored to specific project needs (PRINCE2 Principle 7).
Access: Compatible with Desktop, Tablet, Smartphone, and Cloud (Microsoft Teams/SharePoint).
Support: Free lifetime upgrades (and additions) to the latest template package after purchase.
Click on link in website banner above to purchase full templates bundle

Project Management Templates bundle with free upgrades.

Finance Terms every IT Professional Should Know

Key Skills for the Project Manager

Cost Estimating vs Cost Planning

In professional project management and construction, cost estimating and cost planning are complementary processes that occur at different stages to ensure a project remains financially viable.

1. Cost Estimating: “What will it cost?”

Cost estimating is a technical assessment used to predict the expenditures for a project.

Early Stages: Estimates might be “rough orders of magnitude” based on square footage or historical data (e.g., cost per hotel room).
Later Stages: Estimates become precise “tender figures” used by contractors to bid on work, factoring in current market rates for labour and materials.
Function: It answers the question: “Is this specific plan affordable?”.

2. Cost Planning: “How do we stay on budget?”

Cost planning is a strategic framework that manages a project’s financial health from start to finish.

Iterative Process: It is a “living document” that is updated as the project moves from concept to detailed design.
Allocation: It breaks down the total budget into “elemental” targets (e.g., spending £X on the foundation and £Y on finishes).
Control: If an estimate for one part of the project exceeds its target, the cost plan guides the team to adjust the design or find savings elsewhere to keep the overall project on track.

Standard Professional Guidance

The Royal Institution of Chartered Surveyors (RICS) provides the New Rules of Measurement (NRM 1), which standardises how these processes work together:

Order of Cost Estimate: Establishing the initial viability of a project.
Elemental Cost Plan: Breaking the estimate down into functional parts.
Cost Checking: Continually comparing design changes against the cost plan to prevent overspending.

Budgeting vs Forecasting, Financial Concepts overview

Project Management and Cost Control

Microsoft Excel Development Timeline History

Microsoft Excel has evolved from a niche Apple Macintosh tool into the world’s most dominant spreadsheet software. Its history is marked by strategic shifts, such as jumping from the MS-DOS era to graphical interfaces to outmanoeuvre then-leader Lotus 1-2-3.

Timeline of Major Excel Milestones

Agile Templates available at download link at website banner

1982: Multiplan (The Predecessor) – Microsoft’s first spreadsheet program. While popular on CP/M systems, it struggled against Lotus 1-2-3 on MS-DOS.
1985: Excel 1.0 (Macintosh Exclusive) – Realising they couldn’t beat Lotus on DOS, Microsoft built a graphical spreadsheet for the new Mac. It introduced the ability to adjust cell heights, widths, and fonts.
1987: Excel 2.0 (First Windows Version) – Launched alongside the first Windows environments, it introduced color support (like red for negative numbers) and was significantly faster than competitors.
1990: Excel 3.0 – Added 3D charts, toolbars, and drawing tools, helping Excel finally overtake Lotus 1-2-3 as the market leader.
1993: Excel 5.0 – A major turning point that introduced Visual Basic for Applications (VBA), allowing users to automate tasks with macros.
1997: Excel 8.0 (Office 97) – Introduced the Paperclip Assistant (“Clippy”) and the first version of the modern VBA environment.
2007: Excel 12.0 (The Ribbon Era) – Replaced menus with the Ribbon interface and dramatically increased grid capacity to 1,048,576 rows by 16,384 columns.
2010: Excel 14.0 – Introduced Slicers for PivotTables and Sparklines (mini charts inside cells).
2013-2016: Data Intelligence – Added Power Query, Power Pivot, and new chart types like Waterfall, Pareto, and Treemap to support advanced data modeling.
2019-Present: AI & Cloud Integration – Modern versions focus on seamless collaboration, dynamic arrays (like XLOOKUP), and AI-powered insights that can extract data directly from images.

Technological Evolution Highlights

MS Excel templates available on bundle download at website banner

Architecture: Shifted from 16-bit to 32-bit with Excel 95, greatly improving stability.
Collaborative Features: Modern Version History and “Show Changes” now allow teams to track every edit in real-time.
Visualisation: Excel now supports complex timelines via SmartArt or custom Scatter charts with error bars for professional project tracking.

Microsoft Excel Development Timeline History