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.

To create a calendar in Excel, you can use a pre-designed template from Microsoft. It provides a variety of calendar templates that you can browse, import, and customize. This method is easy and ...

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

In our example, Excel offers to create 10 different pivot tables that take a look at a number of different angles on our sales data. Note that how you label your columns matters; ...

How to create data bars in Excel. 1. Select the cells you want to apply the data bars to. You can select a single cell, a range of cells, a table, or the entire sheet. 2.

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.

How to create a Quiz in Excel. Here, we will create all multiple choice questions in sheet 1 and make an answer sheet in sheet 2. To automate the quiz, we will write formulae in sheet 2.