Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
I am a huge fan of the Matrix movie series. It an amazing piece of work of its time and one of my favorites science fiction movie series. If you have seen Matrix, there is no way you wouldn’t remember the falling code sequence. I thought of creating this in Excel, but someone beat me …
Excel is more than a data entry tool. But if you only talk about data entry in Excel, it’s a damn good one. Using the data validation, you can enable data entry in cell(s) based on a predefined condition. Conditional Data Entry in Excel Using Data Validation Here are a few examples of conditional data …
You start your day. Plan some tasks. Write it down somewhere and start working on it. When it’s way past your work time, you think about that to-do list (stare at it if you have it written) and curse the world for not having enough time in the day. Sounds familiar? If you are nodding …
©trumpexcel.com – Free Online Excel Training
