Connecting the four

What you will be able to do

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.

Step 1 of 9 · 1 point

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