Excel Blog - Latest Excel tips, tutorials, and videos.

6 How to Add a TrendLine in Excel Charts (Step-by-Step Guide)

Select the Trendline option in chart elements

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 […]

6 FREE Monthly & Yearly Excel Calendar Template (2019 and Beyond)

Calendar Contemporary Digital Device Concepts

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 print out and stick it at home or at […]

0 Visual Basic Editor – How to Open and Use it in Excel

Different Parts of the VB Editor in Excel

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. […]

3 Using VBA FileSystemObject (FSO) in Excel – Easy Overview & Examples

Scrrun Microsoft Scripting Runtime Library Option Checked

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 […]

6 Excel AutoCorrect – A complete Guide with Useful Time Saving Examples

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! […]

0 VBA DIR Function – An Easy Explanation with Examples

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 […]

1 How to Sort Worksheets in Excel using VBA (alphabetically)

Copy and Paste the code to sort worksheet tabs in Excel

If you work with a lot of worksheets in Excel, you would know the 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 in Excel. While there […]

1 2 3 … 50 Next »