fbpx

Recently in a class I had someone who had to track attendance over a number of days training via a bunch of Zoom Emails. This link shows you how you would extract a list of attendee email addresses from your Zoom list.

The key is really to get your data in good shape. That means stacking your email addresses and dates on top of each other so that you can extract a pivot table from it. In this file – you can see in the Data sheet how I have stacked the email addresses on top of each other. Just to say – those email addresses come courtesy, of Fake Name Generator, so if you ever need to go into the Witness Protection Programme……

This video also shows you how to add conditional formatting so that you can quickly see who did NOT attend…and activate your inner Liam Neeson in Taken…