by Ilker | Jun 10, 2019 | Excel Macros, Excel Tips & Tricks
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...
by Ilker | May 30, 2019 | Excel Tips & Tricks
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 show you...
by Ilker | May 29, 2019 | Excel Tips & Tricks
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...
by Ilker | May 28, 2019 | Excel Tips & Tricks
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 updating any...
by Ilker | May 28, 2019 | Excel Tips & Tricks
A name in Excel is used for referencing a cell, range, formula, or constant value for easier and faster access to those references. These names are called named ranges in Excel. Using named ranges in your workbook models can save you time and increase your efficiency....
by Ilker | May 22, 2019 | Excel Tips & Tricks
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...
by Ilker | May 14, 2019 | Excel Formulas, Excel Tips & Tricks
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...
by Ilker | May 13, 2019 | Excel Tips & Tricks
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...
by Ilker | May 10, 2019 | Excel Tips & Tricks
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...
