How to use the feature built into Excel that provides the ability to automatically capitalize days of the week if you enter them in a cell.

A number of different ways to round to the nearest quarter hour in Microsoft Excel.

How one of Microsoft Excel’s most obscure functions can make your life easier.

Learn how Excel can catch mistakes caused by Cap Lock being left on.

Excel provides a pair of nifty shortcut keys that can be used to copy cells down and to the right.

When you are designing the header and footer for a worksheet, Excel allows you to add various special elements to your header or footer.

How to sort Microsoft Excel data containing merged cells.

Have a lot of data in an Excel worksheet, and consider some of the rows to be duplicates? Here is how to determine whether a row is a duplicate.

When editing Excel workbooks, one of the most common actions to take is to clear or delete cells…although the difference between the two actions is clear as mud.

It is not unusual to acquire or develop Microsoft Excel data tables that have duplicate values in a column. If you want to see only the unique values…