5 quick and easy tips for building Excel knowledge

You may find yourself more reliant on technology to keep track of remote working plans - so get yourself up to speed with this key tool

Grainne Hallahan

News article image

Excel is not most people's idea of a fun piece of software. It's useful though, very useful, so overcoming whatever fear -or perhaps boredom - it may inspire in you is vital.

This enforced period of remote working many teachers may now be facing could be the perfect time to start building your knowledge of this tool that may serve you well both now and long into the future.


Quick read: Would Leonardo da Vinci have excelled in our school system?

Quick listen: Doug Lemov on routines for learning

Want to know more? Is teaching coding in schools pointless?


1. What's the date?

I was often using Excel to enter data from exams or tests and needing to insert the date.

[Ctrl] + ;

Ta-dah! Job done.

Another nice, easy shortcut for data entry is when you want to just repeat the same value as the cell above. For this, just enter:

[Ctrl] + D

No more fiddly copy and pasting and messing up the formulas.

2. Paragraphs inside cells 

You won't always just want numbers on your spreadsheet. Text is particularly important when you’re recording targets or feedback comments, or even just details about the child’s behaviour or punctuality.

In these cases, what you want to type is quite long and complex, and therefore requires paragraphs. However, if you hit the Enter key, you find yourself skipping to the next cell.

But it doesn’t have to be like this.

Instead, [Alt] + [Enter] will give you a line break inside the same cell, leaving your text easy to read and your spreadsheet comprehensible. Bingo.

3. Typing symbols

You do not, as I previously thought, have to print out and add the symbols in with a Biro afterwards. No, no. Here is your print-out-and-keep list to stick above the computer in the workroom (n.b., these symbols shorcuts will only work on Windows computers):

Degree symbol º: [Alt] + 0176

One-quarter 1/4: [Alt] + 0188

One-half 1/2: [Alt] + 0189

Three-quarters 3/4: [Alt] + 0190

excel

4. Adding a row between each line

You could get repetitive-strain injury from adding blank rows between each row of data by using the "insert row below" function. Or you could do a quick copy and paste, and then "filter by order" and add it in that way.

  1. Highlight the column where you’ve numbered each row of data.
  2. Copy and paste just the numbers below the data.
  3. Select all and filter by numbers ascending.

Voila, you now have a blank row between each data row, allowing you to add in comments or insert new data.

5. Resize the columns

Often, I end up putting too much text into a cell and then trying to merge cells to get it all to fit. This can make the spreadsheet a little unwieldy and tricky to use.

Instead, I now revise the columns by highlighting more cells to the side, and just double-clicking.

As if by magic, the cells resize and the text can be read. Hallelujah.

Register to continue reading for free

It only takes a moment and you'll get access to more news, plus courses, jobs and teaching resources tailored to you

Grainne Hallahan

Grainne Hallahan

Grainne Hallahan is Tes recruitment editor and senior content writer at Tes

Find me on Twitter @heymrshallahan

Latest stories

Geoff Barton

Omicron, nativities and the DfE: Another fine mess

Schools are being told what to do by those with no concept of the reality of running a school - and it's only making an already tough situation a lot harder, explains Geoff Barton
Geoff Barton 3 Dec 2021
New headteachers - here are 9 things you need to know

Headteacher wellbeing and sources of 'streth'

Former headteacher Chris McDermott set out to find out the true causes of leader stress and support – and in doing so coined a whole new term, as he explains here
Chris McDermott 2 Dec 2021
Transdisciplinary learning: how to embed it in your school

Why you need a transdisciplinary curriculum

At the Aspirations Academies, six hours a week are dedicated to applied transdisciplinary learning - but how does it work? And should you apply something similar at your school?
Steve Kenning 2 Dec 2021