Learn how to create and and forms to Excel spreadsheets to help make data entry easier. This guide makes it easy to create Excel forms for ...

In this guide, you’ll learn how to create a dynamic search box that filters data based on your input, using Excel’s built-in features and Developer tools.

It is particularly beneficial to use data-entry forms when your data range or table has many columns. A standard data-entry form in Excel looks similar to the screenshot below. (To follow along, ...

Not everyone is familiar with Excel. You can protect the data input process by using Excel's UserForm object to collect data. Susan Harkins explains how.

A check mark box in an Excel spreadsheet is handy for ticking off items, but it can go much further. Excel check boxes can trigger calculations and provide visual indicators.

Excel's Linked Picture tool lets you take a snapshot of some data and paste it as an image—handy if you're compiling a dashboard of the key metrics from across your workbook.

How to use easy search in Excel This simple control and function combine to return a corresponding value from a data set. The function updates as you add characters.

Learn how to demonstrate your marketing data using sexy combination charts in Excel, with tutorials for PC (2013 and Mac (2011).

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

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.