How to Separate Address in Excel?
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). …
Steve Scott
What is the Excel Personal Workbook Location?
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, …
How to Calculate Confidence Interval in Excel
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 …
Convert Military Time to Standard Time in Excel (Formulas)
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 …
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 …
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 Switch Axis in Excel (Switch X and Y Axis)
Sometimes, when you create a chart in Excel, you may want to switch the axis in the chart (i.e., interchange the X and the Y-axis) It’s really easy, and in …
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 …