Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
If you prefer written instruction instead, below is the tutorial. Hidden rows and columns can be quite irritating at times. Especially if someone else has hidden these and you forget to unhide it (or even worse, you don’t know how to unhide these). While I can’t do anything about the first issue, I can show …
Excel has a lot of functions – about 450+ of them. And many of these are simply awesome. The amount of work you can get done with a few formulas still surprises me (even after having used Excel for 10+ years). And among all these amazing functions, the INDEX MATCH functions combo stands out. I …
Looking to recover unsaved Excel file, click here to jump to all the possible options you have to get the file back. Let me tell you the shortest horror story ever. Excel Crashed! Imagine working on that urgent report or that extremely important dashboard where you have done such a fantastic job. You are proud …
Below is the written tutorial, in case you prefer reading over watching the video. In Excel, there are two kinds of tick marks (✓) that you can insert, a check mark and a checkbox. And no… these are not the same. Let me explain. Follow along with the example file Check Mark in Excel.xlsm Download …
No matter how experienced you’re with VBA coding, errors are always going to be a part of it. The difference between a novice and an expert VBA programmer is that the expert programmers know how to effectively handle and use errors. In this tutorial, I will show you various ways you can use to handle …
The first step to working with VBA in Excel is to get yourself familiarized with the Visual Basic Editor (also called the VBA Editor or VB Editor). In this tutorial, I will cover all there is to know about the VBA Editor and some useful options that you should know when coding in Excel VBA. …
When we use VBA in Excel, most of it is to automate our tasks. This also means that most of the time, we work with cells and ranges, worksheets, workbooks, and other objects which are a part of the Excel application. But VBA is a lot more powerful and can also be used to work …
What happens when you type the word ‘Drnik’ instead of ‘Drink’ in Excel? You would notice that Excel will autocorrect that misspelled word to Drink (as shown below). Somehow, Excel knew that this is not the correct spelling and autocorrected it to the right one. Now, it won’t autocorrect all the misspelled words. Just a few! …
VBA has some useful functions that can take your automation in Excel to the next level. One such function is the VBA DIR function. While by itself, it may seem like a simple function that does one specific thing. But when you combine it with some other useful elements of the VBA coding language, you …
©trumpexcel.com – Free Online Excel Training
