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.
Do you spend a lot of time formatting data in Excel? If yes, then you may find the AutoFormat option useful in speeding up your formatting work. It allows you to quickly apply a preset formatting on a data set that has one header row and one header column. It allows you to quickly apply …
There is no inbuilt function in Excel to extract the numbers from a string in a cell (or vice versa – remove the numeric part and extract the text part from an alphanumeric string). However, this can be done using a cocktail of Excel functions or some simple VBA code. Let me first show you …
A worksheet in Excel is made up of cells. These cells can be referenced by specifying the row value and the column value. For example, A1 would refer to the first row (specified as 1) and the first column (specified as A). Similarly, B3 would be the third row and second column. The power of …
If you work with an Excel file that needs to be updated or reviewed by other people, the option to track changes can come in handy. You can also use it when you’re updating a file and need to keep a track of all the changes you do yourself. This can be helpful when you …
When it comes to looking up data in Excel, there are a few amazing functions that I often use, XLOOKUP, VLOOKUP and INDEX (mostly in conjunction with the MATCH function). However, these formulas are designed to find only the first instance of the lookup value. XLOOKUP can also give you the last match, but not …
When using the VLOOKUP formula in Excel, sometimes you may end up with the ugly #N/A error. This happens when your formula can not find the lookup value. In this tutorial, I will show you different ways to use IFERROR with VLOOKUP to handle these #N/A errors cropping up in your worksheet. Using the combination …
“Compound interest is the eighth wonder of the world. He who understands it, earns it … he who doesn’t … pays it”. – Albert Einstein What is Compound Interest? Let me take a simple example to explain it. Suppose you invest USD 1000 in a bank account that promises to give you 10% return at the end of …
One of the Excel queries I often get is – “How to highlight the Active Row and Column in a data range?” And I got one last week too. So I decided to create a tutorial and a video on it. It will save me some time and help the readers too. Below is a video …
I recently got an email from one of my readers with an interesting query on using drop-down lists in Excel. He asked me if it was possible to have a drop-down list that shows numbers based on the two specified numbers. Something as shown below: Note that the drop-down start from the number in column …
©trumpexcel.com – Free Online Excel Training
