This is the self-paced version. For live instruction, enroll in Excel VBA and Macros Level I.
This course shows you how to use basic macros to automate Excel, putting spreadsheet knowledge you already have to considerably more productive use. It assumes no prior experience with macros or with programming of any kind.
You will write and run macros for everyday tasks, use them to format worksheets quickly, and build interactive worksheets using VBA elements. You will also automate work across multiple worksheets at once and run calculations through VBA, which extends what a spreadsheet can do well beyond formulas. Excel knowledge equivalent to an intermediate course is recommended, including VLOOKUP, PivotTables, and IF statements.
From our hands-on training style to world-class instructors and custom-crafted curriculum, we deliver results our alumni are proud of.
Learn the concepts and skills covered in this course or your tuition is on us. See details and terms & conditions.
Work on projects proven to boost retention
Refined over many cohorts for an optimal learning experience
Excellent classes and excellent venue! It has just the right level of personal attention and class participation. I would highly recommend NYIM and look forward to taking future classes there. – Hazel S.
Experienced educators who are driven to help you succeed
Refresh the materials and gain additional practice
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Shareable on
Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required.
This course does not qualify for payment plans or student financing. See our Payment Plan FAQ to find related programs that qualify.
For this course, you are entitled to a 90% refund (your payment less the nonrefundable 10% registration fee) within 30 days of purchase if you have not accessed the course materials.
There are no extra fees or taxes for our courses. The price you see on this page is the maximum you’ll pay us.
However, you may need to obtain required software. We’ll help you get set up with a free trial of paid software prior to the class. Most of our coding classes utilize freely-available open-source software. For most of our design and motion graphics courses, we will help you get set up with a free trial of Adobe Creative Cloud. If you attend the course in-person, we will have a computer already set up for you with all of the required software for no additional cost.
We don’t currently offer discounts as we do our best to affordably prices our courses.
