Excel Skills for Jobs in Sri Lanka: A Practice Project

Excel skills for jobs in Sri Lanka are easier to demonstrate through a small working workbook than a long list of function names. Build a fictional stock workbook that shows clean data, a lookup, a summary and checks you can explain in an interview.

The goal is a reliable result that another person can maintain.

Define the workbook's purpose

Use two sheets: Products and Movements. Products contains one row per product code; Movements records fictional quantities received or issued.

Product code	Product	Opening quantity
P01	Notebook	20
P02	Pen pack	15
P03	Folder	10

Keep the product code as the matching key. Product names may change or repeat, so they are less reliable as an identifier.

Write a short note explaining whether quantities issued are negative or stored in a separate column. Use the same convention throughout the workbook.

Keep the source data tidy

Use a single header row, consistent column types and no merged cells inside the data table. Avoid mixing notes and totals into the middle of transaction rows.

Check duplicate product codes, blank quantities and numbers stored as text. A summary can look correct while excluding malformed values.

Preserve the original sample so you can show what changed during cleaning. Do not hide errors by manually typing a desired total into the output.

Add a lookup you understand

Use a lookup to return the product name from its code. Microsoft's XLOOKUP documentation explains the function and its version limitations.

Test a valid code, an unknown code and a duplicate in the lookup table. Decide how the workbook should display an unmatched item.

If the employer uses an older Excel version, prepare a compatible approach and explain the difference. The best formula is one the intended users can run and maintain.

Build a useful summary

Calculate current quantity from opening stock and movements, then summarise the information the user needs.

Microsoft's PivotTable guide describes using tabular data to calculate and summarise results. A simple summary by product can be enough for this exercise.

For a fictional product with opening quantity 20, receipts of 8 and issues of 5, the expected closing quantity is 23. Verify that result manually before trusting the workbook.

Add checks and explain the result

Create a small exceptions area for unknown product codes, missing values and negative closing quantities. A negative quantity may indicate a data problem or a real process issue; it needs investigation rather than automatic deletion.

Label the workbook as fictional practice data. Do not present it as a real Sri Lankan retailer's stock record.

Write a short handover note explaining how to add rows, refresh summaries and interpret exceptions. That documentation demonstrates workplace judgement as well as spreadsheet skill.

Which Excel skills should you learn first?

Start with clean tables, basic calculations, filtering, lookups and summaries. Add more advanced functions when a real task needs them.

Should you use colour to show every status?

Use clear labels as well. Colour alone may be difficult to interpret or inaccessible to some readers.

Can AI help write the formulas?

Yes, but define expected results and test the output. Do not use a formula you cannot explain.

What should you demonstrate in an interview?

Show the input, one important calculation, a detected error and the final summary. Explain how another person would update the workbook.

What makes the project credible?

Accurate calculations, visible assumptions and a repeatable process matter more than a decorative dashboard.

Related guides

• Remote Work Setup in Sri Lanka: A Practical Checklist
• Freelance Proposal in Sri Lanka: Scope and Sample
• AI for Spreadsheet Formulas: A Practical Work Guide

Browse the Sri Lanka work and technology guides for more practical application, AI and workplace projects.