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.

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.

Let’s see how to get Stock Quote in Excel. Get real-time Stock Prices in Excel. You can retrieve stock quotes in Excel by using the MSN MoneyCentral web query – but things have changed a lot now.

Step 2: Make an Excel Bar Chart To start to visualize your data, you’ll first create an Excel stacked bar chart from the spreadsheet. Select the “Start date” column, so it’s highlighted.

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 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.