Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
Excel has multiple count-related functions that allow you to quickly analyze large data sets. A common task for many people Is to count cells that contain a value in between two specific numbers. For example, if you are analyzing sales data for different Sales Reps in your company, you may want to know the number …
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 …
Most of my time working in Excel is spent cleaning data that I get from different sources. One common task that I have to do quite often is to remove parentheses (or brackets) from the cells in a dataset. As with almost everything else in Excel, there are multiple ways you can remove the parenthesis …
I’m a huge fan of using shortcuts in Excel to speed up my work While there are many shortcuts that I use on a daily basis, one that I find particularly useful is the ability to repeat the last performed action in Excel. This is useful when you have to do the same thing repeatedly …
In many situations, you may want to quickly highlight all the cells with formulas in Excel. When I was working as a financial analyst a few years ago, this is something I used to do often to mark the cells that contain formulas. Another situation where this may be useful is when you want to …
©trumpexcel.com – Free Online Excel Training
