Connecting the four

Was du danach kannst

Combine query, Table, PivotTable and Flash Fill into one refreshable summary, and choose the right tool for a given job.

Each of the four is useful alone. Together they are a report that rebuilds itself. This lesson puts them in one workbook and then breaks it, so you can see which link failed.

Schritt 1 von 9 · 1 Punkt

Load your cleaned query to a sheet as a Table and name it tblClean.