08 6210 8500
Pay my invoice
Where is my Teams recording saved?
by Wyn Hopkins Teams Meeting Recordings A quick bonus video explaining where you now find your Microsoft Teams meeting recordings.
Using Power Query to Consolidate Multiple Files from a Folder
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 [...]
Power Query Simple Documentation Tips
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!
Power BI Hidden Gems
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 [...]
Consolidate Excel worksheets with Power Query
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 [...]
The Spare Seat Assigner
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 [...]
Power BI & Teams – granting access
by Wyn Hopkins Granting access to reports Adding a Power BI report to Teams is straight forward, but granting access can be a challenge. For more on this topic check out our blog article Securely sharing Power BI in Teams
Brief guide for Power BI users
by Wyn Hopkins Brief guide for Power BI users A brief guide for users of Power BI reports. This is a brief guide for users of Power BI reports and not a guide on how to build Power BI reports. This is aimed to help users of Power BI dashboards and reports to understand how [...]
Top tips for Power Query Data Types
by Eric Marshall Assigning Data Types Assigning data types is an essential step when working with Power Query in Excel or Transform Data in Power BI Desktop. Here are some useful tips on how to change data types while maximising the efficiency of your models: Tip #1: Don’t Change Types Until the End of a [...]
Multiple Teams logins with Edge Chromium
by Wyn Hopkins How to handle teams when you have multiple different logins Often people are required to be part of "Teams" in organisations other than their own. The desktop app is OK at allowing you to switch between different organisations if you have the same email address for all teams. The trouble starts when [...]
Create Power BI Themes
by Wyn Hopkins Create Power BI themes using the Adobe colour wheel You can create your own Power BI Themes but knowing what colours to use is a challenge. Adobe colour wheel can help. Want to learn more? Jump on to one of our courses We've trained over 1,000 people from all types of [...]
Excel tips & tricks to boost productivity
by Wyn Hopkins Boost your productivity with these shortcuts With over 20 years' experience in Excel we've picked up a few tips and tricks. We'll show you the shortcuts, features and formulas that will speed up your daily use of Excel. From SWITCH to Dependent Drop downs, Grouping to Conditional Formatting, clever validation lists and [...]
