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
If you’ve ever worked in an HR role, you know how challenging it can be to maintain a large volume of personal details for multiple employees, including their CNIC numbers, IBANs, Passport numbers, or even cellphone numbers. All of these numbers are often accompanied by dashes that may appear in the center, at the beginning, … Read more
Somewhere back in Junior High School, we all had a tough time finding square roots of numbers making those lengthy tables. However, finding square root in Excel is not that difficult. There are many ways how you can find the square root of a given number in Excel ranging from in-built Excel functions to smartly … Read more
Have you ever worked on a set of data with blank rows in between? It can be pretty annoying, right? Oftentimes, we do encounter this format of data whenever we export data from a system or a database. With the blank rows in between, it’s quite difficult to sift through the data as you have … Read more
Excel is great at number operations and data analytics. However, when it comes to formatting of data, particularly text, you’d find Excel silent about quite a few things. For example, the strikethrough function. Take a quick look around the Ribbon tab of your Excel workbook to see if something similar to a strikethrough button is … Read more