Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Last week I wrote an article on how to create a Dynamic Pareto Chart in Excel. With the charting fever still riding high, today I will show you how to create a Gantt Chart in Excel. Gantt Chart is a simple yet powerful project management tool that can be used for creating a schedule or tracking the …
Pareto Chart is based on the Pareto principle (also known as the 80/20 rule), which is a well-known concept in project management. According to this principle, ~80% of the problems can be attributed to about ~20% of the issues (or ~80% of your results could be a direct outcome of ~20% of your efforts, and so …
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 …
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 …
©trumpexcel.com – Free Online Excel Training
