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 … 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 … 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 … 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 … 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 … Read more
If you have worked on Excel files extracted from a database or a system, you probably have encountered cells with leading apostrophes. If you’re like me, you too might have wondered why in the world … Read more
A cumulative percentage is a statistical tool commonly used in analyzing scientific research, finance, and sales data. But what exactly is it, and what is its purpose? Cumulative Percentage is defined as a way of … Read more
Whenever I work on a lengthy report that I need to forward to someone for review, I usually look for ways to highlight sections in the report that require attention. I used to add cell … Read more
When writing a report in Excel, most of us have this particular list that we regularly add in a specific order (e.g., a list of departments, regions, or stores). Typing them once is fine. But … Read more
Copying column widths is easy to do in Excel. We only need to: And that’s it! We are good to go. Easy-peasy, right? Excel, unfortunately, doesn’t have a similar feature for copying row heights. But … Read more