by Ilker | Jun 18, 2020 | Excel Tips & Tricks
Visualizing, and subsequently observing trends in data is very important for making any sense of it, and hopefully plan accordingly. Likewise, tracking the spread of COVID-19 has been paramount in understanding how, where, and when it has been spreading, and...
by Ilker | Apr 19, 2018 | Excel Macros, Excel Tips & Tricks
Although keeping the data on different sheets help organizing them in terms of look and feel, this approach may cause problems when you need to get data from all sources. VLOOKUP or INDEX functions can’t really help here, and other methods to combine data can be...
by Adam | Jan 23, 2018 | Blog
Excel is the primary data tool for many business users. However, we all know that data often comes in different forms, from different sources, and your reporting tools can be demanding as to what you can feed them. Reshaping data is often necessary for a clean...
