How to Create a Searchable Database in Excel. Although you're probably accustomed to relying on Microsoft Excel to help you budget, forecast, plan and report the numbers that underlie your ...

Tips This article applies to Microsoft Excel 2007, 2010, and Office 365. View the videos listed in the Resources section for more ideas on using Excel's database functions.

How Excel makes a relational database Relational databases—databases structured to recognize relations among the information stored in them—are essential for working with large amounts of ...

If you're looking for the perfect way to visualize the stats and data that you have compiled, Google Sheets and Microsoft Excel can help. We'll show you how.

Learn how to control Excel worksheets with spin buttons, scrollbars, option buttons, and checkboxes.

Learn how to create an automated data entry form in Excel with macros, interactive features, and secure design for efficient workflows.

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.

A shared Microsoft 365 Lists list is more valuable if you can use it to update source data in Microsoft Excel.

The ability to automate tasks in Excel for the web has been a long wait—but it’s finally here, and it was worth the wait.