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.
In this video we cover everything percentages, being the go to guide for all of your essential percentage calculations.
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 demonstrate how to quickly and easily transpose data using Excel VBA...
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 take a look at working with number inside table visuals.
In this video we look at how you can use data tables in Power BI to display and summarise your data.
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!
This video serves as part two of our previous video looking at creating your first Userform.
In this video we create our FIRST Userform using VBA.
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.
