Excel Formula tips and tricks to make you a champion in Excel. A lot can be done when you know the right Formula hack.
Excel users often need to compare cells or columns to check if the same text is available in the cells/columns or not. A very common example of this is when you have names in two columns and you want to check if the names are exactly the same or what names are missing in one …
Excel allows you to sort your data set based on numeric values, text values, dates, as well as colors in the cell. However, there is no inbuilt functionality in Excel to sort the cells based on the length of the text in the cells. In one of my Excel training sessions, I was asked whether …
Working with dates is a common task for many Excel users. And sometimes, you can come across dates that are formatted as text (or look like dates but are not in the acceptable date formats, so Excel treat them as text strings). Since dates are stored as numbers in the backend in Excel, it allows …
Excel has 450+ functions that can do a range of awesome things. If you’ve used Excel even for a few days, I am sure you have heard of functions like VLOOKUP, SUMIF, COUNTIF, and so on. And what is more awesome is that one Excel function – a formula that consists of two, three, or …
When working with the names dataset in Excel, often there is a need to slice and dice the dataset and extract a part of it. One common task many Excel users have to do is to extract the last name from the full name. While it may seem like an easy task, it can get …
Excel can be quite useful when you’re working dates. It has some powerful built-in formulas that allow you to do calculations based on dates. One common scenario where you have to perform calculations with dates would be to find out how many years or months or dates have elapsed between two given dates. This could …
If you work with measurement data and there is a need to convert the data from one length measurement unit to another, you can use some inbuilt formulas in excel to do that. For example, you may have a need to convert data in centimeters/millimeters to inches or feet. In this short tutorial, I will …
If you have a list of items or names or numbers, you can use simple formulas in Excel to randomize this list. I often need to use this when I’m creating tutorials where I need a random set of numbers or items. It could also be useful if you’re creating a random team in your …
When working with dates in Excel, sometimes you may want to know what day the date is (whether it’s a Monday or a Tuesday, or any other weekday). This could especially be useful in project planning, where some days could be for a specific task (such as having a project meeting or sending the progress …
©trumpexcel.com – Free Online Excel Training
