The summary.
USE STYLES, NOT MANUAL FORMATTING
Formatting by hand produces documents that are inconsistent and painful to change.
Use page breaks rather than pressing return repeatedly — that layout collapses the moment anything above changes.
THE THREE SPREADSHEET SKILLS THAT COVER MOST BUSINESS WORK
Conditional totals, lookups, and pivot summaries.
Never sort one column without the others. It destroys the relationship between columns, irreversibly.
Always check a total against a figure you already know.
WHAT DESTROYS DATA ON IMPORT
Leading zeros stripped from references, and long numbers turned into scientific notation.
Import rather than open, and specify the type of each column.
SLIDES SUPPORT WHAT YOU SAY; THEY DO NOT CONTAIN IT
Slides full of text get read instead of listened to, and read faster than you speak.
Put everything you intend to say in the notes.
RESIZE PHOTOGRAPHS BEFORE UPLOADING
Straight from a phone they are far larger than any screen needs, and make pages slow and costly to load.
COLLABORATE ON ONE SHARED FILE, NEVER ON COPIES
And check tracked changes, comments and properties before anything leaves the building.
