INTHEBLACK October/November 2024 - Magazine - Page 58
WORK SMART
SUBSCRIBE
EXCEL TIPS
to the podcast
POWER QUERY
USER INTERACTION
NEALE BLACKWOOD CPA
Power Query allows you to easily import data into
Excel. Discover how to make your Power Queries
more interactive and flexible with range names.
Power Query does not have any in-built interaction features, as it is
designed to be an automated process. In Excel, range names can be
easily created and imported into Power Query to add user interaction.
Adding user interaction makes delegation simpler as the user only
needs to update cell entries and not edit queries.
Read the full article
Power Query user interaction
INTHEBLACK, Neale Blackwood CPA: Excel Tips – Power Query user interaction
CLICK TO LAUNCH VIDEO IN A NEW WINDOW
58 INTHEBLACK October/November 2024
UPSKILL
with CPA Australia’s
Excel in-person
workshops and
virtual classrooms
