How to create an Excel table 1. First, enter the field names in the columns across the top, and then enter some records/data in the rows under each column.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Here's how to use Excel as a calculator to perform basic arithmetic operations such as addition, subtraction, multiplication, and division.