Excel Formula tips and tricks to make you a champion in Excel. A lot can be done when you know the right Formula hack.
It’s amazing how you can find multiple ways to do the same thing in Excel. After all, there are so many awesome functionalities and functions. A really simple and often needed task is to calculate the square root in Excel. And as I said, there are multiple ways you can do that in Excel (formulas, …
By default, date and time are saved as numbers/decimals in Excel. But you often see it in different formats because of the way the cells have been formatted. For example, in the below example, the value in column A and B is the same, but these are displayed differently because of the format. And one …
Excel allows you to display data in many different formats. And there are way too many to choose from when it comes to dates and time data in Excel. And since there are so many formats, there are also ways to edit and modify these. One common thing many people need to do often in …
Excel is an amazing tool when it comes to slicing and dicing text data. There are so many useful formulas as well as functionalities you can use to work with text data in Excel. One of the very common questions I get about manipulating text data is – “How to separate first and last names …
Excel has a lot of functions – about 450+ of them. And many of these are simply awesome. The amount of work you can get done with a few formulas still surprises me (even after having used Excel for 10+ years). And among all these amazing functions, the INDEX MATCH functions combo stands out. I …
In this tutorial, you’ll learn how to find the last occurrence of an item in a list using Excel formulas. Recently, I was working on setting the agenda for a meeting. I had a list in Excel where I had a list of people and the dates on which they acted as the ‘Meeting Chair’. …
The last few weeks have been really hectic for me at work. Weekdays are crazy and the weekends are never enough. Early this week, I was going through our annual holiday calendar to check for the next holiday, and plan a vacation if possible. And that gave me the idea for this Excel holiday calendar …
Rounding a number to the nearest integer or the nearest 0.5 or 5 or 10 multiple is a common task for many people. For example, if you’re a project manager involved in effort estimate, you can’t have 12.7 full-time resources working on a project. You need to round-up this number to 13 (the nearest integer). …
On my first day in my job in a small consulting firm, I was staffed on a short project for three days. The work was simple. There were many folders on the network drive and each folder had hundreds of files in it. I had to follow these three steps: Sounds simple right? It was – Simple …
©trumpexcel.com – Free Online Excel Training
