08 6210 8500
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 Say my name, say my name When you're working with data from Excel in Power Query, column names can often change, new columns can be added and columns can be deleted. Excel users don't think twice about doing any of these things as they all seem quite normal and logical however they [...]
By Jeff Robson Use this Excel Skills Assessment spreadsheet to check how much you know about Excel. Simply go through each step in our self-assessment ExceleRater tool and tick the areas you are familiar with. At the end, you'll see your score and can tell what level you're at.
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 Jeff Robson Fixed vs Variable Loan Products ... which is best? It can be difficult to compare fixed vs variable loan products. Banks often market loans with fixed interest rates using the selling point of certainty: "you'll always know what your repayments will be". Check the fine print! While certainty can be somewhat attractive, [...]
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 [...]
Pay my invoice
