Here you will find common Excel tips and tutorials that can help you speed up your work and get stuff done faster.
A lot of organizations prefer to use the 24-hour ‘military time’. These include the airline industry, public transport, and of course the armed forces. Besides organizations, there are a lot …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …
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 …