When working with data related to investments and project assessments, you may sometime have to calculate the NPV (Net Present Values) of projects/investments. In this tutorial, I will show you …
Often when working with text data such as names or address, you will get the data in uppercase, and you may need to convert it into lowercase or propercase. With …
IRR is a frequently visited topic when talking about investments and returns. Trying to calculate the IRR (which stands for the Internal Rate of Return), given a series of cash …
Word documents are for word processing while Excel files are for data processing. But what if you need to combine the two? What if you need to display a part …
When working with data in Excel, you will often format data (such as color the cells or make them bold or give a border), to make these stand out. And …
When analyzing data, we usually assume that the data values fall somewhere near the mean or median, or at least closeby. However, there might be some values that are way …
Extracting numbers from a list of cells with mixed text is a common data cleaning task. Unfortunately, there is no direct menu or function created in Excel to help us …
If you are working with data related to storage space or file-size, you will often need to convert between units. You might intend on using the data in calculations or …
Working with data often involves cleaning up. If your data is imported or copied from an external source, it may contain a number of unwanted characters like commas or asterisks …
Let’s face it, opening a worksheet to see decimals all over it can be quite off-putting. Some people find it intimidating, as decimals give the perception of complexity. As such, …
When you print a worksheet in Microsoft Excel, it gets printed in the portrait orientation by default. However, you might want to change the orientation of the printout to landscape …
If you are coding in VBScript, Excel and you need to extract the filename that a user uses when saving a file, the GetSaveAsFilename() method can be useful for you. …