Excel Formula tips and tricks to make you a champion in Excel. A lot can be done when you know the right Formula hack.
When you work with numbers in Excel, you often need to conditional add the data. One common example of this is when you have to sum the positive numbers in Excel (or only sum the negative numbers). And this can easily be done using the in-built formulas in Excel. In this tutorial, I will show …
A comma is commonly used when working with both text and numbers in Excel. With text, a comma can be used as a separator (such as a separator between the first and last name or address) or as a part of regular grammar. And with numbers, it often used to make the numbers more readable …
If you work with formulas in Excel, sooner or later, you will encounter the problem where Excel formulas don’t calculate and give the result (or give the wrong result). It would have been great had there been only a few possible reasons for malfunctioning formulas. Unfortunately, there are too many things that can go wrong …
Excel has some amazing text functions that can help you when working with the text data. In some cases, you may need to calculate the total number of characters in a cell/range or the number of times a specific character occurs in a cell. While there is the LEN function that can count the number …
Apart from using Excel with numeric data, a lot of people also use it with text data. It could as simple as keeping a record of names to something more complex. When working with text data, a common task is to make the data consistent by capitalizing the first letter in each cell (or to …
If you have worked with formulas in Excel for some time, I am sure you have already met the #REF! Error (reference error). Since this is quite common, I thought of writing a tutorial just to tackle the #REF! error. In this Excel tutorial, I will cover what is the #REF! error, what causes it, …
When you’re working with datasets that have dates, you would often find yourself trying to do calculations based on the dates. For example, if you have the sales data for a month, you may want to know the total sales that have happened between two given dates or the total sales made on weekends vs …
If you manage multiple projects, you would have a need to know how many months have passed between two dates. Or, if you’re in the planning phase, you may need to know the same for the start and end date of a project. There are multiple ways to calculate the number of months between two …
If you work with names datasets, sorting it is one of the common tasks you would have to do often. It’s quite easy to sort data alphabetically based on the full name, where Excel uses the first character of the name to sort. But what if you want to sort data by the last name …
©trumpexcel.com – Free Online Excel Training
