The database capabilities of Excel are very powerful. In fact, not only can Excel be used to create a simple searchable database, it also can be used to create a proper relational database.

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.

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

How to Create Macros Downloading Real Time Data to Excel. Many companies depend on up-to-date data to make informed decisions regarding their businesses. Millions of small businesses around the ...

Learn how to create a calendar in Microsoft Excel with data using a pre-designed template, Visual Basic code, or a manual method.

One of Excel’s greatest tricks is the dimensional or 3D reference. This feature, which allows you to create formulas that refer to the same cell or range on multiple worksheets, simplifies the ...

In Excel, you can create relationships between two tables based on the matching data within the table. Learn how to create relationships between tables in Excel.

How to use Microsoft 365 Lists to organize Excel data you must track or share Your email has been sent If you work in Teams or SharePoint, you’re probably familiar with the concept of lists ...

How to create an Excel drop down list from another tab Your email has been sent The data you want to use in an Excel drop down list usually won’t be in the same sheet as the drop down. The good ...

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.