Check out a wide range of Excel topics, from basic functions and formulas to more advanced topics like VBA and macros.
Have you ever imported data to Excel from an external source with many unwanted hyperlinks that came along? Also, you might have come across multiple undesired hyperlinks automatically generated by Excel for emails and URLs inserted into a workbook. Unwanted hyperlinks can cause undue trouble. Every time you select a cell containing a hyperlink, excel … 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
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
Before anything, what is a square root symbol? Let me quickly take you back to high school mathematics. Here’s what the square root symbol looks like. We often need this symbol in your spreadsheets for a variety of tasks. Some of the time to compose a formula, write down an expression, and so much more. … Read more