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.
You can easily add bullet points in a cell Excel (Yes.. easily). Until I knew this trick, I used to put a dash (-) or arrow greater than (>>) at the beginning of the text, and that could sometimes be a pain. I always wondered why was Excel devoid of such basic functionality. But that …
There isn’t any trickery involved in this post. I just want to give you a quick and simple way to insert new cells in excel. First, let’s see the usual way of doing it. Suppose, you have a data set as shown below and you want to insert blank cells in C2:C4, in such a …
Today I am going to give you a powerful formula cocktail. The less-used INDIRECT() and ROW()Â function together with the MID() function can create a magnificent concoction. This triad enables you to get into the contents in a cell. and analyze each character separately. For example, suppose you have Excel123 in a cell, and you want …
We all use Google as a part of our daily routine. One of its features is search suggestion, where Google acts smart and gives us a list of suggestions while we are typing. In this tutorial, you’ll learn how to create a searchable drop-down list in Excel – i.e., a drop-down list that will show the matching …
Below is the complete written tutorial, in case you prefer reading over watching a video. Conditional Formatting in Excel can be a great ally in while working with spreadsheets. A trick as simple as the one to highlight every other row in Excel could immensely increase the readability of your data set. And it is as …
Input Message in Excel can be used to show a message when a cell is selected. It is particularly useful if you want to show some instructions to the user when he/she selects a cell. Examples could be to display form filling instructions or data entry instructions. Can’t this also be done using comments in …
In this tutorial, you’ll learn how to find the position of the last occurrence of a character in a string in Excel. A few days ago, a colleague came up with this problem. He had a list of URLs as shown below, and he needed to extract all the characters after the last forward slash (“/”). …
A few days ago, I was working on creating an Excel dashboard. I had to create a number of drop-downs with the options ranging from 1 to 5. To make it more user-friendly, I also wanted to give an option of ‘Not Selected’, when a user does not want to make a selection in the drop …
A lot of times we need to make a copy of a worksheet in Excel. Maybe you want to create a back-up worksheet, or you want to create a new worksheet but don’t want to redo the formatting. The long (and inefficient) way is: This will create a copy of the worksheet. While this is …
©trumpexcel.com – Free Online Excel Training
