Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Do you merge cells in Excel? If yes, you need to know a few drawbacks of merging cells. To begin with, if you try and sort cells that have been merged, it will refuse to do so and show you an error that says – To do this, all the merged cells need to be …
You have been working hard for months and finally, it’s time for that long awaited vacation. The build-up to vacation is often as exciting as the vacation itself. But a lot of time we get bogged down by the preparations and data management. Even for a short vacation or business trip, there is a lot …
Leading and trailing spaces in Excel often leads to a lot of frustration. I can’t think of a situation where you may need these extra spaces, but it often finds its way into the excel spreadsheets. There are many ways you can end up with these extra spaces – for example, as a part of …
Inserting rows in Excel is one of the most basic stuff that we do almost everyday. And there are many ways to do this. Now there could be various situations where you need to insert rows in Excel. For example, you may want to insert a single row, or multiple rows that are all together, …
Spell Check in Excel is often ignored given that Excel users often work with numbers as compared with text. But it is still one of the important checks one should have in place. As compared to MS Word or PowerPoint, where you can visually see a red underline below the word that has been misspelled, …
You may need to convert formulas to Values in Excel if you work with a lot of dynamic or volatile formulas. For example, if you use the Excel TODAY function to insert the current date in a cell, and you leave it as a formula, it will update itself if you open the workbook the next …
Want to insert the degree symbol in Excel? If you don’t know how to do this already, you may scratch your head and look for options. Unfortunately, it’s not as straightforward as you want it to be. There is no key on the keyboard to do this, or any direct option to do this using …
In this tutorial, you will learn how to count unique values in Excel using formulas (COUNTIF and SUMPRODUCT functions). How to Count Unique Values in Excel Let’s say we have a data set as shown below: For the purpose of this tutorial, I will name the range A2:A10 as NAMES. Going forward we will use …
There are various ways you can merge cells in Excel. One of the most used ways is using the Merge & Center option in the Home tab. The issue with using Merge & Center is that it can merge the cells, but not the text within these cells (i.e., you lose some data when you …
©trumpexcel.com – Free Online Excel Training
