08 6210 8500
Navigating the New Normal: Why CFOs are embracing Data Analytics and Power BI The role of the Chief Financial Officer (CFO) has never been more complex or challenging. Driven by many interrelated factors such as rapid technology change, changing consumer expectations and regulatory shifts, Perth CFOs are turning to data analytics to help them navigate [...]
by Wyn Hopkins Setting up a free Personal Power BI Account Do you want to try out the Power BI 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 reports, but signing up [...]
10 Ways to Know If Your Budgeting Process Flow Is Broken Discerning professionals know that efficiency is the key to business success in 2024. According to Forbes media, efficient processes are vital at every stage of your operation, including budgeting. Is your budgeting process slow, exhausting and stressful? Do you wonder why you always find [...]
Complete guide to making faster, better decisions with Solver The speed of making decisions matters. Small delays compound and cost money. The right decision at the right time can be a game changer for an organisation, so the pressure for CFOs and Financial Managers to make that decision quickly is immense. In this article, we [...]
Unleash the Power of Cloud-Based Budgeting & Forecasting Software In the dynamic landscape of modern business, cloud-based budgeting and forecasting software emerges as a set of indispensable tools for organisations aiming to stay ahead of the curve. Here at Access Analytic, we recognise the critical importance of efficient financial management in achieving sustainable growth and [...]
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 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 Welcome...this is an older post, you may be more interested in newer, more up to date techniques... 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 [...]
by Jeff Robson Supercharge Your Workflow: Integrate ChatGPT Prompts with your data in Excel, Word & Outlook with a Single Click! Introduction You often do the same kinds of things in Office. You can now automate these processes and integrate your data with pre-written ChatGPT prompts with just one click. Before diving [...]
Pay my invoice
