Expanding References in Excel

Expanding References in Excel

An expanding reference or range is essentially a dynamic reference which can expand as a formula is copied down or across cells. In this article, we’re going to show you the expanding references in Excel and go over some common use cases.Creating an expanding...
How to calculate percentage in Excel

How to calculate percentage in Excel

A percentage is a number or ratio that represents a fraction of 100, and this representation is used widely from interest rates to risk analysis, or really in any application when the contribution of a specific item to the whole is to be highlighted. In this article,...
Tips for Excel Tables

Tips for Excel Tables

Excel Table is a tool for managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which includes filtering, formatting, sizing, and auto populating formulas dynamically. In this guide, we’re going to go over some...
Spill Range Operator

Spill Range Operator

With the introduction of the dynamic arrays and spill concepts, Microsoft has also released a spill range operator (#). This operator is designed to reference spill ranges dynamically.For example, the cell D3 has =UNIQUE(B3:B16) formula which spills the return values...
Dynamic Arrays

Dynamic Arrays

Dynamic arrays can populate a range of cells from the values of an array. With dynamic arrays, any formula that returns an array of values will spill the results into the adjacent empty cells automatically. You can create tools like interactive pricing applications...