Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
Excel is a really thought out spreadsheet tool and has so many simple tricks that can boost your productivity and save time. But at the same time, there are some simple things that are missing and often leads to a lot of frustration. For example, there are so many ways for you to quickly select …
By default, Excel has a certain row height and column width, and when you enter anything that occupies more space than the current size of size, you’ll see that it spills out (as shown below). In such cases, you can adjust the rows and columns to fit the text in the cell (so that the …
Using multiple worksheets in an Excel workbook is an easy way to keep your data organized. For example, you can have different sheets for different regions, or for different months/year, or different projects, etc. And when working with multiple sheets, you may sometimes need to change their names. In this Excel tutorial, I will show …
If you often print your data/work in Excel, I am sure you have faced the issue where it prints multiple pages instead of one single page. Sometimes, it’s so frustrating that a new page is printed just to accommodate a few extra lines of data (which also leads to wastage of paper). There are some …
Apart from using Excel with numeric data, a lot of people also use it with text data. It could as simple as keeping a record of names to something more complex. When working with text data, a common task is to make the data consistent by capitalizing the first letter in each cell (or to …
If you have worked with formulas in Excel for some time, I am sure you have already met the #REF! Error (reference error). Since this is quite common, I thought of writing a tutorial just to tackle the #REF! error. In this Excel tutorial, I will cover what is the #REF! error, what causes it, …
Comments are quite useful when you want to add some information about a cell/data point without changing the content of the cell. I often use these when I am using formulas and I need to specify what a formula does and what a cell value means. If you’re collaborating with others, you can also add …
When working with multiple worksheets in Excel, sometimes you may have a need to edit the same cell in all the worksheets (or apply certain formatting the same cell/range in all the sheets). You can easily group worksheets in Excel so that you can make the changes at one go (instead of going to each …
With financial data, you would often see the use of two metrics – Average Annual Growth Rate (AAGR) and Compound Annual Growth Rate (CAGR). While there are some existing formulas in Excel that can help you calculate growth rates, for calculating AAGR and CAGR, you would need a little bit of workaround (nothing too complex …
©trumpexcel.com – Free Online Excel Training
