Access Analytic
Amazing Excel and Power BI Solutions. Perth, Western Australia. Our aim is to help you make decisions with confidence.
Let us know if there's topics you'd like to cover and please subscribe and click the notification item to keep informed when we release new videos.
About Us...
Jeff Robson, Wyn Hopkins are the directors of Access Analytic
Jeff is the founding Director and Principal Business Analyst at Access Analytic Solutions. He has over 20 years’ experience in chartered accounting, business management and consulting.
Wyn is a Microsoft MVP and was once upon a time a Chartered Accountant with PricewaterhouseCoopers in the UK.
He published the book Power BI for the Excel Analyst (a beginners guide to Power BI) in July 2022: https://pbi.guide
Find out more about us and the team here https://accessanalytic.com.au/about-us-2-2/
Both Jeff and Wyn would love to connect up with you on LinkedIn
https://www.linkedin.com/in/wynhopkins/
https://www.linkedin.com/in/jeffrobson/
Header Promo Trick
The Safest Way to Build Excel Dropdowns.
Stop wasting time and set up an auto launch template with critical common features #Excel
How to Instantly Build Pivot Sheets for Every Manager in Excel
UNPIVOT in Excel Without Power Query? YES, With This Function!
2D LOOKUP and the BYROW function
Approximate Lookup in Excel - XLOOKUP and POWER QUERY!!!
How to Compare 2 Lists in Excel with a single formula!
ULTIMATE Guide: Combine Files from OneDrive & SharePoint (2025 Update!)
Split it Out Power Query Challenge
Unboxing 100K Subscribers Award ( plus new Course Announcement)
Simpler DAX? Power BI Visual Calcs: How to flag a high point
Why Microsoft PowerToys Is the Best Free Tool You’re Not Using!
How to use CHATGPT to do Excel REGEX and is TRIMRANGE useful?
Make Your Power BI Tooltips Smarter with This Simple Trick!
When is a space not a space? When Power Query Clean Fails.
Power Query - Remove Top Rows dynamically - how did I not know this?
How to consolidate multiple Excel files with multiple sheets - Easy and Tricky examples
Power Query Lists & Records - Pro Skills
Power BI On Object Interaction - Boosting Efficiency or still too flawed?
List Compare in Excel with FILTER XMATCH
How to set up Microsoft Fabric
Excel Avoid Offset and use RowAbove
How to Identify Rows with Missing Values using Power Query
How to Stop Excel changing text to dates and removing leading zeros
5 Excel Tricks They Won't Believe
Power BI Header Icons - TURN OFF
USERELATIONSHIP and multiple dates in Power BI
Excel Table Traps: Avoid Common Excel Pitfalls with These Tips!
THE Easiest Multi Level Drop Down List ( easy Double XLOOKUP technique )