08 6210 8500
by Wyn Hopkins Learning Dynamic Array formulas in Excel by building Wordle This video shows the use of Dynamic Array formulas # references, XLOOKUP, SEQUENCE, MID, TODAY and some conditional formatting. Click on the file below to play along! Download a copy of the file we used below:
by Wyn Hopkins Select Range and Convert To kick off 2022 we thought we would put this Power Query challenge to you: Select Range and Convert to required result Solution should work when dates, codes, colours wording or numbers in Value column change Note the colours in the Required Result are for guidance purposes only [...]
by Wyn Hopkins Columns to Rows and Rows to Columns Challenge In this month’s challenge we have a couple of key challenges to face: We have a double row heading, the top row of which is merged These merged “Department” headings need to become row items and we need to filter out variance We have [...]
by Wyn Hopkins Insert Blank Rows with Power Query Power Query in Excel can be used for so many purposes and converting data ready for upload into another system is just one. In this scenario we show you a couple of techniques to insert a row for each change in a group of items. Did [...]
by Wyn Hopkins Challenge of the month - Flex your Power Query Skills From time to time, we post fun, technical challenges in Excel & Power BI. For this one, take the source data in the blue table and turn it into the format shown in the green table. Your solution needs to automatically handle [...]
by Wyn Hopkins SquareWars - A Fun Way to Learn Excel 365 Here’s a fun way to learn a few Excel 365 functions and challenge a colleague to a friendly game at the same time.. Aim Leave your opponent with the last square and you win! Rules Take turns to enter your sequence of numbers [...]
by Jeff Robson Challenge of the month - Flex your Power Query Skills From time to time, we post fun, technical challenges in Excel & Power BI. In this one, you start with a dataset where every second row is data and the rows in between are column headings. Can you turn this into two [...]
by Wyn Hopkins Teams Meeting Recordings A quick bonus video explaining where you now find your Microsoft Teams meeting recordings.
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 Tips & Tricks to using Power BI There are several tricks to using Power BI that aren't always obvious. In this video we show you some of the hidden gems: Create a Measures Table Create Folders for your Measures Drag Measures between Tables (and Folders) Add brackets to negative numbers Consolidate multiple [...]
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 [...]
Pay my invoice
