Virtual Beginner Excel Training Series

I want to arrange a set of live, online Excel classes for a team of about 50 staff who describe themselves as absolute beginners. Our main objective is to boost their data-management confidence so they can clean, structure and summarise information on their own.

Core topics I need covered
• Basic data organisation techniques (importing, formatting, sorting, filtering)
• Essential functions with a spotlight on VLOOKUP and related look-ups
• Building and customising Pivot Tables for quick summaries
• Other must-know analytical functions that make everyday reporting painless

All sessions must be delivered in real time—Zoom, Teams or a similar platform is fine—so the group can ask questions and practise while you guide them. I’m expecting a concise series rather than a single marathon: think several short modules that build on each other and finish with a hands-on exercise.

To make sure the learning sticks, I’ll need:
1. A clear syllabus and timetable up front
2. Downloadable practice files for each topic
3. Brief homework or quizzes we can use to measure progress
4. Session recordings and a quick-reference cheat sheet for later use

By the end, participants should comfortably import data, apply look-ups, and create basic Pivot-driven reports without outside help. If this sounds like your teaching style, outline your proposed schedule and any interactive methods you’d use to keep 50 beginners engaged online.