Excel possesses formidable database powers. Creating a relational database starts with a Master table that links to subordinates called (awkwardly) Slave, Child, or Detail tables.

In Excel, three primary tools are available for performing What-If Analysis: Scenarios, Goal Seek, and Data Table. To recap the last couple of months, here are brief definitions of Scenarios and Goal ...

Table Style Options in Excel. Microsoft Excel tables are a way to organize complex data into rows and columns, making your information easy to understand.

Why You Should Name Tables in Excel Although getting into the habit of naming tables in Excel can take some time if it's not something you usually do, here's why today's the day to start.

In this tutorial, I’ll show you how to export an Excel table to a SharePoint list. I’ll also share a lot of basic information about SharePoint lists along the way.

Microsoft Excel makes it possible for users to create 3D Maps from Tables. This tutorial will explain all you need to know.