Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
If you are addicted to using the Excel Quick Access toolbar (QAT), this tip is for you. As you add many icons to the Excel QAT, there is also a way to group related icons together. Here is a snapshot of my Quick Access Toolbar: These vertical line separators can be used to group similar icons together. …
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 …
Thermometer chart in Excel could be a good way to represent data when you have the actual value and the target value. A few scenarios when where it can be used is when analyzing sales performance of regions or sales rep, or employee satisfaction ratings vs the target value. In this tutorial, I will show you the …
This is one awesome Excel Tab Numbering tip and the credit goes to Scott of Excel Zoom. He has some amazing articles on his website, and I am going to copy this tip shamelessly here [with his permission of course] If you have a workbook where the tab’s names are numbers (for example 1, 2, …
In this tutorial, I cover how to do a multi-level sorting in Excel. You can watch the video below, or you can read the tutorial below it. When working with data in Excel, sorting the data is one of the common things you might have to do. In most of the cases, you need 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 …
This is the 100th blog post from Trump Excel. I have loved every bit of this journey, and I hope to continue to contribute and share all that I learn about Excel Spreadsheets. If you wonder what was my first post, here it is – Trump Excel’s First Post. Now coming back to cool Excel stuff, in …
Excel is an amazing tool with fascinating capabilities to analyze data (be it using functions, charts or dashboards). The ease with which data can be entered and stored in Excel makes it a compelling choice. In this blog post, I have listed 10 useful Excel Data Entry tips that will make you more efficient and save a lot of …
©trumpexcel.com – Free Online Excel Training
