Abercarn Primary School

Excel

Browse school help by topic, or search for a device, account, or learning platform.

Help by category

8 articles
Excel: add a column of numbers with SUM

Use this simple example for classroom resources or practice data. Check important totals against an independent calculation. Enter sample numbers in cells B2 to B6.

Read article
Excel: display dates consistently in a planning sheet

Date appearance depends on formatting and regional settings. A date typed in an ambiguous format may be interpreted differently on another device. Use a copy of the planning sheet for testing.

Read article
Excel: filter a resource table without deleting rows

Filtering hides rows temporarily; it does not remove them. Use a copy to practise if the sheet contains important records. Check the table has clear column headings and no unrelated data mixed into its range.

Read article
Excel: investigate a formula error without hiding it

An error can indicate a missing value, changed reference or unsupported calculation. Replacing every error with zero can hide a real problem. Keep a copy and select the affected cell.

Read article
Excel: keep column headings visible while scrolling

Freeze Panes keeps headings visible without changing the data. This is useful for long resource lists and planning sheets. Open the correct worksheet and identify the row containing your headings.

Read article
Excel: make a chart from classroom practice data

Use a small, non-sensitive table to practise charts. Choose a chart that explains the learning point without displaying unnecessary personal information. Create a clear table with headings and a few sample values.

Read article
Excel: print a worksheet without cutting off columns

Check the preview before printing a spreadsheet. Fitting everything onto one page can make the text too small. Select the worksheet you need and open File, Print.

Read article
Excel: show long notes using Wrap Text

Wrap Text displays a cell contents over several lines. It changes the presentation rather than the stored words. Select the cells containing long notes.

Read article