Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
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 …
Excel has an in-built MEDIAN function, but there is no MEDIANIF function. But that’s not an issue. In this article, I will show you how you can create your own MEDIAN IF function by combining the MEDIAN and the IF function. I will also show you how to do the same using PERCENT.INC function. MEDIAN …
In some situations, you may have the month name that you want to convert into the month number so that it can be used further in calculations. While there is no built-in function to do this in Excel, it’s pretty easy with simple formula workarounds. In this article, I will show you a couple of …
Choosing the right fonts for your Excel spreadsheets can make a big difference in readability and visual appeal. In this article, I will list the best fonts in Excel that you can try. These are based on my personal experience of 15+ years of working with Excel spreadsheets (and other Microsoft Office applications) Aptos Narrow …
©trumpexcel.com – Free Online Excel Training
