How to Convert True-False to Check Boxes in Excel. Microsoft Excel's form controls can turn the Boolean options of a true-false choice into a clickable data-entry option.

If you need to average a list of values in Microsoft Excel that contain duplicates without including the duplicates, don't fret over a complex expression when you can easily remove those duplicates.

If you want duplicate values to stand out in an Excel spreadsheet, you can choose between two conditional formatting rules.

How to Highlight Values When They Change in Microsoft Excel. When multiple people work on the same Excel spreadsheet, it can be difficult to keep track of changes.