Launch Excel and open a blank sheet. Name the table as shown in the image and enter the values corresponding to the names. Next, to define a name for a cell select it.

Learn about how to create a table in Excel so you can start presenting your data to others in a more professional manner.

Pivot tables generate great reports in Microsoft Excel, but adding a filter or two can make them even more flexible. Here's how.

One such way is to create a Data table in Excel. Using the PMT function to do the calculations. So what is a data table? Well its basically a cross referencing block of calculated cells that you can ...