The request here is practical and grounded, and that's exactly the right starting point. A recent MSc Finance graduate has completed an Excel fundamentals course and now wants to build a portfolio that opens doors to analyst roles. That instinct, to move from theory to demonstrable skill, is what separates candidates who get interviews from those who don't. The question isn't whether Excel matters for these roles; it's how to show you can use it to solve real problems.
For entry-level analyst or operations positions across industries, recruiters are not looking for complex financial models or VBA macros. They want someone who can take raw data, clean it, structure it, and draw clear conclusions. The most effective projects are those that mirror the daily work of the role itself. For a finance or operations analyst, build a project around budgeting or variance analysis. Take a sample dataset of departmental expenses over twelve months, create a dynamic dashboard with pivot tables and slicers, and use XLOOKUP or INDEX-MATCH to pull in budget targets. Show you can calculate variances, highlight exceptions, and summarize findings in a clean, readable format. This demonstrates the core skills: data organization, logical formulas, and the ability to communicate numbers without jargon.
For broader roles in logistics, retail, or even HR analytics, a project on inventory management or workforce scheduling works well. Use conditional formatting to flag low stock levels or overtime thresholds. Build a simple what-if analysis with scenario manager or goal seek to show how changes in demand affect staffing needs. These projects prove you understand how data drives decisions, not just how to manipulate cells. The key is to document your process. Include a brief written explanation of the problem, the steps you took, and what the output means. That narrative transforms a spreadsheet from a technical exercise into a portfolio piece that tells a story about your thinking.
The graduate's openness to any field is an advantage, not a limitation. It means they can choose projects that highlight transferable skills rather than niche knowledge. We recommend building two projects from different domains, one finance-focused and one operational, to show range. Then, in applications, lead with the project most relevant to the role. That strategy turns a generalist background into a tailored pitch. The goal is not to prove you know every Excel function. It is to prove you can use the right ones to answer a business question. Start there, and the portfolio will do the talking.