Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Scientific notation is a format that allows us to write very large or very small numbers in a consistent decimal format. This can be useful when you are working with large numbers and you do not want them to take up a lot of space in your Excel worksheet. In such a case, you can …
Most of the time, when working with Excel, you need to restructure your data before you can start any kind of analysis. One common task many Excel users have to do is convert columns into rows in their existing dataset. This is usually the case when you get your data set from a database or …
It’s a common data analysis task to count the number of cells with a value that is less than a specific threshold. For example, if you have sales figures of different sales reps in a column, you may want to know how many sales reps were not able to meet the given sales target. Or …
Whenever I’m working with financial data, I have to clean and format it so it’s more readable. One of the things I often have to do is change the format of the cells that contain figures such as revenue or profit to show them in millions. For example, instead of showing 5735241, it’s better to …
I was recently working on a project where I had to create QR codes (Quick Response codes) in bulk in Excel for some of the URLs I had in a column. I figured out a couple of different ways to do this, and in this article, I’m going to share four methods you can use …
If you want to count the numbers that fall between two given numbers in Excel, it can easily be done using the COUNTIFS function (or COUNTIF and SUM if you’re on an older version). For example, if you’re analyzing the sales data of your sales reps, you may want to know how many of them …
It’s a common task to calculate ratios when working with financial data or doing other data analysis work in Excel. Even in our day-to-day life, we use ratios in areas such as screen size (in specifying resolutions such as 16:9) or cooking (in specifying proportions such as using two ingredients in 2:3 proportion). While there …
Deleting a row or deleting multiple rows is a regular part of most Excel users. Sometimes you need to delete rows when cleaning up your dataset or when you make a mistake and want to start over. Whatever your reasons, deleting rows in Excel is super easy (just like ordering a Pizza). It only takes …
If you want to count filtered rows in Excel, you can do that using the SUBTOTAL function. The SUBTOTAL function allows you to perform a regular count on a column with the ability to exclude those rows that have been filtered out. In this short tutorial, I will show you how to use the SUBTOTAL …
©trumpexcel.com – Free Online Excel Training
