The question Office answers
A college office clerk has three jobs before Friday. She must type 200 fee notices, add up a month of fee collection, and show the totals to the principal. By hand this takes days, and one slip gives a wrong figure. Microsoft Office is a suite, a bundle of programs built for exactly these jobs. This course answers one question: how can I make the computer do the repetitive, error-prone parts of writing, calculating and presenting, so that my work looks professional and takes minutes?
You will learn four programs.
| Program | Used for | File type |
|---|---|---|
| Word | Letters, reports, resumes, assignments | .docx |
| Excel | Numbers, calculations, lists, charts | .xlsx |
| PowerPoint | Slide presentations | .pptx |
| Outlook | Email, calendar, contacts | No document file; it works with your email account |
Office 2003 and older versions saved files as .doc, .xls and .ppt. The extra “x” arrived with Office 2007. This course follows Microsoft 365 (a subscription that keeps receiving new features) and Office 2021 (bought once, with no new features after release). Nearly everything works in both; the lessons flag the exceptions.
Finding your way: the ribbon
Every Office program has a similar layout. At the top is the Quick Access Toolbar with Save, Undo and Redo. Below it is the ribbon, made of tabs such as Home, Insert and View. Each tab holds groups (the Home tab has Clipboard, Font, Paragraph and Styles), and each group holds commands, which are the buttons. The small arrow in the corner of a group, called the dialog box launcher, opens the full settings window for that group.
The File tab opens Backstage view, where you create, open, save, print and export files. Two ideas matter most:
- Save (Ctrl+S) stores your work under its current name. Press it often.
- Save As (F12) stores a copy under a new name, place or format. Choose PDF when a document must look the same on every device and should not be edited.
Typing and selecting
Word moves to the next line by itself when a line is full. Press Enter only at the end of a paragraph, never at the end of every line. To line things up, never press the space bar many times; use alignment or the Tab key.
The rule behind all formatting is: select first, then format. Drag the mouse across the text, or use these quick selections:
- Double-click a word to select it, and triple-click to select a paragraph.
- Press Ctrl+A to select the whole document.
Formatting text and paragraphs
On the Home tab, the Font group changes how characters look: font name, size in points (pt), bold, italic, underline, colour and highlight. Ctrl+B, Ctrl+I and Ctrl+U switch bold, italic and underline on and off. The Paragraph group changes whole paragraphs: alignment, line spacing, bullets, numbering and indents.
| Alignment | Shortcut | Best use |
|---|---|---|
| Left | Ctrl+L | Most body text |
| Centre | Ctrl+E | Titles and headings |
| Right | Ctrl+R | Dates and page numbers |
| Justify | Ctrl+J | Neat edges on both sides |
Line spacing is the gap between lines inside a paragraph (1.0, 1.15, 1.5, 2.0). Spacing before and after is the gap between paragraphs, so you never need blank lines made with Enter. Use Bullets for a list where order does not matter and Numbering where it does, such as steps.
Two habits save hours. Find and Replace (Ctrl+H) changes a word everywhere in the document at once. Format Painter, the brush on the Home tab, copies the look of selected text onto other text. Double-click it to paint several places, then press Esc.
Format a leave application
Priya types a leave application and wants it neat.
- She selects the subject line and presses Ctrl+B to make it bold.
- She presses Ctrl+A and sets one plain font, such as Times New Roman, at 12 pt.
- In the Paragraph group, she sets line spacing to 1.15 and spacing after to 6 pt.
- She selects the date and presses Ctrl+R to move it to the right margin.
The result has one clean font, even gaps and a right-aligned date.
Centring with the space bar
Pressing the space bar twenty times to centre a title breaks when the font or printer changes. Select the title and press Ctrl+E instead.
Key points
- Office is a suite: Word for documents (.docx), Excel for numbers (.xlsx), PowerPoint for slides (.pptx) and Outlook for email.
- Commands live on the ribbon in tabs, groups and buttons; the File tab handles saving, printing and PDF export.
- Select first, then format. Use alignment, spacing and bullets, not extra spaces or Enter presses.
- Ctrl+S saves, F12 is Save As, and Ctrl+H is Find and Replace.