08 6210 8500
by Wyn Hopkins Combining Multiple Files from a Folder How to use Power Query for Excel and Power BI to consolidate multiple files into a single table of data, whether you're using OneDrive , SharePoint or a traditional network folder. As well as showing the basic steps, this video explains the inner workings of the [...]
by Wyn Hopkins Simple documentation tips when using Power Query Whether it's Power BI, Excel or Dataflows, adding some helpful indicators, documenting and renaming applied steps can be really helpful. Be kind to your future self!
by Wyn Hopkins Consolidate multiple Excel worksheets using Power Query A common request on forums and in the training classes we run is "how do I consolidated multiple sheets into a summary?" Power Query can do it, I step you through how I would approach it. Techniques covered include: Creating a custom function (via the [...]
by Wyn Hopkins Excel Hash 2021 A bit of fun to be had and a challenge set by fellow Excel MVP Oz du Soleil. Finding a solution to the spare seat assigner. Our solution incorporates the following items: 1. Cutout person 2. Pick at least 2 from the following list: LET, LAMBDA, Dynamic Arrays, Power [...]
Contact us today to learn more about our Power BI training options
Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”. He is known worldwide for sharing his knowledge via the Access Analytic YouTube channel with over 5 million views and 90,000+ subscribers.
He gained his Chartered Accountant qualification at PwC in 2000 and has extensive Business Analyst experience with HBOS and Barclays in the UK plus multinational clients in Perth.
Wyn is skilled in Excel and Power BI development, Power Query automation, management reporting and is an experienced Excel and Power Bl trainer.
Notifications
Pay my invoice
