Copying filtered data onto a new sheet is a great way to segregate related data rows. It allows us to have the extracted rows available anytime without re-applying the same filters. We have to be careful, though — the hidden rows within the dataset might get included in the cells copied if we miss the … Read more
When working with exported data, there will be times when we will have only the month and year included in the dataset (the day is nonexistent). It was okay until you realized that, for very particular reasons, you must turn these two bits of information into an actual date. In this tutorial, I will teach … Read more
Data sorting (or the process of arranging data based on a field or a set of fields) allows us to analyze data more effectively. If you want to temporarily sort your data in a particular order but want to be able to revert to the original data arrangement anytime, you’re in the right place. In … Read more
Data exported from a system are usually in a fixed report format. Sometimes though, it even includes unnecessary rows in between the data. In my example below, notice that there’s a total row added between each record. These rows may be helpful in certain instances. But if you intend to create charts from these data … Read more
Adding alternate row colors in your data is a great way to enhance its readability. It makes it easier for your intended audience to find a record and see its related information. Plus, it’s so nice to look at! When you look at the image below, I’m pretty sure your eyes are immediately drawn to … Read more