Microsoft Excel and Google Sheets functionalities to improve data quality and integrity

In the previous sections, we covered how to create sample data quality scorecards in both Microsoft Excel and Google Sheets. In this section, we will discuss the built-in capabilities these tools have to enhance the quality and integrity of data. We will begin our discussion with version control, which is a way to monitor changes made to files. Next, we will talk about collaboration tools to enable multiple users to make changes to the same file and give read-write permissions. After that, we will cover the data validation functionality in Google Sheets, as we discussed this for Microsoft Excel in the previous chapter. Lastly, we will touch on conditional formatting, which is a very useful tool to help in reviewing movements and trends.

Version control

Users can make changes to a file and keep track of changes over time in both Microsoft Excel and Google Sheets. This gives a history of file...