How To Fix

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.

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.

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 Excel sparklines, choose line column or win/loss types, copy sparklines across rows, group sparklines, use same vertical axis scale, customize colors and markers, handle blanks, clear sparklines, and understand Excel web limitations.

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.

Add PowerPoint animations to text, images, charts, and objects, control animation order and timing, fix all animations playing at once, stack effects with Add Animation, preview in Slide Show, understand Morph, and remove animations.

Add citations in Word, choose APA MLA Chicago styles, create sources, reuse citations, generate Bibliography References or Works Cited pages, update citations, switch citation styles, manage sources, edit sources, and complete placeholders.