5 Excel Tricks to Wow Your Colleagues

by Wyn Hopkins 5 Excel Tricks They Won't Believe Get ready to amaze your coworkers with five next-level Excel tricks that blend creativity, logic, and a touch of holiday fun. These aren’t your standard tips—they’re designed to make you look like a spreadsheet wizard. Not only will I walk you through each trick, but I’ll [...]

Refreshing Power BI Reports with a Button Using Power Automate

Refreshing Power BI Reports with a Button Using Power Automate By Simone Palmas Want to keep your Power BI reports up-to-date without waiting for scheduled refreshes? Now, you can manually refresh your report directly from the report interface using Power Automate. Below, Access Analytic team member Simone Palmas has created a step-by-step guide to set [...]

2024-11-28T08:58:55+08:00Power BI|

How to Create an Advanced Filter in Excel without Macros

How to Create an Advanced Filter in Excel without Macros By Simone Palmas Want to filter your Excel data efficiently without using macros? Filtering data can sometimes feel restrictive, especially when you want to search for multiple words independently of their order or the specific columns they might appear in. Access Analytic team member, Simone [...]

2024-11-20T11:49:39+08:00Excel|

Mastering Dynamic Measure Formatting in Power BI | Part 4: Dynamic Formatting Based on Value Ranges

Mastering Dynamic Measure Formatting in Power BI | Part 4: Dynamic Formatting Based on Value Ranges By Melina Louzada You've made it to the final part of our blog series on mastering dynamic measure formatting in Power BI! If you're joining us now, you can catch up with Part 1 here, Part 2 here, and [...]

2024-11-20T11:38:25+08:00Power BI|

Mastering Dynamic Measure Formatting in Power BI |Part 3: Using SWITCH/SELECTEDVALUE() for Dynamic Formatting

Mastering Dynamic Measure Formatting in Power BI |Part 3: Using SWITCH/SELECTEDVALUE() for Dynamic Formatting By Melina Louzada Welcome to the third blog in our series on dynamic measure formatting in Power BI! If you haven’t checked out the first two blogs yet, find Part 1 here and Part 2 here. This post will cover using [...]

2024-11-20T11:34:16+08:00Power BI|

Mastering Dynamic Measure Formatting in Power BI | Part 2: Dynamic Cell Colour Formatting

Mastering Dynamic Measure Formatting in Power BI | Part 2: Dynamic Cell Colour Formatting By Melina Louzada Welcome back to the second part of our series on mastering dynamic measure formatting in Power BI! If you missed Part 1: Flexibility with Visual Level Format String, you can check it out here and download the working file. [...]

2024-11-20T11:30:27+08:00Power BI|

Mastering Dynamic Measure Formatting in Power BI | Part 1 – Flexibility with Visual Level Format String

Mastering Dynamic Measure Formatting in Power BI | Part 1 - Flexibility with Visual Level Format String By Melina Louzada In the realm of data analysis, the clarity of data presentation is just as crucial as the data itself. Dynamic measure formatting in Power BI enables analysts to tailor data representations to enhance readability and [...]

2024-10-08T17:09:48+08:00Power BI|

Jeff’s Kokoda Experience | A Journey of Determination

Jeff's Kokoda Experience | A Journey of Determination In the heart of Papua New Guinea, where the rugged terrain of the Kokoda Track challenges even the most seasoned adventurers, Jeff, Access Analytics Founding Director, embarked on a journey that would test not only his physical limits but also his commitment to a cause close to [...]

2024-09-18T13:57:28+08:00Uncategorized|

Leveraging ChatGPT for Transformative Finance Functions: A Guide for CFOs

Leveraging ChatGPT for Transformative Finance Functions: A Guide for CFOs Technology is disrupting traditional business models more than ever and as such the role of the Chief Financial Officer (CFO) has evolved significantly. No longer limited to number-crunching, today’s CFOs are expected to play a strategic role in decision-making processes. Enter ChatGPT, a large language [...]

2024-07-29T11:22:40+08:00CFOs, ChatGPT|

How ChatGPT’s Premium Features are Revolutionising Financial Modelling

How ChatGPT’s Premium Features are Revolutionising Financial Modelling Financial modelling has long been a mainstay of the financial industry, essential for everything from risk assessment to capital allocation. Generative Artificial Intelligence (AI) technologies, like ChatGPT, are fundamentally changing financial modelling processes.  At the risk of sounding like an advertisement for ChatGPT, the premium features (e.g. [...]

Unlock the Power of AI with our GPTs – Now Available for Free!

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. [...]

2024-06-10T15:23:55+08:00ChatGPT, Excel, Power Query|

The Integral Role of Data Analytics and Power BI in Modern Strategic Planning

The Integral Role of Data Analytics and Power BI in Modern Strategic Planning In today's hyper-competitive business landscape, gut instincts and traditional methods are giving way to data-driven insights. Data analytics now serve as the backbone of strategic planning, providing companies with the hindsight, insights and foresight they require to make well-informed decisions. As the [...]

Learn from highly qualified finance professionals with international experience

Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.

Get Ahead of the Game – Book Your Training Now!