Excel Formula tips and tricks to make you a champion in Excel. A lot can be done when you know the right Formula hack.
WUHOOOO.. we are past the 2000 subscribers mark. You can imagine me doing the Happy Dance right now 🙂 This is a huge milestone for me and I am completely overwhelmed by the love and support I have got from my readers. I started this journey ~2 years ago and it has been a heck …
Excel built-in data sorting is amazing, but it isn’t dynamic. If you sort data and then add data to it, you would need to sort it again. Sort Data in Alphabetical Order In this post, I will show you various ways to sort data in alphabetical order using formulas. This means you can add data, …
I get this query all the time. People have huge data sets and someone in their team has highlighted some records by formatting it in bold font. Now, you are the one who gets this data, and you have to filter all these records that have a bold formatting. For example, suppose you have the …
In Excel, there are two ways to combine the contents of multiple cells: If you’re using Excel with Office 365 subscription, I suggest you click here to skip to the part where the TEXTJOIN function is covered. If you’re not using Office 365, keep reading. In its basic form, CONCATENATE function can join 2 or …
I was going through the questions on the Microsoft Excel Community, and one of the questions was on generating random numbers in Excel between 1 to 10, where none of the numbers repeat (i.e., there are no duplicates). My first instinct was to use the RANDBETWEEN function. I did a quick check with some random data …
When it comes to the Excel world, it’s divided into two factions – the VLOOKUP brigade and the INDEX/MATCH regiment. If you’re wondering which one scores higher in the VLOOKUP vs INDEX/MATCH battle, this article will try and answer it. But before I do that, let me make a few things clear – this article …
A colleague asked me if she could quickly extract usernames from Email Ids. She had more than 1000 records and less than 2 minutes to do it. In this tutorial, I will show you 2 methods to do this. And none of it would take more than a minute. Method 1 – Using Text to …
Yes, it’s true! You can send emails from Excel by using the HYPERLINKÂ function. In this blog post, I will show you various ways to use the HYPERLINK function to send emails from Excel. There is also a bonus Email Generator Excel Template available for download at the end of this post. Let me first explain …
Excel functions can be extremely powerful if you get a hang of combining different formulas. Things that might have seemed impossible would suddenly start looking like a child’s play. One such example is to find the closest match of a lookup value in a dataset in Excel. There are a couple of useful lookup functions …
©trumpexcel.com – Free Online Excel Training
