To create the attendance sheet for the next month, copy the entire data to a new page in Excel and change the dates. The respective days’ names will change automatically. Now, you have to enter ...

Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database.

The beta version of Microsoft Excel supports a new checkbox feature that makes tracking data a breeze. A short Instagram video on the feature transformed how I track attendance for my sports team.

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.