Here are four ways to express dates using data validation: literal values, input values, a list, and formulas. I’m using Excel 2016 (desktop) on a Windows 10 64-bit system.

Data Validation in Microsoft Excel allows users to control the type of data entered into the worksheet. It picks from a list of rules to limit the type of data that can be entered into a cell.

When you update this spreadsheet with new or different data, you won’t have to re-create the validation rule, but you will need to click Circle Invalid Data again. This tool would be useful to bring ...

INDEX with XMATCH returns an item from a range or array according to the first or last match it finds. Like XLOOKUP, it works with vertical and horizontal datasets, can search in any direction, and ...

Base a Data Validation dropdown on the Region values. Now, let’s use UNIQUE () to create a unique list of region values and then base a data validation dropdown on that list.

By combining Excel’s GROUPBY function with dynamic formulas, data validation lists, and conditional formatting, you can create an interactive data summary with robust drill-down capabilities.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

2. Track Your Health Excel can help you track calories, exercise and health goals. Once you’ve entered your chosen data, you can manipulate it using formulas and functions.