Advanced Excel VBA Instructor Needed

via Freelancer ·

Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted2 hours ago
I’m setting up an intensive Advanced Excel programme for students who are already comfortable with pivot tables, complex formulas, and data modelling. The goal of the course is simple: by the final session every participant must be able to automate routine reporting through well-structured macros and VBA, then package those results into polished, refresh-on-click dashboards.

What I’ll need from you
• A clear, session-by-session syllabus that moves quickly past formula basics and dives straight into VBA fundamentals, best practices, and error handling.
• Hands-on demonstrations of recording macros, refactoring the generated code, and progressing to writing procedures from scratch.
• Practical projects where learners build an automated report and an interactive dashboard driven by buttons or events.
• Reusable sample workbooks, step-by-step notes, and brief homework tasks so they can keep practising between meetings.
• Live screen-sharing sessions (or high-quality screencasts if time-zones clash) with time for Q&A.

Acceptance criteria
1. Each student delivers a macro-driven dashboard that pulls data, refreshes visuals, and exports a PDF summary at the click of a button.
2. All course files are submitted in an organised folder structure with clear comments in code.
3. A short feedback survey shows participants feel confident maintaining and extending their own VBA modules.

If you routinely build automated reporting solutions in Excel, enjoy teaching advanced users, and can slot into a fast-paced schedule, let’s set up the curriculum and timeline.
visual basic data processing excel visual basic for apps excel vba excel macros data visualization data analysis
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.