5 Ways to Create an Excel Named Range

5 Ways to Create an Excel Named Range

Named ranges are cells, ranges, tables, formulas, or constant values that are represented with meaningful names, that are tied to their workbook reference (i.e. A1, B23, A1:B23). Using named ranges make formulas easier to read and maintain. In this guide, we’re...
How to create calculated columns in Excel tables

How to create calculated columns in Excel tables

Excel Tables are very useful in managing and analyzing data in tabular format. An Excel Table provides the data in a special structure, which comes with filtering, formatting, and sizing, and can also auto populate formulas dynamically. In this guide, we’re going to...
How to Get Excel Stock Quotes

How to Get Excel Stock Quotes

Excel is one of the best platforms to do stock quote analysis. However, you traditionally had to pull this data either manually, or using third party tools. Now, you can do this using built-in Excel features if you are running Office 365. In this article, we are going...
How to get top values from a list or a table in Excel

How to get top values from a list or a table in Excel

Sorting data can substantially help organizing data and generating reports. In Excel, you can sort data with a single click using the Sort icons under the DATA tab. However, this is a permanent solution, meaning that the sorted data will remain that way, and you will...
How to Generate a General Ledger (GL) List using SEQUENCE

How to Generate a General Ledger (GL) List using SEQUENCE

Ledgers are crucial for keeping track of expenses, and managing the budget of any entity, be it a small house to an international company. Preparing a general ledger (GL) table can be a daunting task, especially when dealing with lots of category codes. If your table...
How to generate a date list using the SEQUENCE function

How to generate a date list using the SEQUENCE function

Date lists are an important part of numerous Excel models. Excel can automatically recognize date-time values, format the cells, and generate a date list quickly with AutoFill or specific functions. However, date-time functions are focused on a generating a single...
Stock Charts (Candlestick) in Excel

Stock Charts (Candlestick) in Excel

A stock chart, also known as a candlestick chart, is a visual representation of a multitude of data on a timeline. This visualization type is typically almost exclusively used for visualizing stock market prices. The data series appear like candles with a rectangular...
Surface Chart in Excel

Surface Chart in Excel

A surface chart plots data on a three-dimensional surface, in a similar way that topographic maps visualize elevation. The colors and patterns represent values within the same range. This chart type is especially useful for finding the optimum results when comparing...