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

0 How to Create a Dynamic Chart Range in Excel

When you create a chart in Excel and the source data changes, you need to update the chart’s data source to make sure it reflects the new data. In case you work with charts that are frequently updated, it’s better to create a dynamic chart range. What is a Dynamic Chart Range? A dynamic chart […]

4 Understanding Absolute, Relative, and Mixed Cell References in Excel

Mixed Cell References in Excel - Formula

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 first column (specified as A). Similarly, B3 would be third row and second column. The power of Excel lies […]

0 How to Make a Bell Curve in Excel (Step-by-step Guide)

A bell curve (also known as normal distribution curve) is a way to plot data that looks like a bell curve. In the bell curve, the highest point is the one that has the highest probability of occurring, and the probability of occurrences goes down on either side of the curve. It is often used during […]

0 How to Enable and Use Track Changes in Excel

When What and Where in accept reject changes in excel

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

4 Lookup the Second, the Third, or the Nth Value in Excel

Formula to lookup the second third and nth value

Watch Video – Lookup the Second, the Third or the Nth Matching Value When it comes to looking up data in Excel, there are two amazing functions that I often use – VLOOKUP and INDEX (mostly in conjunction with the MATCH function). However, these formulas are designed to find only the first instance of the lookup […]

10 Use IFERROR with VLOOKUP to Get Rid of #N/A Errors

Error with VLOOKUP when lookup value not found

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

0 FREE Monthly & Yearly Excel Calendar Template (2017 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 some useful Excel calendar templates that you can use in Excel or even take a print and stick where you work. While […]

1 2 3 … 33 Next »