digest
Short Summary
Main recommendation: Leave Excel's default data alignment in place (text left, numbers right, TRUE/FALSE and errors centered) and use it as a visual cue to catch data-entry problems. The video explains that Excel's "Normal" cell style sets this default, and that when a cell's alignment has been changed, the cue stops working. Watching for unexpected alignment helps spot numbers stored as text, mistyped dates, and similar errors before they affect calculations.
Key Points
- Default alignment by data type: text aligns left, numbers and dates/times align right, and TRUE, FALSE, and error values are capitalized and centered; empty cells have no alignment to check.
- Alignment is part of the "Normal" style, which also sets General number formatting and bottom vertical alignment, so a changed cell alignment means someone altered that cell.
- A number aligned to the left (such as "175 cents" with two decimals typed in) signals Excel is treating it as text, so the sum function will ignore it.
- A date typed as 14/2/2017 stays left-aligned because there is no 14th month, which reveals the mistake; he also shows that 12/2/2017 is ambiguous (meant as the 12th month but read as day 12), though it still aligns right since it's a valid date.
- Sum (Alt + =) usually auto-highlights numbers to add, but skips numbers stored as text, so a sum that fails to auto-highlight them is a warning sign, and manually selecting them still omits the text-numbers from the total.
Details Worth Noting
- Concrete instructions:
- Check the Normal style: in the Styles group, right-click Normal, choose Modify, and review the number format (General), alignment (bottom), and other options, then click Cancel so you don't change it.
- Scan a spreadsheet for cells whose alignment doesn't match their content; if a number is left-aligned, backspace and re-enter it so it aligns right.
- For a mistyped date (such as 14/2/2017), backspace and re-enter the correct date until it aligns right.
- If a name or text value is right-aligned (e.g., "Tyrone"), check the Alignment settings and reset it to the default.
- Keep default alignment in data sets, since some IF functions and PivotTables can change alignment or produce unexpected text/number formatting.
- For sums, highlight the cells you want to add and press Enter to correct a formula that ignored text-stored numbers.
- The video uses Office 2016 and includes downloadable Excel and PDF notes linked below the video, including a list of error types.
- The lesson's homework is on the sheets after the lesson: blue sheets have yellow instructions at the top, and red sheets contain the answers, to be viewed only after completing the homework.
Bottom Line
Treat Excel's default alignment as a free error-detection signal: if something sits on the wrong side, the data type is likely wrong, so investigate before relying on the figures.
