Parent Observer List using VLookup

admin
Community Contributor
1
1450

This is a quick demonstration of how to use the VLookup function in Excel to help combine and make sense of multiple Canvas reports (e.g: using the users.csv and user_observers.csv to create a list of observers and student they are observing)

1 Comment
vailj
Community Explorer

This is so helpful! Thank you! Is there any way to sort out or not include users who have graduated or are not active in our SIS? It looks like they don't get inactivated in Canvas