In Microsoft Excel, you can create relationships between two tables based on the matching data within the table, even when the tables are from different sources. In older versions of Excel, people ...

Microsoft now provides five different methods for creating tables: the Graphic Grid, Insert Table, Draw Table, insert a new or existing Excel Spreadsheet table, and Quick Tables, plus an option ...

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

A pivot table is a useful tool in data analysis that can give you an overview of your data. We'll show you how to create one in Excel and Google Sheets.

Microsoft recently made some significant enhancements to its Visio add-in for Excel, enabling users to create Visio diagrams from within Excel. Here's how it works.

Excel tables have many benefits that regular spreadsheets lack. The biggest is the option to use data from multiple tables to create queries and reports.

In Microsoft Excel 2010, you can create large tables in which to store your data and then use it in formulas and store the results in the same table.

When you have a massive Excel workbook overflowing with data, trying to make sense of it can feel like a tough task at times.

Warnings When you use Excel to create complex spreadsheets like pivot tables, you must type all your labels on one row in order to use the data-management functions.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.