Resources

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 going...

How to sort in Excel Tables

How to sort in Excel Tables

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

How to Create an Excel Table

How to Create an Excel Table

Excel Table is a feature used for managing and analyzing data in a tabular format. This way, you can display data in a neat and concise structure, while also including filtering abilities, easy-to-use formatting and layout options, and automatically...

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,...