Connecting the four

Lo que podrás hacer

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.

Paso 1 de 9 · 1 punto

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