Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
In this article, I will show you how to add a trendline in Excel charts. A trendline, as the name suggests, is a line that shows the trend. You’ll find it in many charts where the overall intent is to see the trend that emerges from the existing data. For example, suppose you have a …
I am a big fan of using Excel templates to plan and manage work. I regularly use to-do lists and calendars to plan my days in advance. In this post, I am sharing an Excel calendar template that you can use in Excel or even take a printout and stick it at home or at …
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 …
If you work with a lot of worksheets in Excel, you would know that management of it can become an issue. Once you have more than a couple of worksheets, you need to manually arrange these. How easy would it be had there been a way to quickly sort the worksheets alphabetically in Excel. While …
When it comes to inserting symbols in Excel, things can get a bit complicated. You either need to know the keyboard shortcut, or use the methods that are not very straightforward. And there are a lot of symbols that many people need to insert regularly, such as the degree symbol, cent symbol, delta symbol, etc. …
Excel VBA has the IF Then Else construct that you can use to analyze multiple conditions and execute codes based on these conditions. Another similar construct that allows you to check for multiple conditions is the SELECT CASE statement. Select Case is useful when you have three or more conditions that you want to check. …
©trumpexcel.com – Free Online Excel Training
