And that’s it. It took all of 20 seconds to create and format a table in Excel. How to use a Total row for quick calculations. Next, you’ll add calculations to your table.

Whichever method you use to create the table, Excel will open a new worksheet with the table in it. If you like, you can copy it into the original data sheet as I did in the screenshot.