In this video we continue from our last tutorial in which we used a VBA array to transpose some source data, this video demonstrates how a few extra lines of code will allow you to quickly reorder your columns as required.
In this video we take a look at Charts in Power BI and the features we have available. Once you grasp the basics of working with Charts you will see how easy they are to create within Power BI.
In this video we introduce working with multiple data sources in Power BI (in this example from Excel) and demonstrate how to connect each of these sources to form a larger dataset for reporting... best part is Power BI can do this automatically for you!
Continuing our look at change events I wanted to complete the cycle by including this look at how to trigger a macro to run each time a workbook is closed.
Pulling on some of the techniques learnt in previous videos within our Excel VBA series, we create an Audit Trail Log that enables us to capture both the username and date / time for every user that saves our file.