HOME
 

Excel VBA Intermediate

G Com Solutions
Course summary
2 days
Nationwide
Next available date: Variable depending on group number - United Kingdom
Corporate Training for Teams

Course description

In-house computer training courses

GCom Solutions  - On-Site Computer Training Courses in the UK - One-to-one and group training

This course is designed for beginners and covers: getting started with jQuery mobile; building jQuery mobile pages; using jQuery mobile widgets; working with toolbars; working with list views; using the content formatting tools; jQuery mobile events; and the jQuery mobile api.

Suitability - Who should attend?

This course requires familiarity with the key concepts and techniques of Excel VBA Programming as well as with the fundamental and advanced features of MS Excel itself. The ability to carry out basic computing tasks, such as saving or copying a file, is also assumed.

Outcome / Qualification etc.

A G Com Solutions Certificate of Attendance is issued on course completion.

Training Course Content

Our Excel VBA Level 2 course is designed for experienced Excel users who have already begun to create macros and know their way around Excel's Visual Basic Editor.

Course Outline

Excel object model

About classes and objects, Objects and collections, The hierarchy of objects, Properties, methods and events, The Locals Window, The Immediate Window

Function procedures

Sub versus function, User-defined functions, Declaring a function, Calling a function, Private and public scope, Defining arguments, Optional arguments

The Application object

When to use, ScreenUpdating property, DisplayAlerts property, Setting CutCopyMode to false

Dialogue boxes

MsgBox function, InputBox function, Application.Dialogs

UserForms

Creating a userform, Displaying a userform, Adding Label controls, Adding a TextBox control, The CheckBox control, The OptionBox control, ComboBox and ListBox, SpinButton controls, Adding CommandButtons, Setting control properties

Workbooks and worksheets

The Workbooks collection, The Sheets collections, The Window objects, Workbook events

Ranges and names

Column and Row properties, CurrentRegion property, The Union method, The Intersect method, Using the Name property, Working with named ranges

Pivot tables

Pivot table code overview, Creating a pivot table, PivotField object, PivotItems collection, Modifying a pivot table, Using external data

Charts and drawings

About programming charts, Working with embedded charts, Working with independent charts, Controlling chart formatting, Assigning a range to a chart, Positioning a chart, Making a chart active/inactive, Editing data series, Controlling chart labels, Drawing shapes, Setting shape attributes

Expenses

£900 for one-to-one training

£1,100 for groups of up to 6 people

£1,300 for groups of up to 12 people

About provider

G Com On-Site Computer Training in the UK

G Com Solutions Limited

G Com Solutions design customised and effective training solutions in partnership with our clients; which equip their people with the computer skills necessary to work more productively and effectively. By delivering our training on-site, we are able to save our...


Read more and show all courses with this provider

Contact info

G Com Solutions

Kemp House, City Road
EC1V 2NX London

 Show phone number

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here