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 | May 9, 2019 | Excel Formulas
The MEDIAN Excel function is a Math formula that calculates and returns the median of the selected values. The median in statistics represents the middle value in a dataset. In this guide, we’re going to show you how to use the Excel MEDIAN function and also go over... 
by Ilker | May 9, 2019 | Excel Formulas
The TRANSPOSE Excel function is a Lookup & Reference formula that rotates a given range or array. Since the output of this formula is an array, you need to press the Ctrl + Shift + Enter (CSE) key instead of just pressing the Enter key when entering this function.... 
by Ilker | May 7, 2019 | Excel Formulas
The CONCATENATE Excel function is a Text formula that joins multiple strings together. You can enter static strings and individual cell references. In this guide, we’re going to show you how to use the CONCATENATE Excel function and also throw in some tips and error... 
by Ilker | May 7, 2019 | Excel Formulas
The TEXTJOIN Excel function is a Text formula that joins strings together with a delimiter. You can enter static text strings, a range of cells, and individual cell references to join. In this guide, we’re going to show you how to use the Excel TEXTJOIN function and... 
by Ilker | May 6, 2019 | Excel Formulas
The CONCAT is a Text function that joins strings together. When using concatenate in Excel, you can enter static strings, a range of cells to join, and individual cell references. In this guide, we’re going to show you how to use the CONCAT function to merge cells in... 
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 25, 2019 | Excel Formulas
The Excel REPLACE function is a Text formula that replaces any text in a specific location with another. You can obviously use Excel’s Find & Replace tool to do this, but a formula approach will give you more options as to how you can handle this, and also...