Looking for some awesome Excel tips and tutorials? You’re at the right place.
Here you’ll find a collection of amazing excel tips that will make you an Excel Ninja and save a lot of time.
All the Excel tips are covered in detail with supporting images and a video (in most of the cases).
If you’re a beginner in Excel, you can start from out Learn Excel section.
You also find tips and tutorials on various Excel topics such as charting, dashboards, and VBA. In addition to the tutorials, you will also find some useful Excel templates that you can download for free.
You will also find Excel formula tips to get common tasks done using the formulas. You can also visit the Excel Functions section to learn about most commonly used Excel functions such as VLOOKUP, INDEX, OFFSET, COUNTIF, IFÂ and so on..
Also check out our Online Excel Training courses on Excel (Basic to Advanced), Dashboard, and VBA.
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 …
Recently, I was working on a project where I had data in multiple rows, and I needed to combine the multiple rows and get the result in one single column. There are multiple ways to do this in Excel. If you’re using Excel with Microsoft 365, there is a dedicated formula to do this, and …
Excel worksheets are made up of cells with default heights and widths. In most cases, you will need to adjust the cells to adjust your dataset. In this article, I will show different methods you can use to make the cells bigger. Zoom-in The Worksheet One quick way to make the cells appear bigger is …
In this article, I will show you how to convert days to months in Excel using a couple of simple formulas. This could be useful when you are creating a project plan that has a start and an end date, and you want to know how many months there are between the start and the …
©trumpexcel.com – Free Online Excel Training
