Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
Create Pivot Table Views by Month, Quarter, Year for Excel Reports
Create Charts in Excel 2013 via the Quick Analysis Tool
Excel Dashboards and Reports: Rearrange Your Pivot Table

Excel 2013: Creating a Data List

Step 1 of 5
Next Slideshow
Next Slideshow

Click the blank cell where you want to start the new data list and then enter the column headings (technically known as field names in database parlance).

For this exercise, use First Name, Last Name, Street, City, State, and Zip Code as the column headings.

After creating the fields of the data list by entering their headings, you’re ready to enter the first row of data.

  • Add a Comment
  • Print
  • Share


Promoted Stories From Around The Web

blog comments powered by Disqus
Hide or Show Pivot Table Items without Data On Your Reports
Suppress Subtotals in Your Excel Pivot Table Reports
Excel Dashboards and Reports: Change Summary Calculations
Create a Pivot Table Month-over-Month Variance View for Your Excel Report
Excel Dashboards and Reports: The Pivot Table