We are seeking a Principal Consultant – Project Controls to play a key role in driving best-practice project planning, controls, reporting, and governance across the UK Transportation & Infrastructure (T&I) PMO portfolio.
The ideal candidate brings strong analytical capability, leadership, and extensive hands-on experience in planning, controls, forecasting, and digital reporting.
Responsibilities
Project Controls Governance
Implement WSP/T&I PMO project controls frameworks, ensuring compliance across projects.
Establish baselines and oversee change control processes.
Drive adoption of best practices, templates, and standards.
Cost Management & Forecasting
Develop and manage project budgets, cashflows, cost forecasts, and variance analyses.
Monitor earned value metrics and report deviations with actionable insights.
Support contingency planning and cost risk analysis.
Project Planning & Scheduling
Develop, review, and maintain integrated project schedules across multiple programs.
This guide is for freshers and experienced professionals in India preparing for the Excel round of MIS executive, accounts, operations, back-office and data analyst interviews, where a practical Excel test is common. It has 60 questions with answers in three levels: the basics every fresher must know (references, VLOOKUP, IF, SUMIFS, text and date functions, pivot tables), real work problems for 1-4 years of experience (lookup errors, dynamic arrays, slicers, Goal Seek), and senior topics such as Power Query, the Data Model, large-file performance and building a monthly MIS report. Sample data and formulas are shown as small tables with their results. Rebuild each example in Excel (Microsoft 365) as you read, then take the mock test.
Questions you may be asked
What is the difference between relative, absolute and mixed cell references?
How does VLOOKUP work, and why do you usually set its last argument to FALSE?