Power BI or Excel VBA?

Power BI or Excel VBA?

What is the purpose and difference between Power BI and Excel VBA * When to use what * Or maybe you can use both? * Here is my take on the role Power BI and Excel VBA can play in your setting. Lucien, one of the professional Excel VBA experts following my Blog and...
Staging Data in a Dynamic Report with Excel VBA

Staging Data in a Dynamic Report with Excel VBA

When preparing a dynamic report in Excel, you need to arrange the data in the report structure. In this Blog post I demonstrate how to clear the report range and re-populate it with data. Types of reports Reports can take many forms, as far as presenting data is...
The Excel Dashboards Guide: The Visual

The Excel Dashboards Guide: The Visual

How should a dashboard strategy be conceptualized? How do you translate the accumulated data into an effective business compass for the decision maker? Start your journey here We planned our Dashboards and prepared the data. We’re now ready for the artistic magic: the...
The Excel Dashboards Guide: Data Staging

The Excel Dashboards Guide: Data Staging

How should a dashboard strategy be conceptualized? How do you translate the accumulated data into an effective business compass for the decision maker? Start your journey here After we have finished all the preparations for our Dashboard in the previous Blog post of...
The Excel Dashboards Guide: Planning Considerations

The Excel Dashboards Guide: Planning Considerations

How should a dashboard strategy be conceptualized? How do you translate the accumulated data into an effective business compass for the decision maker? Start your journey here ? In the previous Blog post we understood the main aspects and types of Dashboards. In this...