How to Bold Text using VBA in Excel
The best way to draw a user’s attention to a cell or some text within a cell is to make it look different from the rest of the text. One …
Excel Tips
Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
What does Pound / Hash Symbol (####) Mean in Excel?
At some point, you might have come across a cell with a number of pound symbols or hash characters (####). If you’re a beginner and seeing this for the first …
How to Convert Days to Years in Excel (Formulas)
There might be a number of reasons for wanting to convert days to years in Excel. For example, you might have a count of days that have passed and you …
How to Find Percentile in Excel (PERCENTILE Function)
I am sure you have heard the word percentile when people talk about numbers and rankings. I remember it being one of the ways we used to get our ranking …
How to Make Excel File Read Only
If you have been working with Microsoft apps (such as Excel, PowerPoint, or Word), I am sure you have encountered files that are read-only. What a read-only file means is …
How to Find Slope in Excel (Formula)
The slope is commonly used in statistics, where it tells us how two variables are related in a dataset. While I remember using a pen and a paper and some …
How to Autofill Dates in Excel (Autofill Months/Years)
When you have to enter a sequence of dates in a column in Excel, you don’t need to do it manually. Excel has some amazing features using which you can …
How to Create Barcodes in Excel
Barcode allows you to show data in a visual format that can easily be read by machines. I am sure you have seen barcodes hundreds of times on products, including …
How to Select Rows with Specific Text in Excel
When you are working with large amounts of data in spreadsheets, you need all the tips and tricks you can get to quickly access your required data. Oftentimes you might …
How to Calculate NPV in Excel (Net Present Value)
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 …
How to Change Uppercase to Lowercase in Excel
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 …
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 …