Organizing and Editing D2L Intelligent Agent Exports in Excel

From Jennifer Wagner November 18th, 2023

60 plays 0 comments

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.

Tags: intelligent agentsd2lpower queryexcel

Appears In: Public Media

Comments
Related Media

Add a comment

Organizing and Editing D2L Intelligent Agent Exports in Excel

Related Media