Take your Filtering to the next level with this simple technique Access Analytic Learn 2026-03-07 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.comDownloadable Workbook Here: aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/IgAkcnsnZTSkS4nhMj0SpuIzAUSW9_mYb3eEck_MWHSsWWU?e=C2NI8MFiltering data in Excel tables can often feel frustrating and time-consuming. The typical dropdown filter forces you to scroll through long lists, untick multiple items, and constantly reset filters just to find the information you need. In this video, a much smarter and faster solution is demonstrated—creating a simple searchable filter inside an Excel table that eliminates the need for tedious dropdown filtering.By adding a search column, a small formula, and a slicer, you can instantly filter results based on exact or partial matches. Using Excel features like Data Validation, the SEARCH function, and table slicers, the method allows you to quickly find matching values and even highlight issues such as missing values (N/A). The approach works particularly well in Excel 365, where dropdown lists are automatically unique and searchable. If you regularly filter large datasets, this technique can dramatically improve your workflow and make data analysis far more efficient.📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/00:00 Introduction00:32 A Better Way to Filter Excel Tables00:42 Creating a Search Column in the Table01:18 Building a Searchable Dropdown with Data Validation01:55 Adding a Slicer to Instantly Filter Results03:13 Using the SEARCH Function for Partial Matches
Remove Blanks with TOCOL Access Analytic Learn 2026-05-29 | 👩🏻🎓Do you want to learn Power BI or Pro-Level Excel techniques?Check out our amazing course at accessanalytic.thinkific.com🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
Copilot in Excel - Huge Improvement - Power Query and LAMBDA Access Analytic Learn 2026-05-06 | 👩🏻🎓Do you want to learn Power BI or Pro-Level Excel techniques?Check out our amazing course at accessanalytic.thinkific.com🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
Power BI Hack: Could this replace Dataflow Gen1 AND introduce Row-Level Security Access Analytic Learn 2026-04-29 | 👩🏻🎓Do you want to learn Power BI or Professional Excel techniques?Check out our amazing course at accessanalytic.thinkific.com🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/⏬Download PBIX containing Power Query codeaasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/IgBeHQsuiV8NRY7fzpzCYkQNAWWR2KHq0fiPPorBt_hFpAM?e=A7lM3gThis video explores an interesting alternative to traditional dataflows in Microsoft Power BI—especially as Dataflow Gen1 edges closer to deprecation. Also, Dataflow Gen1 doesn’t support row-level security (RLS), which can be problematic for some scenarios. In this walkthrough, you’ll discover a powerful workaround that leverages core Power BI functionality to not only replicate dataflow behavior but also fully respect RLS, giving users access only to the data they’re permitted to see.The solution uses a technique involving Analysis Services queries within Power Query to extract individual tables directly from a semantic model—even within Pro workspaces. With step-by-step guidance, you’ll learn how to connect to datasets, dynamically surface available tables, and enable end users to build their own reports securely. This approach opens up flexible, refreshable import scenarios while maintaining strict data governance. If you’re looking for a smarter, more secure way to manage data access in Power BI, this is definitely worth exploring.The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
How to build a TOPN and Other formula in Excel Access Analytic Learn 2026-03-19 | 00:00 Build Top N + Other Formula Overview01:04 Group By Function Setup02:38 Extract Top N & Calculate “Other”04:27 Combine Results with LET Function08:09 Create Reusable LAMBDA Function12:05 Advanced Version with Options & Enhancements14:46 Importing Formulas & Final Thoughts
Supercharge your Excel Filtering: REGEXTEST Tricks You Need to Know Access Analytic Learn 2026-03-12 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/joinDownload the File:aasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/IgAZRgHX7tGcQ53RRYTxdeQvAT8nPTb4U4GcjVKIOiyVUEM?e=49680LThe Previous Videoyoutu.be/uKRPZGi64dM?si=EjnAVA9ReqUbtZ9C📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/00:00 Introduction00:44 Using REGEXTEST Instead of Complex Formulas01:01 Creating Multiple Matches with TEXTSPLIT03:04 Fixing Spaces with TRIM for Accurate Matching04:18 Simple Partial Matches Using REGEXTEST05:52 Multiple Partial Matches with REGEXTEST + Lists07:03 Using REGEX Patterns for “Begins With” Searches
Convert XLS to CSV using Microsoft Fabric Access Analytic Learn 2026-02-19 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/Python Notebook Scriptaasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/IgBDol7esJcXTJ56bjrvDmAKAaiHMsaHidJfJY2U70zDqpQ?e=nRXuCxThe team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
How to Sort Columns Alphabetically in Power Query (Old & New Method!) Access Analytic Learn 2026-02-13 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/joinAfter 10 years of using Power Query, there are still new tricks to discover—and this one is surprisingly simple but incredibly useful. In this video, you’ll learn how to sort columns alphabetically in Power Query using both the classic desktop method and the newer modern interface. Whether you're building custom columns or just want a cleaner, more organised query layout, this quick tip can save you time and frustration.But that’s not all. You’ll also discover why the traditional “Choose Columns → Sort by Name” trick doesn’t work in Dataflows or Excel Online—and what to do instead using Schema View. Plus, for those who want a fully dynamic solution, the video walks through how to use M code (including Table.ColumnNames and List.Sort) to automatically sort columns every time your data refreshes. Simple hack, modern workaround, and advanced dynamic method—all in one practical tutorial.📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
The Power BI Sort By Column Trap Access Analytic Learn 2026-01-22 | 📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
Sort Columns easily with Power Query Schema View Access Analytic Learn 2026-01-15 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.comMiguel Interview: youtube.com/watch?v=kiouWVbc1tM📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
Power Query Online Trick: Import Without “From Table/Range” Access Analytic Learn 2026-01-08 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
Are Excel Visuals Awful? Access Analytic Learn 2026-01-06 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
Fix the SharePoint File Consolidation Bug in Excel Online (Quick & Easy!) Access Analytic Learn 2025-12-31 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
Full Power Query Editor in Excel for Web!! Access Analytic Learn 2025-12-24 | 📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.comMicrosoft DocsOfficial link: support.microsoft.com/en-us/office/use-power-query-in-excel-for-the-web-02652946-de70-48d8-8a34-3db96998ff5aMore from Wyn:Power Query Playlist: Power Queryyoutube.com/playlist?list=PLlHDyf8d156UFChHzgQIO2cdaNqOS8KX3The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join
What is the Power BI MCP Server? Access Analytic Learn 2025-12-18 | 📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.comDocumentation:Overview: learn.microsoft.com/en-us/power-bi/developer/mcp/mcp-servers-overviewModelling MCP: github.com/microsoft/powerbi-modeling-mcpClaude _Desktop_Config.json{"mcpServers": { "powerbi-modeling-mcp": { "type": "stdio", "command": "C:\\MCPSERVERS\\PowerBIModellingMCP\\extension\\server\\powerbi-modeling-mcp.exe", "args": [ "--start" ], "env": {} } }}🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/00:00 Introduction02:30 Functionality Demo06:00 Options for Installing the MCP Server06:40 Visual Studio Code Install08:20 Claude Desktop Install12:18 Recap, Final Thoughts & Shout Out
How to Hide Power BI Pages from End Users Dynamically - Page Level Security ??? Access Analytic Learn 2025-12-10 | 🧑🏻🎓Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.comLearn how to customize Power BI report visibility for different users using slicers, buttons, and Power Query. While this method improves user experience, it’s not secure for sensitive data, and the video also explains why.📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/Download the PBIX fileaasolutions.sharepoint.com/:f:/s/PubliclyAvailableContent/EovZ02Zd2ENJqn1gSxUyUekBBnIl1f9JW38frUqXp5Y2mg?e=hfe4eI00:00 Introduction00:05 Demo: User-Based Page Access with Checkboxes01:00 Why This Isn’t Secure01:43 Power Query Setup for Page Access04:00 Styling Slicers and Button Navigation06:30 Creating Dynamic Buttons with FX09:53 Setting Up Page Navigation Logic10:33 Role Level Security Setup with DAX13:00 Real Security: RLS and Object Level Security
The crazy trick to giving External Users access to Power BI reports and workspaces Access Analytic Learn 2025-11-27 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/00:00 Introduction00:44 The one admin setting you must enable01:48 Why direct report sharing fails02:01 The dashboard trick to enable external sharing03:49 Guest user shows up in Azure and 36504:27 Sharing the report after guest access is granted05:15 Assigning licenses to external users06:15 What the guest user sees07:32 The more formal way using Azure portal07:47 Final thoughts and alternate method using apps
Sadly this mistake is common #Excel Access Analytic Learn 2025-11-18 | Sadly this mistake is common #Excel
Do managers care about what you do? Access Analytic Learn 2025-11-17 | Do managers care about what you do?
💥 NEW Power BI + PowerPoint Integration: Full Demo & Tutorial! Access Analytic Learn 2025-11-13 | 📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.comThe video walks you through embedding visuals, setting secure vs. public snapshots, and toggling between live and static modes. You'll also learn how to install the Power BI Controller add-in and use it to control multiple visuals at once. Whether you're presenting to clients, executives, or stakeholders, this tool makes your presentations more powerful, more secure, and dramatically easier to manage.🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/00:00 Introduction00:24 What the Power BI Controller Add-in Does00:36 Inserting Power BI into PowerPoint00:57 Copying the Power BI Report URL01:13 Permissions and Security Options01:32 Interactivity and Viewer Access01:51 Embedding a Single Visual02:07 Using “Open in PowerPoint”02:17 Pasting and Inserting the Visual02:34 Master Report Setup in PowerPoint02:40 What is the Power BI Controller Preview?03:01 Installing the Power BI Controller Add-in03:18 Switching Between View Modes03:52 Applying Secure Snapshot Mode04:30 Switching Back to Live Data05:01 Resetting & Syncing Power BI View05:18 Final Thoughts and Membership Thanks
How many times are you re-typing data? Access Analytic Learn 2025-11-12 | How many times are you re-typing data?
Dataflow Intellisense #powerbi #dataflow #microsoftfabric Access Analytic Learn 2025-11-11 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
Forget Big data, start with clean data Access Analytic Learn 2025-11-07 | Forget Big data, start with clean data
Power Query Quickest Column Order Hack Access Analytic Learn 2025-11-06 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
Forget Big data, start with clean data Access Analytic Learn 2025-11-06 | Forget Big data, start with clean data
Can you guarantee your spreadsheet is error free? Access Analytic Learn 2025-11-04 | Can you guarantee your spreadsheet is error free?
Whats the biggest Excel error youve seen? Access Analytic Learn 2025-11-01 | What's the biggest Excel error you've seen?
Excel can handle 20 Million records Access Analytic Learn 2025-10-31 | Excel can handle 20 Million records
Simpler DAX with New Calendar Functionality - Power BI Preview Access Analytic Learn 2025-10-29 | Marco Russo's deep dive: youtu.be/navOO4GcRyk&list=PLlHDyf8d156VDobBIk13o4mZLk19DbV81🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join🧑🏻🎓Learning Power BI?Check out our online courseaccessanalytic.thinkific.com📗 Did you know I've written a book "Power BI for the Excel Analyst"?https://pbi.guide/book/The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
How Microsoft beat the competition Access Analytic Learn 2025-10-29 | How Microsoft beat the competition
What are you missing in Power BI? Access Analytic Learn 2025-10-28 | What are you missing in Power BI?
Is Excel dead thanks to Power BI? Access Analytic Learn 2025-10-27 | Is Excel dead thanks to Power BI?
Which is better? Power BI Copilot v Excel Agent Mode Access Analytic Learn 2025-10-23 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/00:00 Introduction00:34 The Prompt: Creating an Insightful Report01:08 Setting Up Power BI and Excel Copilot02:00 Power BI Builds Report Instantly04:00 Excel Dashboard Starts Taking Shape05:01 Power BI's Flaws Begin to Show07:45 Excel’s Analysis Goes Deeper10:57 Excel’s Insights and Calculations Explained12:11 Final Verdict
Agent Mode in Excel Labs: It Finally Works! Fix + Demo Access Analytic Learn 2025-10-21 | 🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📊Do you want to learn Power BI?Check out our amazing course at accessanalytic.thinkific.com📗Prefer reading a book to learn then check out "Power BI for the Excel Analyst" by Wyn Hopkins https://pbi.guide/book/The team at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/00:00 Introduction01:58 Fixing Excel Labs Agent Mode: Uninstall & Reinstall03:00 Testing Agent Mode with a Movie Table Prompt04:10 Agent Mode Generates Reasoning & Table Structure05:05 Adding Conditional Formatting for Morning Start Times06:45 Understanding Excel’s Use of MOD for Time Handling07:50 Final Thoughts & Impressions
Why you should never hide columns Access Analytic Learn 2025-10-19 | Why you should never hide columns
Excel Gets Duplicates Wrong - and how to fix it Access Analytic Learn 2025-10-15 | 🧑🏻🎓Learning Power BI?Check out our online courseaccessanalytic.thinkific.com🫶🏻 Join the channel to get access to perks:youtube.com/channel/UCvD2rJJrp0aS48-KCk0eMHQ/join📗 Did you know I've written a book "Power BI for the Excel Analyst"?https://pbi.guide/book/The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. 🌐 https://accessanalytic.com.au/
