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/
Безумный трюк с предоставлением внешним пользователям доступа к отчетам и рабочим областям Power BI
💥 НОВАЯ интеграция Power BI + PowerPoint: полная демонстрация и обучающее руководство!
Упрощенный DAX с новой функциональностью календаря — предварительный просмотр Power BI
Что лучше? Power BI Copilot против Excel Agent Mode
Режим агента в Excel Labs: наконец-то работает! Исправление + демонстрация
Excel неправильно определяет дубликаты — и как это исправить
Power Query — переименование столбца в зависимости от его положения для избежания жесткого кодиро...
Excel Agents — НЕ урок по использованию...
What are DAX User Defined Functions UDF in Power BI
Conditional Formatting tips (including how to highlight a row)
Copilot Function Excel
What are Power BI Org Apps and how to create them?
How to apply Dynamic Number Formatting in Power BI
New Power BI Service Feature: Live Power Query Editing
NEW Excel Feature: Auto Refreshing Pivot Tables
How to set up Copilot Capacity for Power BI and Fabric
Fix Excel Spill Errors FAST With This One Formula Trick!
Why Access Analytic for your Power BI Training
![How to get 6 million views on YouTube [satire]](https://ricktube.ru/thumbnail/7y3N5EzP9kw/mqdefault.jpg)
How to get 6 million views on YouTube [satire]
Multi Sheet Multi File Consolidation while avoiding Hard Coding
The Safest Way to Build Excel Dropdowns.
Set your default start up 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