# Excel VBA and Macros Level I (Self-Paced)

Canonical URL: <https://training-nyc.com/courses/excel-vba-and-macros-level-i-self-paced>

## Overview

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.

## What you'll learn

- Write and run basic macros to automate everyday tasks
- Use macros to format worksheets quickly and consistently
- Build interactive worksheets using VBA elements
- Automate tasks across multiple worksheets at once
- Run calculations using VBA to extend what spreadsheets can do
- Extend what your spreadsheets can do without prior programming experience

## FAQ

### Is this course open to beginners?

Yes, this course is open to beginners. Students must be comfortable using a computer. No other prior knowledge is required.

### Do you offer payment plans or student financing for this course?

This course does not qualify for payment plans or student financing. See our Payment Plan FAQ to find related programs that qualify.

### What is the cancellation and refund policy for this single course?

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.

### What’s included with my tuition?

A hands-on learning experience working on projects and exercises, which is proven to boost comprehension, retention, and engagement Expert instructors who are industry professionals and experienced educators that are driven to help you succeed Expert support with answers to your questions from real instructors throughout your learning journey Top-notch curricula that have been tried and tested over many years and are consistently improved for an optimal learning experience 30-day access to class recordings to review material at your own pace A certificate of completion to verify your accomplishment

### Are there any additional fees or expenses?

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.

### Do you offer any discounts for this course?

We don’t currently offer discounts as we do our best to affordably price our courses.

## Pricing

**Tuition:** $345