excel offset - Free Excel Tutorial

How to Average the Last N Values in Excel

In Excel there are a lot of built-in functions, and AVERAGE is one of the most frequently used functions. We can apply it to calculate the average of numbers from a given range reference. In daily work, we may apply AVERAGE function together with some other functions to get average based on some conditions. For… read more »

Calculate Average Of Last 5 Or N Values In Columns

Suppose you come across a task where you need to calculate the average of the last 2 or 3 numeric values, then what would you do? If you are new to Excel, then your first attempt might be doing this task manually, which is an acceptable way but only when the values of which you… read more »

How to Average Last N Values in Multiple Columns

In Excel there are a lot of built-in functions, and AVERAGE is one of the most frequently used functions. In daily work, we may apply AVERAGE function together with some other functions to get average based on some conditions. In this article, we will let you know the method to apply AVERAGE function together with… read more »

How to Create Dynamic Named Range in Excel

This post will guide you how to create dynamic named range that can expand automatically when you add a new value into the current range in Excel 2013/2016. How do I create a dynamic named range with a formula in Excel. How to create a dynamic named range by creating a table in Excel. Creating… read more »

How to Convert Multiple Rows into a Single Row in Excel

This post will guide you how to convert multiple rows or columns into a single row with a formula in Excel 3013/2016. How do I convert groups of rows to a single row of columns with VBA Macro in Excel. Convert Multiple Row into Single Row with Formula Convert Multiple Row into Single Row with… read more »

Create a Chart That Updates with New Data Automatically

This post will guide you how to create a chart that updates with new data automatically in Excel. How do I create self-updating chart in Excel. How to get charts to automatically update with new data point in your current worksheet. Or how to use defined names to update a chart with new data point… read more »

Split Data in One Column to Multiple Columns

This post will guide you how to split data in a single column into multiple columns with a formula in Excel. How do I transpose data from one column to multiple columns in Excel. How can I make one long column into multiple columns in Excel. Split Data in One Column to Multiple Columns Assuming… read more »

Sum Specific Row or Column in Named Range

This post will guide you how to sum a specific Row or Column in a named range in excel. Normally, you can easily sum a certain row or column in a worksheet in excel. But if you just want to sum a particular column or row in a named range, how to achieve it in… read more »

Sidebar