Use Descriptive Sheet Names One way to make your Excel workbook more accessible is by changing the names of the worksheets. As you can see when you look towards the bottom of your workbook, Excel ...

Microsoft's spreadsheet program can do way more than you might realize. These are the hacks and tricks you need to know.

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

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.

Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.

How to Create an Excel Spreadsheet to Figure Out Sick Leave. Your company allots employees a specific amount of sick leave per year, quarter or month.

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

There are several reasons to use SUBTOTAL instead of SUM when inserting subtotals in your spreadsheet.