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.
If you have a cell with text that’s longer than the cell width, Excel lets that text spill over into the next column when that column is empty. Google Sheets has a built-in Clip option that cuts off the extra text right at the cell border. Unfortunately, Excel does not have a built-in Clip option. …
The Chi-Square test lets you figure out if two things in your data are actually related. Maybe you ran a survey and want to know if gender affects car color preference. Or you’re looking at student results and wondering whether the teaching method makes a difference in pass rates. It works with any data where …
Excel doesn’t have a built-in function to convert numbers into words. But there are a couple of reliable ways to do it, and I’ll walk you through both in this article. Click here to download the example file Method 1: Using VBA Macro to Create Custom Function (Recommended) This is the most widely used and …
If you’ve ever had to create dozens (or even hundreds) of folders manually, you know how tedious it can get. Right-click, new folder, type the name, repeat. It gets old really fast. The good news? You can automate this entire process using a simple VBA code in Excel. Just list your folder names in a …
If you want to remove blank rows from a dataset using a formula in Excel, you can do that by using the FILTER function. Below is an example where I have a dataset on the left, and then I’ve used the filter function to extract only those rows that are not blank on the right. …
Adding years to a date in Excel can be a bit tricky. This is because Excel stores dates as numerical values in the backend. So if I want to add one year to a date (say 1st January 2026), I have to ensure that I am adding the right number to my existing date, which …
In this article, I will show you some simple Excel formulas you can use to get the end-of-year date in Excel. Now if you’re wondering why you may even want that, and of course the end of the year date is going to always be 31st December of that year, here is the thing: Dates …
Sometimes you may have a large dataset that you are working with in Excel and you want to select alternate columns, or every third or every fourth column in your dataset. While there is no inbuilt feature to do this in Excel, there are some easy workarounds. In this article, I’ll show you three ways …
Pivot Tables come with a lot of in-built sorting options that allow you to structure your data the way you want. While you can use the regular sorting options (sorting A-Z / Z-A or Smallest to Largest or Largest to Smallest), there are also options to sort based on a custom list and even specify …
©trumpexcel.com – Free Online Excel Training
