They work best with data presented in a tabular format, with no empty rows or columns. Creating a Pivot Table in Excel To best understand pivot tables, you need to work with them yourself.