Office & Email

Change Word orientation for a whole document or one page, use section breaks before and after landscape pages, manage headers and footers with Link to Previous, keep page numbering continuous, and reveal section breaks.

Use Outlook color categories, rename and recolor category labels, apply categories to messages, create rules that auto-assign categories, search by category, sync categories across accounts, set Quick Click, and understand categories versus flags.

Change Word line spacing to single, 1.15, 1.5, double, or custom exact and multiple values, set paragraph before and after spacing, set defaults, meet MLA or APA spacing, fix pasted-text overrides, and use Show Hide paragraph marks.

Calculate percentage change in Excel and Google Sheets, format results as percentages, handle zero and negative starting values, add conditional formatting, build period-over-period formulas, distinguish percent change from percentage points, and preserve precision.

Autofit Excel columns and rows by double-clicking borders or using the ribbon, resize selections or whole sheets, fix wrap text and merged-cell issues, set exact widths, fix ##### cells, understand print scaling, and avoid scientific notation surprises.

Calculate Excel running totals with expanding SUM ranges, absolute references, Excel Tables and structured references, category-reset totals with SUMIFS, visible-row totals with SUBTOTAL, fixed references, and sorting precautions.

Add PowerPoint slide transitions, apply them to one slide or all slides, adjust duration, fix disabled slideshow effects, use transition sounds and automatic advance, understand Morph, and preview a whole deck.

Archive emails in Outlook manually or with AutoArchive, understand Archive versus Delete, find archived messages, use Online Archive mailboxes, move archived mail back to Inbox, and undo accidental archive actions.

Create Outlook tasks, turn emails into tasks, assign tasks in classic Outlook, track status reports, use recurring tasks, flag emails for follow-up, mark tasks complete, and fix missing To-Do Bar tasks.

Add and subtract dates in Excel with simple day formulas, EDATE for months and years, DATE formulas, WORKDAY, DATEDIF, days-between calculations, date formatting, ##### width errors, and text-date problems.