Excel – Intermediate

One Step Further Let’s make finding the correct row a bit easier You will need to have a document with headings ie on the first row each column needs to have a title for that data that belongs underneath it (eg firstname OR telephone). Left-click on the A1 cell choose from the top-most toolbar ‘Data’ ‘Filter’ ‘Autofilter’ Each column heading …

Excel – Beginner

There’s plenty of things that you can use to make Excel do the hard work for you Beginner When you have your Excel spreadsheet open you can see the horizontal bar showing alphabets starting from A (columns), and the vertical bar showing numbers from 1 (rows). These work like map co-ordinates, A1 being the top left cell. – If you …