by Wyn HopkinsThe Easiest Multi-Dependent Dropdown You've Ever Seen in ExcelIf you've ever needed row-by-row dependent dropdowns in Excel — where each row can have its own independent selection across multiple levels — you've probably found most solutions clunky, formula-heavy, or fragile. This one is different. And honestly? It might be the simplest approach you've ever seen. 🤔You might like to check out our Online Professional Excel [...]
by Wyn Hopkins Exciting News: Unlock the Power of AI with our GPTs – Now Available for Free! An exciting announcement from Open AI recently, GPTs (Generative Pre-trained Transformers) are now available for free in the store! These GPTs are simply predefined prompts refined through trial and error to help you achieve more with ease. [...]
by Wyn Hopkins Setting up a free Personal Power BI / Fabric Account Do you want to try out the Power BI / Fabric Service (PowerBI.com) or share your portfolio of reports with potential new employers? If you have a PowerBI.com account then you can use the Publish to Web option to share your [...]
by Wyn Hopkins The Challenge... In this month's challenge, you need to combine any non duplicate items into a single cell for each client ID#. e.g. Client ID1 has 2 rows. All entries need to be combined to return 1 row for Client ID 1 so for example the two Phone Numbers: Phone 1 and [...]
by Wyn Hopkins The Challenge... Download the file Thanks for taking part and here's our solution Submissions can still be viewed here.
by Wyn Hopkins Instant Analysis with Code Interpreter and ChatGPT Take 8 Excel files, write 2 instructions ( 25 words in total ), done…data summarized and charts built! Go to OpenAI.com GPT -4, enable Code Interpreter Write 1 sentence and upload folder of data (do not use sensitive data) Here’s the content of the zipped [...]
by Wyn Hopkins Streamlining Power Query Code Documentation with GPT-4: A Game Changer Watch my explanation or read on if you prefer... Introduction As Power BI and Excel developers, we often find ourselves knee-deep in lines of code. Writing, cleaning, documenting, and renaming steps - it can all be quite time-consuming. The game has [...]
Dynamic Data Validation with Tables in Excel For single dependent drop downs check out our video HERE For multi-row multi-level drop downs you can check out our blog post and video HERE Check out our YouTube channel with weekly videos dedicated to Excel, Power Query and Power BI If you're [...]
by Wyn Hopkins The Challenge... School’s almost out for summer (well in Australia anyway)… how has everyone done in their exams? Who had the highest average score for each day? How can we tell? We need to sprinkle on some Power Query Magic dust! *Don't forget to make your solution flexible so that if more [...]
by Wyn Hopkins The Challenge... Our Solution... Convert Range of Values to a List - Power Query Challenge youtu.be Your Solutions... Some of the solutions we received can be viewed here along with the original challenge: Power Query Challenge Tickets to Rows
by Wyn Hopkins Creating a Merge Duplicates Alert This challenge is how to warn the end user that duplicates exist The Challenge... Take the challenge with our free download And if you would like us to have a look at your solution e-mail it to info@accessanalytic.com.au
by Wyn Hopkins The Challenge: Hours from Start and End Assume Start Time and Stop Time are always whole hours Solution must handle new rows of data being added to the source with new staff names Remove any records marked as "exclude" in the Status column (handle upper case / lower case typos) Our approach... [...]
Contact us today to learn more about our Power BI training options
08 6210 8500
