pbPassingBI
/
excel/flashcards/excel-cards-viz

Visualisation & dashboards — flashcards

One card per lesson — 5 in this module. Recall the key points, then check. 5 cards. Click a card to flip, or use the arrow keys and space bar.

  1. Conditional formatting — what are the key points?

    Formula rules need a $ on the column to highlight whole rows · Rule order decides conflicts; Stop If True halts evaluation · Scope to the data range, not whole columns, to avoid bloat Read the lesson

  2. Charts that communicate — what are the key points?

    Sort bars by value; delete gridlines, borders and single-series legends · Secondary axis only when units genuinely differ · Sparklines show many trends compactly Read the lesson

  3. VBA and macros — what are the key points?

    Record to learn, then rewrite without Select · Option Explicit and Dim prevent silent typo bugs · Prefer Power Query for data import; Office Scripts for the web Read the lesson

  4. Preparing for an Excel interview or test — what are the key points?

    Lookups, pivots, SUMIFS, text parsing and cleanup dominate practical tests · Practise messy-data cleanup — it mirrors real work · Knowing when Excel is the wrong tool signals seniority Read the lesson

  5. Building a dashboard — what are the key points?

    Separate data, calculations and dashboard onto different sheets · Linked pictures place pivot output anywhere without layout constraints · Build pivots on Tables so new rows are picked up on refresh Read the lesson