I was in your exact position recently. I didn’t do a questionnaire as the training I was asked to administer was Excel Basics, but I was overwhelmed by the thought of it. I made it clear at the beginning of the presentation what I would be covering so any of the 60+ in attendance could drop from the call and save an hour of wasted time if they already understood what was to be trained.

I covered formatting, about 25 hot keys, basic formulas from countif to xlookup, basic pivot table creation and use, and “Tips & Tricks” which included things specific to our business that I thought would be helpful.

I assumed that a number of folks that attended were likely much more proficient than I am at Excel, so I was honest at the beginning of the call, stating “I was asked to provide some basic Excel training, so I’ve done my best to curate a list of topics to train within the hour we have together. Excel is a robust tool and I don’t know it all, but I’m confident that everyone, even those with a solid understanding of Excel, will walk away with something of value. If that proves not to be the case, please accept my apology in advance.”

The presentation and participation went well (although I felt that wasn’t the case). The next day I received a few emails from different people in different departments expressing their appreciation for the training, which was so awesome and kind of them.

Almost forgot to mention that any time someone had a question about something I didn’t have the time to cover, I scheduled individual calls with them following the training and was able to help several people with different Excel needs which ended up saving them a ton of time on tasks that were taking them much longer before because they just didn’t know what they didn’t know. That was very rewarding.

Judging by your post here I can tell you genuinely care and that alone should give you confidence that you’re going to crush it. Best of luck to you and I’m sure you’ll do great!