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...
by Ilker | Apr 26, 2019 | Excel Tips & Tricks
The dreaded error message that says that your Excel workbook is corrupted can be intimidating. But fear not! There are a few things you can do to recover your work, or at least extract some of it and save yourself some time. In this guide, we’re going to show you how...
by Ilker | Apr 19, 2019 | Excel Formulas, Excel Tips & Tricks
Filtering data helps focusing on certain aspects of a data set. Excel has built-in features for this, an Excel formula for filtering data was not in the software’s scope until the introduction of dynamic array functions. In this guide, we’re going to show you...
by Ilker | Apr 18, 2019 | Excel Tips & Tricks
The Excel CLEAN function is a Text formula that removes “non-printable” characters from a text string. The function is especially useful for eliminating unsupported characters from a text that was imported from an external source. In this guide, we’re...
by Ilker | Apr 15, 2019 | Excel Formulas, Excel Tips & Tricks
How to generate random numbers in ExcelYou can generate decimals between 0 and 1, and integers between certain limits using the RAND and RANDBETWEEN functions. RANDARRAY function is a new addition to randomization formulas, which is currently only available to a...
by Ilker | Apr 11, 2019 | Excel Tips & Tricks
The AutoCorrect is an essential feature which is designed to correct typos automatically. This feature is also helpful for changing abbreviations to full versions, adding symbols, or correcting grammar errors, but it can also sometimes do things in a way that...
