Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Selecting a cell is one of the most basic things users do in Excel. There are many different ways to select a cell in Excel – such as using the mouse or the keyboard (or a combination of both). In this article, I would show you how to select multiple cells in Excel. These cells …
Many people have a love-hate relationship with leading zeros in Excel. Sometimes you want it, and sometimes you don’t. While Excel has been programmed in such a way that it automatically removes any leading zeros from the numbers, there are some cases when you may have these. In this Excel tutorial, I will show you …
By default, Excel aligns numbers to the right and text strings to the left in a cell. And if you don’t like these numbers/texts that are too close to the cell border, you also have an option to indent the content of the cell. You can indent to the left or to the right in …
Excel has a lot of useful tools and features. There are some features that are widely used, but I wish were not so. The ability to merge cells is one such feature. While I don’t use this option myself, I still find myself unmerging cells (mostly in the workbooks shared by other people). In this …
Sometimes, you may need to know what’s the first day of the month based on a given date. When there is no dedicated function to get the first day of a given month, you can easily use a workaround to find it. In this Excel tutorial, I’ll show you some really simple formula that you …
Microsoft Excel stores dates and times as numbers, which allows the user to easily add and subtract days to a date in Excel. It also makes it really easy when you want to find out the total number of days between two dates, as you can simply subtract one from the other. In this tutorial, …
Excel stores date and time values as serial numbers in the back end. This means that while you may see a date such as “10 January 2020” or “01/10/2020” in a cell, in the back-end, Excel is storing that as a number. This is useful as it also allows users to easily add/subtract date and …
A lot of Excel users hide rows and columns when they have some data that they don’t need visible. It’s a way to only keep useful data visible, and at the same time not have to delete the data you don’t need to be visible. And, if you have lots of such hidden rows/columns, it …
When working with text data in Excel, you may have the need to remove the text before or after a specific character or text string. For example, if you have the name and designation data of people, you may want to remove the designation after the comma and only keep the name (or vice-versa where …
©trumpexcel.com – Free Online Excel Training
