Forecasting in Excel 2016 made simple

Forecasting is one of the most common business challenges an analyst can face. So far the toolsin Excel were not very simple when it came to more complex tasks. Linear forecast functions have always been there though. But once you needed to start dealing with seasonality or confidence intervals there was no simple answer. This ...

AB test calculator Excel web app

AB test calculator Excel web app
A/B testing is one of the most common tecniques when it comes to optimizing marketing materials and funnels. I have also already written about 7 key points to make sure that you nail your tests. This time though I thought of creating a “web application” to help you validate the results of your tests. This ...

Bond rate tracking with Power Query

26. April 2016 Excel, Projects 0
Bond rate tracking with Power Query
I was always curious how I could get Power Query useful. In the same time I was struggling with tracking some bonds I was interested in, I\'m a visual guy and I was not satisfied with the type of charts my bank could provide. So these 2 needs met and I have created an automated ...

Pivot tables first steps [video]

28. March 2016 Excel 0
Pivot tables first steps [video]
If you ever needed to create summaries of raw data, but had no time you have most probably heard of pivot tables before. They are glorious when it comes to solving many of your usual excel tasks, though still not all of us know how to use them, despite them being pretty straightforward. What pivot ...

7 cool Excel tricks to rock at work [Infographic]

06. March 2016 Excel 0
7 cool Excel tricks to rock at work [Infographic]
Do you ever wonder what extra skills you can apply in Excel to speed your work up? Do you ever get tired of always getting the same Excel tricks as advice, meaning actually some VLOOKUP? So do I. This is why I was happy to find a Hubspot blog post which actually shows you some not ...

7 essential Excel tricks [Infographic]

27. October 2015 Excel 0
7 essential Excel tricks [Infographic]
It is a returning topic for anyone working with data in marketing on how to become awesome in Excel. There are many collections of the key tricks and I have already shared some myself. Nevertheless many of them are really not touching those small tools which can become the tipping point in speading up your ...