Organizing and Editing D2L Intelligent Agent Exports in Excel

If you'd like to add email addresses to intelligent agent exports or generate a list of students NOT identified by an intelligent agent, you can use Power Query in Excel to organize and transform the data. This video explains how to download both the class roster and the intelligent agent reports and then load them into Power Query to build queries step by step. These queries are faster to build, run, and reuse as well as easier to update compared to using LOOKUP functions in Excel.