Do you have thousands of records contained in a multitude of files that sit in a folder and sub folders? Microsoft's Power Bi handles this with ease. Point to the folders (and sub folders), decide which columns of data you want, whether you want to combine, split, cleanse or convert data and Power Bi will do the rest for you time and time again. Take in the data from thousands of files in seconds! #trainingcourse #microsoftpowerbi #financialmodelling #excel
When you're providing products or services in a long term relationship there is usually a contract which will typically…
Smart use of Excel (or other Office applications) should feature use of templates. In a business those templates should…
[This is a follow up to the article "Why Random Access Files" (in VBA)] Random Access Files work because, unlike…
Why/when would you use Random Access Files in VBA? Ironically they're hardly random! They're very specific but not…
Multibillion-dollar investments in the resources industry will continue despite the mining boom being over, Diggers and…
I've often thought that Post Codes in Australia in particular needed a drastic overhaul so that postcodes could be…
It is a tough world out there and businesses often give away every single advantage they have to win work ..