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.
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 …
Excel Advanced Filter is one of the most underrated and under-utilized features that I have come across. If you work with Excel, I am sure you have used (or at least heard about the regular excel filter). It quickly filters a data set based on selection, specified text, number or other such criteria. In this …
Intersect Operator in Excel can be used to find the intersecting value(s) of two lists/ranges. This an unusual operator as it is represented by a space character (yes that’s right). If you use a space character in between two ranges, then it becomes the Intersect operator in Excel. Intersect Operator in Excel You can use Intersect …
VLOOKUP is one of the most used functions in Excel. It looks for a value in a range and returns a corresponding value in a specified column number. Now I came across a problem where I had to lookup entire row and return the values in all the columns from that row (instead of returning a …
Last week, I came across an Excel problem in a forum. I immediately sprung into action and created a long formula that started with OFFSET(). Within a few hours, it was shot down by other Excel experts as it contained volatile formulas. I immediately recognized the cardinal sin I had committed. So with this confession, …
Sometimes, you may want the options in one drop-down list to change based on what you pick in another. This is called a dependent drop-down list. For example, when you pick Furniture as the category, the second drop-down should only show items such as Chairs and Tables. Excel doesn’t have this as a built-in feature, …
©trumpexcel.com – Free Online Excel Training
