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.
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 …
If you want to make a dense spreadsheet easier to read, choosing the right fonts can make a big difference. They can improve its visual appeal, too. In this article, I will list the best fonts in Excel that you can try, including a pick for numbers. These are based on my personal experience of …
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 …
It’s easy to add sheet names to header or footer in Excel. Once done, the sheet name will appear In the header or the footer of the page when you print it. This is especially useful when you’re working with a large workbook and need to print multiple worksheets. Having the sheet name in the …
If your Excel application is crashing or causing issues, you can try opening it in the ‘Safe Mode’. When you open Excel in safe mode, it disables features such as add-ins and custom settings, which helps you troubleshoot and identify the issues. In this quick guide, I will show you two easy ways to open …
©trumpexcel.com – Free Online Excel Training
