How to Calculate IRR with Excel
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 …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
How to Insert an Excel file into MS Word?
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 …
How to Copy Formatting In Excel?
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 …
How to Find Outliers in Excel?
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 …
How to Extract Number from Text in Excel (Beginning, End, or Middle)
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 …
Convert Bytes to MB or GB in Excel
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 …
How to Replace Asterisks in Excel
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 …
How to Remove Decimals in Excel?
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, …
How to Change Page Orientation in Excel (for Printing)
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 …
Using Application.GetSaveAsFilename in VBA in Excel (Examples)
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. …
Using Conditional Formatting with OR Criteria in Excel
Conditional Formatting in Excel provides a great way to highlight certain cells that may be more important than others. When combined with the OR criterion, you get added flexibility to …
Using IF Function with Dates in Excel (Easy Examples)
The IF function is one of the most useful Excel functions. It is used to test a condition and return one value if the condition is TRUE and another if …