Excel VBA and Macros Level I
via Noble Desktop
Affiliated with Course Report
Learn how to develop macros, perform calculations, and more in this beginner VBA and Macros course. From understanding macros and VBA to creating and editing code, this course will teach you the essential skills to automate Excel and enhance your productivity.
What's included with live classes
- Microsoft Office (1 month)
- Free course retake within one year to refresh the material and gain practice.
- Class recordings
Overview
Our VBA Excel Macro Classes will teach you how to use basic Macros to automate Excel. You will be able to use your Excel knowledge more productively by incorporating Macros in your spreadsheets. This Excel Macro Course assumes no previous knowledge of Macros. Excel VBA Macros Level 1 course is a basic VBA (Visual Basic for Applications) class that will help you apply spreadsheet skills more quickly and efficiently.
Prerequisites
Prior VBA programming knowledge is not required, but knowledge equivalent to our Intermediate Excel course is recommended, including VLOOKUP, PivotTables, and IF statements.
Schedule & enrollment
Find dates that fit your schedule, then book on Noble Desktop.
- Live tuition
- $345
- Course length
- 6 hours
All class times are Eastern (ET).
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
-
Dates
Class time
Starts at 10am ET
Final session ends at 5pm ET
Attend
In-person or live online
Confirm current dates and availability on Noble Desktop before booking. Enrollment opens in a new tab.
Self-paced tuition & enrollment
Learn through recorded lessons on your own schedule.
- Tuition
- $345
- Course length
- 6 hours
- Format
- Self-paced online
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
Loading enrollment options…
Prefer to enroll directly? Open the course website.
Curriculum
What you'll learn
- Write and run basic macros to automate tasks
- Use macros to format worksheets efficiently
- Build interactive worksheets using VBA elements
- Automate tasks across multiple worksheets
- Perform calculations using VBA to enhance spreadsheet functionality
Course syllabus
Lesson 1: Macros / VBA
- What are Macros?
- What is VBA?
- How to record macros
- How to run macros
Lesson 2: VBA Editor
- Modules
- Procedures
- Project Explorer
- Toolbars / Options
Lesson 3: Creating / Editing Code
- Create Procedures
- Subs
- Comments
Lesson 4: Invoking Macros
- Hot Keys
- Quick Access Toolbar
- Call Command
Lesson 5: Compiling Code
- Stepping through code
- Reset
- Run
Lesson 6: Variables
- Declarations
- Option Explicit
- Data Types
Lesson 7: Working with The Object Model
- Worksheets
- Ranges: Rows, Columns, Cells
Lesson 8: Creating & Naming Objects
- Naming conventions
- Housekeeping
Lesson 9: Navigation / Selection Techniques
- Formula R1C1 Reference Style
- Offsets
- Range Names
Lesson 10: Logic Statements
- IF Statements
Lesson 11: Looping Statements
- Do Loops
Lesson 12: Interactive Code
- Input boxes
- Message boxes
Lesson 13: Error Handlers
- Preventing fatal errors and crashes
Self-paced course
Learn through recorded lessons on your own schedule.
This course is available for 30 days. You can choose when to start your access period. Once you activate, you will have 30 days to complete it (access the course materials, quizzes, projects and videos). You may request one extension of seven (7) days. Other extension requests will be evaluated on a case-by-case basis. Videos are not downloadable.
View self-paced tuition & enrollmentOur VBA Excel Macro Classes will show you how to use basic Macros to automate Excel. You'll be able to put your Excel knowledge to more productive use by incorporating Macros into your spreadsheets.
This Excel Macro Course assumes no prior experience with Macros. The Excel VBA Macros Level 1 course is a beginner-level VBA (Visual Basic for Applications) class that'll help you apply your spreadsheet skills in a faster, more efficient, and genuinely exciting way.
Self-paced prerequisites
Prior VBA programming knowledge is not required, but knowledge equivalent to our Excel Level II: Intermediate course is recommended, including VLOOKUP, PivotTables, and IF statements.
Self-paced curriculum
What you'll learn self-paced
- Write and run basic macros to automate everyday tasks
- Use macros to format worksheets efficiently
- Build interactive worksheets using VBA elements
- Automate tasks across multiple worksheets at once
- Run calculations using VBA to expand what your spreadsheets can do
Self-paced syllabus
Lesson 1: Macros / VBA
- What are Macros?
- What is VBA?
- How to record macros
- How to run macros
Lesson 2: VBA Editor
- Modules
- Procedures
- Project Explorer
- Toolbars / Options
Lesson 3: Creating / Editing Code
- Create Procedures
- Subs
- Comments
Lesson 4: Invoking Macros
- Hot Keys
- Quick Access Toolbar
- Call Command
Lesson 5: Compiling Code
- Stepping through code
- Reset
- Run
Lesson 6: Variables
- Declarations
- Option Explicit
- Data Types
Lesson 7: Working with The Object Model
- Worksheets
- Ranges: Rows, Columns, Cells
Lesson 8: Creating & Naming Objects
- Naming conventions
- Housekeeping
Lesson 9: Navigation / Selection Techniques
- Formula R1C1 Reference Style
- Offsets
- Range Names
Lesson 10: Logic Statements
- IF Statements
Lesson 11: Looping Statements
- Do Loops
Lesson 12: Interactive Code
- Input boxes
- Message boxes
Lesson 13: Error Handlers
- Preventing fatal errors and crashes