Advanced MS Office Skills

What this lesson covers

Advanced MS Office Skills is a 10-part Class 8 Computer Science lesson. Each part makes one point and then hands over to the next, so it can be read in a sitting or picked up again at the part you stopped on. It defines the idea in plain words before using it, works through an example step by step, breaks the topic into its parts and compares them, shows where it is used outside the textbook, names the mistakes that cost marks in an exam, ends with a recap of what to remember.

How it begins

Anyone can type into a document. The difference at this level is doing it in a way that survives change. A document where headings are formatted by hand must be reformatted by hand. One using styles is restyled in one click. A spreadsheet with typed numbers must be recalculated by hand. One with formulas updates itself. The principle across all three programs: describe the structure, not just the appearance.

The 10 parts

1. Efficiency is the actual skill
2. Word processing properly
3. Spreadsheet techniques that matter
4. Building a spreadsheet that survives change
5. Presentations that work
6. Shortcuts and file discipline
7. Why these skills are valued
8. Where it usually goes wrong
9. What to remember
10. Watch one worked through