Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
This is the second article of the five part series on Data Analysis in Excel. In this section, I will show you how to use Two Variable Data Table in Excel. Download Example File Other articles in this series: Watch Video – Two-variable Data Table in Excel Two-variable data table is best suited in situations when you want to see how …
This is the first article of the five-part series on Data Analysis in Excel. In this section, I will show you how to create and use a One Variable Data Table in Excel. Download Example File Other articles in the Data Analysis series: Watch Video – One-Variable Data Table in Excel One variable Data Table in …
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 …
©trumpexcel.com – Free Online Excel Training
