Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
When working with Pivot Tables in Excel, I always ensure that my Pivot Tables are displayed in the tabular form. I don’t know why, but Microsoft has decided that any default Pivot Table would be shown in the Compact form. While powerful, the standard Compact Form in Pivot Tables can sometimes feel a bit… well, …
Working with percentages is a daily task for many Excel users. Now you cannot simply add a percentage value to a number to get the right result. For example, you cannot use 10 + 10% to get 11. Thankfully, Excel gives you a couple of really simple ways to do this. In this tutorial, I’ll …
When working with very large numbers in Excel, you often need to round them to the nearest thousand for better readability and analysis. This is especially helpful when you’re working with sales data, budget estimates, population data, or financial reports, etc. Rounding to the nearest thousand makes your data cleaner and easier to work with. …
Sometimes when you download data from external sources or import information from other systems, you end up with fractions that are stored as text instead of actual numbers. You might see values like “17/76” or “1/4” sitting in your cells, and Excel treats them as text rather than mathematical expressions you can work with. This …
Creating barcodes in Excel can be useful for inventory management, product labeling, or any scenario where you need to generate scannable codes directly from your spreadsheet data. While Excel doesn’t have a built-in barcode generator, this can be done by using the IMAGE function or by installing a barcode form. In this article, I will …
Excel formulas can get complicated, especially when you’re working with advanced functions or creating solutions for others to use. Adding comments directly within your formulas can make them more understandable and easier to maintain in the future. It’s like leaving helpful notes for yourself or anyone else who might need to work with your spreadsheets …
If you want to repeat rows in your dataset N number of times (say 5 or 7 times), or based on a value in a column, Power Query is the easiest way to do that. In this article, I’ll walk you through two methods to repeating all rows the same number of times, and repeating …
I was recently working on a project where I had multiple lists in Excel and I had to create all the possible combinations using these lists. To give you an example, suppose I three separate lists where I have: Now I want to get one single list that would include all the possible combinations from …
A common complaint of many Excel users is that they can’t directly use Excel table’s structured references in data validation to create drop-down lists. If you try, Excel would give you an ugly pop-up and refuse to play along. But what if you still want to (somehow) use Excel table as the source in data …
©trumpexcel.com – Free Online Excel Training
