Stop 11 · BA Tools & PlatformsTopics · 3/8

Microsoft Office Suite Mastery

In short

Every BA uses Word, Excel and PowerPoint. The difference between 'uses' and 'masters' is hours every week. Keyboard shortcuts, styles and templates are boring to learn and wonderful to have.

Word, Excel and PowerPoint remain the daily-use tools for most BA documentation, analysis, and presentations — genuine fluency (not just basic familiarity) saves significant time across a career.

The purple blob types quickly on a vintage typewriter at a small wooden desk under a big umbrella.

Think of it like this

The court typist

Outside the district court, a typist knocks out a full affidavit in minutes while others hunt for keys. He doesn't think about where the keys are anymore. That's what mastery of your daily tools feels like: your hands keep up with your head.

Watch it happen

Five Excel shortcuts that save real time (Windows)

Ctrl+T

Ctrl+Shift+L

Alt+=

Ctrl+;

1/5Small shortcuts, used dozens of times a day, add up fast. Mac versions differ slightly.

The big ideas

What you need to know

Word: use styles

Heading styles give you an automatic table of contents and consistent formatting. Never format headings by hand.

Excel: tables and pivots

Format data as tables, then summarise with pivot tables. Faster and less error-prone than manual formulas everywhere.

PowerPoint: slide master

Set fonts, colours and layouts once in the slide master, so every slide matches without fiddling.

Templates

Save your BRD, status report and deck layouts as templates. Start every new document 80% done.

Save yourself the pain

Common mistakes

Oops

Bolding and resizing headings manually in a 40-page Word document.

Do this instead

Apply Heading 1, 2, 3 styles, then insert an automatic table of contents.

Oops

Copy-pasting charts into PowerPoint as images that go stale.

Do this instead

Paste linked charts or rebuild them from the latest data before each review.

Your mission

Shortcut week

~30 min

Quick check

Your 30-page Word document needs a table of contents that updates when headings change. What makes this easy?

Go deeper

1Build a well-formatted requirements document template in Word with consistent styles.
2Practice a few advanced Excel functions (Phase 5) you don't already use fluently.
3Build a clean, well-structured stakeholder presentation in PowerPoint.