How to Sum Positive Numbers in Excel – Easy Formula
For someone fairly comfortable with Excel, summing up a list of cells is as easy as pie. But when it comes to summing up cells based on a particular condition, …
Formulas
How to Count Negative Numbers in Excel – Easy Formula
Counting cells in a range of data is fairly easy, even if you are a beginner at Excel. But when it comes to counting only the cells that contain a …
How to Convert Date to Day of Week in Excel (3 Easy Ways)
When working with date-specific information, there might be instances where you need to find the day of the week corresponding to a date. For example, instead of the date, you …
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 …
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 (3 Easy Ways)
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 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 (3 Easy Methods)
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 …
How to 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 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 Generate Random Numbers in Excel (Without Duplicates)
Randomness is often just as necessary as order and symmetry, whether you are dealing with life or an Excel worksheet. Sometimes, you need it to ensure every value has an …