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.

If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE() function.

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.