Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
Excel Filter is one of the most used functionalities when you work with data. In this blog post, I will show you how to create a Dynamic Excel Filter Search Box, such that it filters the data based on what you type in the search box. Something as shown below: There is a dual functionality to …
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 …
This is the fifth and final article of the five-part series on Data Analysis in Excel. In this section, I will show you how to use Solver in Excel. Download Example File Other articles in this series: Watch Video – Using Solver in Excel Solver in Excel is an add-in that allows you to get an optimum solution …
This is the fourth article of the five-part series on Data Analysis in Excel. In this section, I will show you how to use Goal Seek in Excel. Download Example File Other articles in this series: Watch Video – Goal Seek in Excel Goal Seek in Excel, as the name suggests, helps you in achieving a value …
This is the third article of the five-part series on Data Analysis in Excel. In this section, I will show you how to use the Scenario Manager in Excel. Download File Other articles in this series: Watch Video – Scenario Manager in Excel Scenario Manager in Excel can be the tool of choice when you …
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 …
©trumpexcel.com – Free Online Excel Training
