Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
Getting Dark Mode has been one of the most requested features for Microsoft Excel and finally the dark lords in the Microsoft office has decided to give it to us. With this new feature release, you can easily enable the dark mode in most Microsoft applications such as Excel, Word, PowerPoint, or Outlook. In this …
Recently I was working on a project where I had to filter all the cells that had strikethrough formatting applied to it. The issue is… There is no built-in way to filter cells that have strikethrough applied to them. So we need in a workaround. In this article, I will cover two simple ways you …
Sometimes you may want to write text vertically in Excel to save space and make your data more presentable. This could specially be useful if you are planning on printing your work. While, by default whenever you write anything in Excel it’s written horizontally, it’s very easy to convert it into vertical writing. Below is …
Excel has three types of worksheet views: In most cases, you will be working with the Normal view. If for some reason, your worksheet looks weird, it’s possible that the view setting is changed and you need to return to the Normal view. In this article, I will show you three simple ways to return …
Whenever you open a new Excel workbook, you will see that a default font type and font size have already been selected for you. Since 2023, Excel versions have Aptos Narrow as the default font, and earlier, it used to be Calibri. If you want to change the default font in your Excel files, you …
The P-value is an important concept in statistics that is often used in hypothesis testing and decision-making. Since Excel is a widely used tool for many statistics calculations, it would be useful to know how to calculate the P-value in Excel. Excel already has some built-in functions and even an add-in that makes it really …
©trumpexcel.com – Free Online Excel Training
