How to Convert Serial Numbers to Date in Excel
When you bring in data from other sources, it is not uncommon to get the dates in the form of serial numbers, like 42088. Moreover, Excel inherently stores dates in …
Steve Scott
How to Remove a Specific Character from a String in Excel
A big part of processing data involves the cleaning of the data. Most data you bring in to Excel often comes from various sources. Many times they are converted from …
How to Convert Date to Month and Year in Excel
Whenever you enter a date in a cell, Excel automatically recognizes the format and converts the cell to a date cell. So, Excel knows which part of the date you …
How to Move a Chart to a New Sheet in Excel
Charts are a great way to get a visual representation of your data. Excel provides a host of options to create and customize charts. It usually displays your created chart …
How to Add Text to the Beginning or End of all Cells in Excel
There may be instances where you need to add the same text to all cells in a column. You might need to add a particular title before names in a …
How to Remove Text after a Specific Character in Excel?
When editing or cleaning data in your worksheet, one often needs to trim and remove certain parts of strings, either for formatting consistency or to make the dataset look neat …
Count How Many Times a Word Appears in Excel (Easy Formulas)
One common requirement when working with large datasets is counting how many times a particular word or value appears. You may need to know how many times the word appears …
How to Reverse a Text String in Excel (Using Formula & VBA)
Reversing a string may not have many real-world applications, especially when working with spreadsheets. That is why you will not find any built-in function for this in Excel. But there …
How to Remove Dotted Lines in Excel
The topic for this tutorial is slightly fuzzy because what one may see as a dotted line may actually be a dashed line or even a light-colored solid line. Whatever …
How to Convert Radians to Degrees in Excel (Easy Formula)
When working with mathematical data, there might be instances where you need to work on angles. Excel has a number of built-in trigonometric functions that let you easily calculate the …
How to Center the Worksheet Horizontally on the Page in Excel
When you start out using Microsoft Excel, you’ll notice that printing Excel sheets do not quite feel the same as printing an MS Word document. The idea of ‘What You …
How to Add Cell Borders in Excel?
When working with large amounts of data, it can sometimes be hard to read the data, if not formatted properly. Moreover, there are usually parts of the dataset that are …