Course not currently available

Excel and VBA Guru Training Course

Course

In Oxford ()

£ 3,150 VAT inc.

Description

  • Type

    Course

The course topics cover maximum automation. The student will learn how to use VBA effectively, how to use cell names to be copied, which are useful properties of objects only available in Excel VBA code and how to create your own control library. Finally, participants will learn how to create a complete application and how to secure it.

About this course

Required practical and advanced knowledge of Microsoft Excel and VBA in Excel.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Access
  • Excel
  • MS Excel

Course programme

Advanced Features of Excel
  • Functions Panel
  • The properties of an object from VBA
  • Events Sheet, Workbook and Application
  • Formula repeatedly nested
  • Solver addition
User Forms
  • Creating a user interface
  • Advanced forms and custom dialog boxes
  • Event handling forms
Access and Excel Automation
  • Automation vs ADO
  • Using the functionality in Access VBA code in Excel
Outlook and Excel Automation
  • Sending emails from Excel
  • Reading data from Outlook
Creating Applications in Excel
  • Application Development and its distribution
  • Distribution and securing additions to Excel
  • Creating custom toolbars and menu
Excel Hacks
  • Tips and tricks to use other Excel features, for example double pie,and extracting numeric values ​​from text

Additional information

21 hours (usually 3 days including breaks)

Excel and VBA Guru Training Course

£ 3,150 VAT inc.