IOFM Spring Conference and Expo

May 19-21, 2024 |  Disney’s Yacht and Beach Club Resort  |  Lake Buena Vista, FL

Agenda Session

Automating Everyday Processes with Power Query in Excel

May 20 2024

1:10 PM - 2:00 PM EST

Gathering and preparing data can be a tedious, thankless task. Microsoft’s Power Query tool that was added to Excel aims to cut a majority of the time and effort spent on that – and it’s also in all Microsoft’s other data handling applications! In this session, we’ll introduce you to the power that Power Query can bring to your everyday efforts.

Topics include:

  • Automating the insertion of new data
  • Cleaning problem data
  • Replacing macros with button-press automations
  • Building a new data culture within your organization

Speakers

Knack Training

- Principal

© Diversified Communications. All rights reserved.