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.

How to create an automated list of worksheet names in Excel -- and add a table of contents.

Learn how to create a calendar in Microsoft Excel with data using a pre-designed template, Visual Basic code, or a manual method.

Often when you’re working with Excel you will use a calculation that is not available as a built-in Excel function. If you make this calculation repeatedly, you can save having to write the ...