08 6210 8500
If you have a bunch of Excel files that all have the same structure, you can easily pick a table name, sheet name or range name that exists in all of them and read that one item from all workbooks into a single table using Power Query. It's an incredibly useful tool for situations such [...]
Move over Siri, Alexa Get information from your Power BI reports faster by using your voice. Excel file to a voice generated Power BI Mobile report. Learn how in less than 7 minutes! Here's how to build a voice generated report on a mobile starting with Excel and ending in Power BI Mobile . It [...]
Loading 10 million rows of data into Excel We believe it's important that business users of Excel understand what it's truly capable of. Only then can they make informed decisions about if/where to invest in new software, what staff training is required and how the business can be more efficient. Excel is capable of dramatically [...]
VLOOKUP v INDEX MATCH - You decide Let's think of VLOOKUP as a screwdriver and INDEX MATCH as a power drill... wait...wait.... I'm not saying INDEX MATCH is faster than VLOOKUP that isn't what this analogy is leading to. If I need to screw something together I just pick up the screwdriver and hey-presto done. [...]
Percent of Group in Power Query (plus an Excel Table version) Power Query saves you days of time manually manipulating messy data. This leads to improved productivity and efficiency. A quick tip to save you time is to generate a % of group total. It's relatively straightforward in Excel, but it's trickier in Power Query. [...]
Connect to Excel files using Power Query Power Query can connect to Excel files held in OneDrive for business and in SharePoint. But it's not obvious how. Whether you use Excel or PowerBI this approach will work. Also, for a pure "M" code approach to SharePoint you can use something like this to get your data [...]
Microsoft UserVoice We all want to make Excel and Power BI better. There are new features we'd love to see, and there are existing issues we'd like to fix. Microsoft are listening to users expressing their views via voting on the UserVoice sites. Vote for the features you want A number of experts (including our [...]
Every Excel Power Pivot Model or Power BI Desktop file needs a Calendar. With the addition of a Calendar to your Data Model you can start to do all sorts of useful analysis such sorting the data by Fiscal month and Fiscal Year or performing calculations such as TotalYTD, Year On Year Growth, [...]
Power Query is the greatest addition to Excel in 10 years, it's amazing at extracting and transforming data ready for you to use in a report. In this two minute video we show you how easy it is to extract the data you need without using any formulas! Find out more Extract and clean your [...]
This 3 minute video shows how easy it is to link to web page data with Excel. In this scenario it's connecting to the Reserve Bank of Australia exchange rates web page. Get & Transform is built into Excel 2016. It was previously known as Power Query and is still a free download for Excel [...]
Excel and Power BI are amazing analysis and data visualisation tools. Knowing what's possible is just the beginning. You can see the possibilities in this video recently recorded at the Microsoft Studios in Seattle. The speed of change and capabilities of Excel and Power BI are dizzying. The benefits of learning these technologies will save [...]
Excel or Power BI - where to start? So... Excel has Power Query and Power Pivot built in. Power BI uses the same technology. So which one should you learn first? I say which should you learn "first" because if you learn one it's a relatively small step to learn the other 2 Questions: 1. What's your aim? [...]
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
