Format your data as an Excel table (more on that later). Essential Microsoft Excel functions to streamline your everyday tasks Now that you are aware of the basics of pivot tables, letâ s create one.