How to Present Data in Excel for University Assignments

What markers look for

University markers assessing Excel work are looking for three things: accuracy (are the formulas correct?), clarity (can they follow your analysis?), and interpretation (do you understand what the numbers mean?). Most students get the accuracy right but lose marks on clarity and interpretation.

Structure your workbook properly

One sheet per stage — Raw Data, Cleaned Data, Analysis, Charts, Summary
Label every sheet with a clear name, not "Sheet1", "Sheet2"
Put your name and date in cell A1 of the first sheet
Never mix data and analysis on the same sheet

Formatting for clarity

Number formatting

Currency:    Ctrl+Shift+4    (£1,234.56)
Percentage:  Ctrl+Shift+5    (12.34%)
Comma:       Ctrl+Shift+1    (1,234)
-- Always format numbers consistently within a column
-- Match decimal places across comparable figures

Headers and structure

Bold your column headers (Ctrl+B)
Add a bottom border below header rows (Ctrl+1 → Border)
Use consistent colour for header rows — dark background, white text is professional
Freeze the header row (View → Freeze Top Row) if scrolling is needed

Summary tables

Every analysis should end with a summary table showing the key findings — not raw data, but interpreted results. A table showing mean, median, standard deviation, and min/max for each variable is cleaner and more readable than a wall of numbers.

-- Summary statistics table structure:
Variable | N | Mean | Median | Std Dev | Min | Max
GDP      | 50| =AVERAGE(...)| =MEDIAN(...)| =STDEV(...)| =MIN(...)| =MAX(...)

Charts for assignments

Title every chart with what it shows, not just the variable name
Label axes with units
Use 2D charts — no 3D effects
Match chart colours to your overall colour scheme
Caption every chart below it: "Figure 1: GDP growth rate 2000–2026 (Source: World Bank)"

Common mistakes that lose marks

Showing raw data instead of summarised findings
Charts with no titles or axis labels
Inconsistent decimal places (showing 12.3% and 14.27% in the same column)
Hardcoded numbers in formulas — markers check formula bars
No source citation for external data

💡 Print preview before submitting

Always check Print Preview (Ctrl+P) before submitting. Columns often overflow the page width invisibly. Set print area, adjust column widths, and choose landscape orientation for wide tables.

Now practise it for real

Practice these formulas in the Students track — built for university assignments and graduate job assessments. Free to start.

Start the Students track free →

How to present data in Excelfor university assignments