ytokarev

Home/Yury Tokarev

About Yury Tokarev

This author has not yet filled in any details.
So far Yury Tokarev has created 2 blog entries.

Dynamically consolidate multiple ranges

Dynamically consolidate multiple ranges when loading Excel files from Folder in Power Query We've come across a task where we need to consolidate a client's budget data from Excel files, each representing a division, where any of the files may have multiple similarly structured tabs with sub-divisional data. In our project, each subdivision [...]

3 Easy Steps to Create Waterfall Chart in Excel 2016

Create a Waterfall Chart by Yury Tokarev A waterfall chart is a great way to represent financial inflows and outflows. Yet, it is a daunting task to create this in Excel versions up to 2013 (see links below for help!). The good news is that Excel 2016 has taken all the complexity away. [...]

2017-03-08T03:53:55+08:00Excel 2016|