08 6210 8500
by Wyn Hopkins 5 Excel Tricks They Won't Believe Get ready to amaze your coworkers with five next-level Excel tricks that blend creativity, logic, and a touch of holiday fun. These aren’t your standard tips—they’re designed to make you look like a spreadsheet wizard. Not only will I walk you through each trick, but I’ll [...]
by Melina Louzada Excel Office Scripts for Effortless Data Movement Welcome to the world of streamlined efficiency with Excel Office Scripts! In this blog, we dive into the transformative power of automating your Excel workflows, specifically focusing on a scenario many of us encounter: managing and organizing current and completed records in an Excel file. [...]
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 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 [...]
Power Query is an amazing tool for cleaning and transforming your data to make it ready for analysis in Power BI or Excel. Here are 5 useful hints to help you use Power Query more effectively: Hint #1 – Use the Formula Bar The Formula Bar helps you quickly understand which step you have previously [...]
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 [...]
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
