08 6210 8500
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 [...]
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 [...]
Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.
Get Ahead of the Game – Book Your Training Now!
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.
Pay my invoice
