by Ilker | Jul 3, 2020 | Excel Tips & Tricks
A sunburst chart is a type of visualization that – just like treemap charts – works great for displaying hierarchical data. A sunburst chart is drawn in a circular layout where each ring represents a level in the group hierarchy. While the inner ring...
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 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...