Working With Sheets

Move around a sheet without reaching for the mouse, write formulas that reference cells instead of typed numbers, and hand the file to somebody else without it falling apart.

Excel 15 lessons30 questions10-question final exam

What this course assumes and what it gives you

Assumes: None. Start here if you have opened Excel and stopped.

You will be able to: You can build and hand over a sheet that survives being sorted, filtered and printed.

The spreadsheet is in the page. You type your answers here and the engine works them out against real data, cell by cell, so an answer that gets there a different way is still right.

Syllabus

0 of 5 lessons done

1Moving around a worksheet and entering dataNavigate the grid with the keyboard, read the Name Box and status bar, and add a row of data without breaking the sheet.6 teaching steps · 6-question quizNot startedStart lesson →
2Building your first formulasWrite arithmetic formulas that reference cells rather than typed numbers, total a column, and read a result off the status bar before committing to a formula.6 teaching steps · 6-question quizNot startedStart lesson →
3Copying formulas and locking referencesCopy a formula down a column, predict what happens to its references, and use $ to hold one of them still.6 teaching steps · 6-question quizNot startedStart lesson →
4Making a sheet someone else can readFormat numbers and dates so they are unambiguous, structure headers so the sheet can be navigated, and avoid the formatting choices that break later work.6 teaching steps · 6-question quizNot startedStart lesson →
5Printing what you meant to printSet a print area, fit the sheet to the page sensibly, and repeat headings so page two is still readable.6 teaching steps · 6-question quizNot startedStart lesson →

Final exam