08 6210 8500
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 [...]
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
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 [...]
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 [...]
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 [...]
Tricking Non-Dynamic Array Formulas into Spilling by Jeff Robson Tricking non-dynamic array formulas into spilling isn't something you'd naturally think of doing. Dynamic Arrays are great but sometimes the formulas that refer to them behave in unexpected ways, and sometimes these don't spill ... without any obvious reason. For example, the DATE function spills, [...]
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 [...]
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 [...]
by Wyn Hopkins Power BI - Prepare for the new Ribbon Per the 2020 Power BI planned release notes the new ribbon, that has been in preview for several months, will be switched on by April 2020 for everyone. Check out the update from Microsoft here. You can turn it on now by going to [...]
by Wyn Hopkins How to use Power Query to connect to a file on OneDrive or SharePoint A growing number of organisations are starting to store their files on OneDrive for Business and SharePoint. Users will begin to discover that connecting to these files with Power Query is not as straight forward as clicking the button for [...]
by Wyn Hopkins Securely sharing Power BI in Teams Embedding a Power BI report inside your Teams channel is a great way of sharing reports and discussing them during meetings. Adding a Report to Teams To add a report, just click the + sign at the top of your Teams Channel window and then [...]
Pay my invoice
