08 6210 8500
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 [...]
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 [...]
Contact us today to learn more about our Power BI training options
Notifications
Pay my invoice
