Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
If you enter a number that has more than 11 digits in a cell in Excel, it will automatically be converted into the scientific notation (as shown below). While the number in the back end would still remain the same, Excel changes the way it shows you that number. Sometimes that’s what you want, and …
Most Excel users, including many advanced Excel users, have no idea what the R1C1 and A1 notation means in Excel. In almost all of the situations, you don’t need to know what this is, and the default settings in Excel would be enough for you. But since you are here reading this article, I’m assuming …
Cleaning text data is often the most time-consuming task for many Excel users. Unless you’re among the few lucky ones, you’ll most likely get your data in a format that would need some cleaning. One common use case of this would be when you get a dataset and you have to remove some characters from …
Data analysis in Excel often involves working with dates. A common thing many Excel users need to check when working with dates is whether a date is between two given dates. A simple use case of this could be when you need to check whether the date of submission of a report was within the …
One area that often troubles Microsoft Excel users is working with dates. This is mostly because dates can be formatted in many different ways in Excel. So while you may see two dates in Excel and think those are the same, there is a possibility that these might be different values in the back end …
Getting numbers to show up as fractions in Excel could be a challenge. In case you try and enter any fraction in a cell in Excel, there is a possibility that Excel may change it to a date or a text string. This happens because fractions are not one of the data types that Excel …
Excel is not only a wonderful tool for data entry and data analysis, but also great at making charts, flow charts, simple diagrams, etc. It’s quite simple in Excel to insert a line and then customize and position it. In fact, you’ll be surprised how many options you get when you need to draw a …
Copying and Pasting a cell or a range of cells is one of the most common tasks users do in Excel. A proper understanding of how to copy-paste multiple cells (that are adjacent or non-adjacent) would really help you be a lot more efficient while working with Microsoft Excel. In this tutorial, I will show …
Although Excel is a powerful data analysis tool, many users use it for basic arithmetic operations. One common requirement is to multiply an entire column by a number (a constant value). In this tutorial, I will show you two easy ways to multiple an entire column with a given number. So let’s get to it! …
©trumpexcel.com – Free Online Excel Training
