Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Excel's data validation feature is more versatile than you might think. Learn how to use literal values, input values, list values, and even formulas to restrict input date values using data ...

Excel for the web supports custom formats and data validation. How to determine requirements in Excel Phone numbers have 10 numeric digits and generally use the (xxx) xxx-xxxx format.

Select the Data tab and click Data Validation in the Data Tools section of the ribbon. In the Settings tab, click the dropdown under Allow and select Custom in the menu.

Combine the VSTACK function to add custom options like “All” or “None” at the top of the list. Configure the list as a dropdown menu using Excel’s Data Validation feature, making sure it ...