Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Excel has some really useful features that can help you be a lot more efficient in your day-to-day work. One of the common tasks many people have to do is to compare data in the same sheet. This is especially useful for people who work with large data that requires a lot of back and …
There are some simple things that are not possible for you to do with in-built functions and functionalities in Excel, but can easily be done using VBA. Counting the total number of sheets in the active workbook or any other workbook on your system is an example of such a task. In this tutorial, I’ll …
If you work with measurement data and there is a need to convert the data from one length measurement unit to another, you can use some inbuilt formulas in excel to do that. For example, you may have a need to convert data in centimeters/millimeters to inches or feet. In this short tutorial, I will …
If you have a list of items or names or numbers, you can use simple formulas in Excel to randomize this list. I often need to use this when I’m creating tutorials where I need a random set of numbers or items. It could also be useful if you’re creating a random team in your …
By default, when you insert a chart in Excel, it’s created in the same worksheet where you have the source dataset. But in many cases, you may want to move the chart from the sheet where it’s created to another worksheet (or a chart sheet – which has nothing but the chart). This can be …
When working with dates in Excel, sometimes you may want to know what day the date is (whether it’s a Monday or a Tuesday, or any other weekday). This could especially be useful in project planning, where some days could be for a specific task (such as having a project meeting or sending the progress …
If you’re working with large datasets in excel, getting Descriptive Statistics for this data set could be useful. Descriptive Statistic quickly summarizes your data and gives you a few data points that you can use to quickly understand the entire data set. While you can also calculate each of these statistical values individually, using the …
Macros in Excel are a game-changer if you have to deal with repetitive tasks. Macros allow you to automate many time-consuming tasks and also create some functions and functionalities that are not already built-in in Excel. As a part of the security measure, if you receive a file that has a macro, Excel will disable …
Area Under Curve (AUC) is a widely used concept in data sciences in multiple fields. While the concept of Area Under Curve is quite simple – which is to calculate the total area covered between the curve/line and the axis – there is no direct way to calculate this in Excel. But it isn’t too …
©trumpexcel.com – Free Online Excel Training
