Return to Excel Classes

VBA Classes Online

VBA Classes Online

excel class scheduleJune 1st, 2nd, 8th, 9th, 15th, 16th, 22nd, 23rd, 29th, 30th, July 6th, 7th, 13th, 14th, 20th, 21st, 27th, 28th, August 3rd, 4th
8pm-10pm EST

Price: $385
excel class registration

Course Outline

download the pdfDownload the PDF

  • Recording Macros – Strengths and Weaknesses
  • Editing Macros with the Visual Basic Editor
  • Debugging
  • Writing Pseudocode
  • Declaring Variables
    • Variable Data Types
    • Variable Concatenation and Variable Substitution
  • Navigating Cells and Ranges
  • Navigating Worksheets
    • Add Sheets
    • Name Sheets
    • Count Sheets
    • Hidden Sheets
  • Finding Key Columns
  • Read and Write to / from Cells
  • Use Named Ranges to Demarcate Start and End Positions
  • Use For / Next Loops to Iterate Through Cells and Ranges
  • Use If / Then / Else Statements To Make Decisions
  • Make Code Run Faster
  • Handle Run-Time Errors Level I
  • Message Box, InputBox, Dialogs and FileDialogs
  • Use Excel’s Functions
  • Write Your Own Functions
  • Workbook Events
  • Create Programs That Run On Specified Days and Times Automatically
  • Select Case Control Structures
  • Pass Local Variables vs. Use Global Variables
  • Call Subroutines From Subroutines, Pass Local Varaibles
  • Array Variables
  • Object Variables
  • For Each Loops
  • Do While Loops and Do Until Loops
  • While / Wend Loops
  • User Forms
  • Charts
  • Pivot Tables
  • Communicate With Other Microsoft Programs: Word, Access, PowerPoint
  • Handle Run-Time Errors Level II – Write to External Text Files
  • Connect to Databases, Read and Write
  • Class Modules
  • Import a Folder of PDFs to Excel Sheets

Contact Us

Name
Phone or Email
Question(s)



VBA Online Benefits

VBA Class Online Benefits Us Competitors
Live 40 Hour Course vba classes advantage vba classes competition
Live Sessions Recorded vba classes advantage vba classes competition
No Time Limits! vba classes advantage vba classes competition
Unlimited Retakes! vba classes advantage vba classes competition
Course Encourages Instructor Interaction vba classes advantage vba classes competition
Weekly Homework Assignments vba classes advantage vba classes competition
Single Course Covers Everything Without Selling Additional Material vba classes advantage vba classes competition
Lowest Price And Best Value On The Web vba classes advantage vba classes competition
Volume Discounts For Multiple Registrations vba classes advantage vba classes competition

FAQ

faqWhat time does class start?
Webinars begin at different hours, typically in the evening. Webinars are designed for people outside the eastern time zone. You can also register for a 1-1 class for a specific time slot.

What topics are covered?
Each class provides an outline, please consult the class page for details.

Do I need to bring a computer?
We provide a computer, an illustrated book, pens and snacks.

Do you provide a certificate
Yes! Your gold foil certificate will stand out on your cubicle wall.