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

1 Hyperlinks in Excel (A Complete Guide + Examples)

Excel allows having hyperlinks in cells which you can use to directly go to that URL. For example, below is a list where I have company names which are hyperlinked to the company website’s URL. When you click on the cell, it will automatically open your default browser (Chrome in my case) and go to […]

0 How to Quickly Unhide COLUMNS in Excel (A Simple Guide)

Watch Video – How to Unhide Columns in Excel 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 […]

2 Using Index & Match Functions Combo in Excel (10 Easy Examples)

Three Way Lookup - Result using INDEX MATCH

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

4 How to Recover Unsaved Excel Files [All Options + Precautions]

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

0 How to Insert a Check Mark (Tick ✓) Symbol in Excel [Quick Guide]

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. This Tutorial Covers: Check Mark Vs Check BoxInserting Check Mark Symbol in ExcelCopy and Paste the Check MarkUse the Keyboard ShortcutsUsing the Symbols Dialog […]

0 Excel VBA Error Handling – All You Need to Know!

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

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

1 2 3 … 51 Next »