Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Percentile is a statistics metric is that is often used when working with data. It gives you an idea of where a value lies in the dataset (i.e., its position/rank in the dataset). In practical life, I have seen the percentile value being used in competitive exams, where on the given score, you get the …
When working with data in Excel, calculating the percentage change is a common task. Whether you working with professional sales data, resource management, project management, or personal data, knowing how to calculate percentage change would help you make better decisions and do better data analysis in Excel. It’s really easy, thanks to amazing MS Excel …
The slope of the regression line is a measure of the steepness of the line. It’s a numeric value that tells us how two variables are correlated. It tells us how much the dependent variable will change in case there is a change in the independent variable. There are three ways to find the slope …
If you have worked with Excel formulas for a while, I am sure you must have encountered the #NAME error. Just like any other error in Excel, the #NAME error also occurs in specific situations (which I will cover in this tutorial), and there are some simple ways to find and fix the #NAME error. …
When working with data in Excel, you would often have a need to copy some tables from Excel into an MS Word document. While there is no built-in option in Excel to convert an entire Excel file to Word, you can easily copy and paste the data from an Excel document to Word. In this …
Excel has some useful chart types that can be used to plot data and show analysis. A common scenario is where you want to plot X and Y values in a chart in Excel and show how the two values are related. This can be done by using a Scatter chart in Excel. For example, …
While Excel is an amazing tool for data analysis, many people use it for basic arithmetic calculations such as addition, subtraction, multiplication, and division. If you’re new to Excel and wondering how to subtract in Excel, you’re at the right place. In this tutorial, I will show you how to subtract in Excel (subtract cells, …
Excel is an amazing tool to store and analyze data. And many of the times, you will have to deal with text data types such as names, regions, departments, or product names. In such cases, it’s good to know how to manipulate text data and get the desired result. One of the most common tasks …
Watch Video – Fill Down in Excel A lot of times, you may encounter a data set where only one cell is filled with data and the cells below it are blank till the next value. Something as shown below: While this format works for some people, the problem with this sort of data is …
©trumpexcel.com – Free Online Excel Training
