Steve Scott 
Data that has been imported to Excel from external sources often need to be formatted properly, both for aesthetic as well as functional purposes. If you’ve imported data that contains …
Calculating the number of hours between two given times might be required for a number of situations. You might need to calculate the number of hours needed to complete a …
If you’re working with computers or machines, you might need to convert a set of decimal numbers into their binary equivalents. In this tutorial we will go over how you …
When you work with addresses, it can be convenient sometimes to have different parts of the address split out into Street address, city, state, and zip code (or postal code). …
The Excel Personal Macro Workbook is the workbook that contains all your created macros in one place. This workbook usually opens whenever you start Excel, but since it is hidden, …
If you want to find out how to calculate a confidence interval in Excel, you’re in the right place! Here, you can see how a confidence interval is calculated based …
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 …