Conditional formatting is one way to help you monitor metrics and Google just introduced it to its popular dashboard. In late October, Google introduced conditional formatting to its Google Data ...

Build stable, high-performance dashboards using REPT formulas and UNICHAR symbols instead of conditional formatting.

One of the most common requests I receive from users is how to identify duplicate and unique values in Microsoft Excel. The easiest way I know is to apply a conditional format. In a nutshell, a ...

As your business grows, so too will the documents and spreadsheets that you use to help keep things running. Eventually, the spreadsheets may get so big that it becomes almost impossible for you to ...

Microsoft Excel 2019 is a powerful management tool for many business owners. It combines the simplicity of a cell-based information system with formatting features that both highlight important data ...

In the duplicate world, definition means everything. That’s because a duplicate is subjective to the context of its related data. Duplicates can occur within a single column, across multiple columns ...

When you're working with a spreadsheet, duplicate data can sometimes make its way in and cause all sorts of problems. In this how-to, we demonstrate two methods of using Microsoft Excel for ...