logo


your one source for IT & AV

Training Presentation Systems Services & Consulting Cloud Services Purchase Client Center Computer Museum
Arrow Course Schedule | Classroom Rentals | Student Information | Free Seminars | Client Feedback | Partners | Survey | Standby Discounts

Excel 2016 VBA

SS Course: 3000025

Course Overview

TOP

In this two-day course, you will learn to record simple macros, edit code and how to write your own VBA sub procedures. This course provides many examples of macro development that can help manage Excel spreadsheets. Students will become familiar with the Visual Basic Editor and Immediate windows. The course covers many styles of code including With statements, If… Then… Else statements, loops and event driven code.

                                                                  

Scheduled Classes

TOP

What You'll Learn

TOP

In this course you will:

  • Record Simple Macros
  • Edit Recorded macros
  • Take complex macro tasks and simplifying them 
  • Work with workbook and worksheet objects using the Immediate window
  • Select ranges using VBA code
  • Code for Excel Tables, Pivot Tables & Charts
  • Create If… Then… Else statements
  • Create Loops
  • Add worksheet controls
  • Create custom VBA forms and controls

Outline

TOP
Viewing outline for:
  • Recording Simple Macros
  • Editing Recorded macros
  • Taking complex macro tasks and simplifying them
    • Generalizing code and making it more flexible
    • Importing text files
    • Inserting columns & input boxes
    • Filling in empty cells
    • Appending data to another file
    • Naming ranges
  • workbook and worksheet objects using the Immediate window
  • Selecting ranges using VBA code
  • Code for Excel Tables, Pivot Tables and Charts
  • If… Then… Else statements
  • Loops
  • Adding worksheet controls
  • Creating custom VBA forms and controls

Prerequisites

TOP

To be successful in this course, student should have taken Excel Part 1, Excel Part 2 and Excel Part 3 or possess the equivalent knowledge.

    Who Should Attend

    TOP

    Students who wish to automate tasks in Excel.

    Next Step Courses

    TOP