sss

Microsoft Excel Training Courses

Enliten IT have an extensive range of Microsoft Excel training courses to give you the skills to ‘Excel’ at work!  Whether you are new to Excel, are self-taught or you think you know a fair bit, we've got a course for you.

We have certified Microsoft Excel trainers and consultants throughout the UK, so why not take advantage of our, cost effective, tailored onsite training options (we come to you!).  Alternatively, you can come to one of our training centers.

We train on ALL versions of Microsoft Excel and to All levels!

Office 365 Microsoft Excel 2019 VBA Course

2 days

This O365 Microsoft Excel 2019 VBA Course teaches delegates how to develop custom built applications with Excels Visual Basic for Applications (VBA) programming language.  VBA allows you to automate cumbersome repetitive everyday tasks and gives you the ability to build in-house custom applications that are user driven.

Download PDF

What will you learn?

At the end of this O365 Microsoft Excel 2019 VBA Course delegates will be able to:
  • Record and debug simple macros
  • Write and edit VBA code
  • Build procedures which interact with the user

Audience?

Programmers (and dabblers) who need to create sophisticated applications for data presentation using custom dialogue boxes and menus through use of structured macros and macro code.

Course Contents


Getting Started

  • Recording VBA
  • Buttons to run Macros
  • Macro Security

Visual Basic Editor

  • Overview of Menus and Toolbars
  • Project Explorer
  • Local, Immediate and Watch Windows
  • Short cuts
  • Object explorer
  • Addins to the Editor

Programming Basics

  • Objects, Properties and Methods
  • Comments
  • Code Layout
  • Location of Code
  • Subs, Functions and Events

Excel Object Model

  • Range Object
  • Worksheet Object
  • Workbook Object
  • Events
  • Add-ins
  • Worksheet Functions

Ribbons

  • Using Custom UI Editor
  • Adding New Ribbons
  • Adding Groups and Buttons

Programming Structures

  • Sub and Function Statements
  • Decision Code
    • If Statement
    • Select Case Statement
  • Loops
    • Do Loop
    • For Loop
    • For Each Loop
  • With Statement
  • Msgbox and Inputbox

Variables

  • Naming Variables
  • Types of Variables
  • Using Parameters
  • Variable Lifetime and Scope

User-Defined Forms

  • Basic Form Design
  • Form Handling and Events

Error Handling

  • Trapping Errors
  • Err Object
  • Debugging Techniques

Development Process

  • Modular Code
  • Flow Control
  • Test Plans

Course Materials

Enliten IT will provide each delegate with a workbook and other useful reference materials where applicable.  These may be either paper based or in Adobe pdf format or a combination thereof.

“Very impressive, very good training session.”Very impressive, very good training session.

Additional Information

NOTE:   We only offer this O365 Microsoft Excel 2019 VBA Course on a private in-house basis.

Enliten IT reserves the right to modify course content and materials as required in the interests of continuous course improvement, at any time, without notification.

The suggested course duration is a guideline.  Course topics and duration may be modified by the instructor based upon the knowledge and skill level of the course participants.

Contact us to discuss your training needs...

0845 108 5481 0845 108 5481
info@enliten-it.com info@enliten-it.com