Data manipulation is one of the most powerful abilities of Excel. Flash Fill is a tool in Excel that enables you to manipulate data in a cell according to your needs. In this tutorial, we will learn how to switch first and last names in Excel with the help of Flash Fill. Switch First and … Read more
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
Do you have columns of quantitative data in your Excel sheet that only consist of a list of figures? How can you visualize and analyze the relationship between this quantitative data at a glance? Through a scatter plot. Scatter plots are the best when it comes to comparison between two sets of quantitative data. 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