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.

Charted zero values can have unintended results you can easily miss. Here are a few techniques you can use to hide and manage zeros in your workbook to keep that from happening. A drop to zero in a ...