Connecting the four

Ce que vous saurez faire

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.

Étape 1 sur 9 · 1 point

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