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

Learn how to create a drop-down list using Data Validation in Excel. Data Validation limits the type of data that can be entered into a cell.

Although Microsoft Excel is a powerful spreadsheet out of the box, macros make it even more useful. You can create and record macros within the app.

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