08 6210 8500
By Robert Hind Does your contract Rise and Fall let you down? When you're providing products or services in a long term relationship there is usually a contract which will typically include an Escalation (Rise and Fall) formula. The intent of the Escalation Formula is that cost increases or decreases should be passed on so [...]
By Wyn Hopkins Power Query and a Key Word search (Episode 1) This demonstration came about due to a real life scenario where I needed to categorise a transaction listing (like a bank statement for example) so that I could generate a summary report of categories of spend. All sorts of tips can [...]
By Eric Marshall Get more out of Power BI Slicers The slicer visual in Power BI is a simple, yet powerful means of selecting criteria to filter your reports. Here are two useful tips on how to get more out of this visual: Tip #1: Turn Off Single Select By default, Power BI slicers behave [...]
by Robert Hind Use Shared Excel Templates Smart use of Excel (or other Office applications) should feature use of templates. In a business those templates should be "Workgroup" templates (common templates available across the business). Workgroup templates offer Efficiency, Consistency, Accuracy, Automation and Professionalism. The purpose of this article isn't to expand on the importance [...]
by Wyn Hopkins Power Query and a file selector Macro If you have an Excel file containing Power Query and need to send it to colleagues, read on. If they need to be able to change where the source data for the Query is being pulled from then read on. If you [...]
By Wyn Hopkins Adding a password box to a Power BI report Here’s a process that allows you to add a password input box to your Power BI report. DO NOT, REPEAT DO NOT use this for sensitive data. We have no idea if there are ways to hack this but it’s just an interesting [...]
By Wyn Hopkins If you find the default Icon settings confusing in both Excel and Power BI, you're not alone! In July 2019 conditional formatting Icon Sets were added to Power BI and it caused us to revisit how they work in Excel. In Excel you would highlight a range of numbers and choose Conditional [...]
5 Great Excel tips from 5 Excel MVPs Want to learn from the best? Jump on to one of our courses
How to create a dynamic drop down list in Excel - with WARNINGS! Want to learn more? Join one of our courses
Excel Summit South is hitting Perth The biggest Excel event ever to hit Perth is coming on the 8th & 9th of August 2019. If you love Excel or want to make the most of the technology your organisation is already paying for then you cannot miss out on this. Multiple MVP's and Microsoft staff [...]
SQLSaturday training event Access Analytic is once again happy to be involved in SQLSaturday. This event brings together Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business Intelligence and Analytics. To find out more visit SQLSaturday here.
Power Pivot basics plus a Power Query technique for handling awkward data Something for everyone in this video, showing how to take awkward source data, transform it using Power Query and produce an interactive variance report in Power Pivot. The pre-built template we used is available for free from our website along other cool downloads [...]
Pay my invoice
