VBA FOR EXCEL

Make the most of the programming possibilities in Excel

Microsoft Excel is an extremely powerful tool that you can use to manipulate, analyze, and present data. Sometimes though, despite the rich set of features in the standard Excel user interface (UI), you might still want to find an easier way to perform repetitive tasks or to perform some tasks that the UI does not seem to address. Fortunately, Office applications like Excel have Visual Basic for Applications (VBA).

Request a Meeting

WHY IS IT CRUCIAL TO TRAIN YOUR EMPLOYEES?

Increase in Productivity
Performance Management
Product Quality
Employee Retention

COURSE PREREQUISITES

  • This course requires knowledge of Excel up to Advanced level.
  • No experience of programming is needed, although delegates should enjoy the logical challenge of learning new computer systems.

LEARNING OUTCOMES

  • Creating a Macro
  • Running a Macro
  • Examining the code behind the macro
  • Opening the Visual Basic Editor
  • Recognizing parts of the Visual Basic Editor
  • Menus – Views, Insert, Format, Debug, Run & Tools Menu
  • Objects and Collections
  • Workbook and Worksheet Object
  • Range Object and Cells Property
  • Methods and Property
  • Assigning Object Variables and Using Named Argument
  • Declaring Variables
  • Defining Data Types
  • Defining Constants
  • Assigning Values to Variables
  • Handling Strings
  • Handling Dates and Times
  • Handling Variants and Data Type Coversions
  • Modules and Procedures and their scope
  • Calling Sub Procedures and Function Procedures
  • Understanding Variable Scope and Lifetimes
  • Excercises
  • About User Defined Functions
  • A Function to Calculate the Area of a Rectangle
  • A Function to Calculate Fuel Consumption
  • Accessing Your Custom Functions
  • IF…Then Statement
  • IF…Then…Else
  • Exercise: A Function to Calculate the Area of a Rectangle – (IF)
  • Select Case
  • Exercise: A Function That Gives the Name of the Day
  • For…Next
  • For…Next Loop With Step
  • Do While…Loop
  • Do Until…Loop
  • Do…Loop While
  • Exercises 0..8
  • Adding Up the Coloured Numbers
  • The Course Booking Form
  • The Control Properties Settings
  • Building the Form
  • Adding the Code: Initializing the Form
  • Adding the Code: Making the Buttons Works
  • Adding the Code: Manipulating the Form
  • Opening the Form
DOWNLOAD SYLLABI

PUBLIC COURSE SCHEDULE

Venue: Holistic Technologies Ltd, Fgura

Training Date Time Price
Thursday 7th December ’17 09:00 – 16:00 €200.00 (including Training by an Excel Professional, Courseware, x2 Coffee Breaks and a light lunch)
PAY NOW
Thursday 22nd February ’18 09:00 – 16:00 €200.00 (including Training by an Excel Professional, Courseware, x2 Coffee Breaks and a light lunch)
PAY NOW

ON-SITE TRAINING

Holistic Technologies On-site Training is a flexible, cost-effective option that allows you to train as many or as few employees as you need—from a single team or department to everyone in your organization.

On-site Training courses can be delivered “off-the-shelf,” slightly modified or completely customized for your learning needs. They’re designed to meet your most important goals and produce immediate, measurable results.

Your employees and your business benefit because:

  • Courses are planned around the individual’s and department schedules, and delivered in any format
  • Teams will learn with real-world, mission specific examples to ensure your project’s success
  • You maintain productivity with flexible course scheduling
  • You can train groups of employees to significantly reduce expenses
  • You can tailor the course material to fulfill corporate needs and expectations.
Request a quote