Strategic Business, IT, Planning, Deployment, & Management Courses


Microsoft Office with VBA Programming Course

Introduction:

In this course on Microsoft Office with VBA Programming, delve into the powerful intersection of Office applications and Visual Basic for Applications (VBA). Discover leveraging VBA to automate tasks, enhance productivity, and customize functionalities across Microsoft Excel, Word, PowerPoint, and Outlook.

Explore the fundamentals of VBA syntax, macros, and advanced techniques tailored to streamline workflows and optimize data management within the Office suite. Whether you're a novice looking to unlock the potential of Office applications or an experienced user seeking to master VBA for intricate automation, this course equips you with essential skills to excel in today's dynamic workplace environment.

Targeted Audience:

This Microsoft Office with VBA Programming course is aimed at individuals with a basic grounding in Excel VBA and an advanced knowledge of Microsoft Excel who want to develop skills in introducing more sophisticated automation into their workflows.

Course Objective:

At the end of this Microsoft Office with VBA Programming course, participants will be able to:

  • Variable types.
  • Use object variables to represent worksheets and workbooks.
  • Use count-based (For-Next) and conditional-based (Do-Until, Do-While) loops.
  • If-Then-Else-End If and Select Case statements.
  • Blocks.
  • Use Range and Cells objects.
  • Benefits.
  • Upon completion of the course, delegates will have a good understanding of the significant components of VBA.
  • Delegates will expand their reach using VBA to communicate with other Office applications, such as Word.
  • In addition, the course also covers working with data from database applications such as Access and manipulating and presenting the data.

Targeted Competencies:

By the end of this Microsoft Office with VBA Programming training, participants' competencies will be able to:

  • Automate routine tasks across Microsoft Office applications using VBA macros.
  • Customize and extend functionality in Excel, Word, PowerPoint, and Outlook through VBA programming.
  • Implement data manipulation and analysis techniques with VBA to enhance decision-making processes.
  • Develop interactive user interfaces and forms for streamlined data input and retrieval.
  • Troubleshoot and debug VBA code to ensure robust application performance.
  • Integrate external data sources and APIs into Office applications using VBA.
  • Optimize workflows and improve efficiency through advanced VBA techniques and best practices.

Course Outline:

Unit 1: The Excel Object Model:

  • Explore the Range object in detail.
  • The versatile Current Region object.
  • Work with collections of Workbooks and Worksheets.
  • Manipulating Charts through VBA.
  • Manipulating PivotTables through VBA.

Unit 2: Arrays:

  • Efficient variable storage with arrays.
  • Array optimization.
  • Dynamic arrays.
  • The Array function.

Unit 3: Triggers and Events:

  • Run macros automatically.
  • Execute macros on a timer.
  • Associate macros with other Workbook events.

Unit 4: Advanced Parameters:

  • Pass parameters by reference and by value.

Unit 5: Working with Text Files:

  • Import text files.
  • Export text files.
  • Use the FileStream object.

Unit 6: Linking with Office:

  • Connect to other Office applications.
  • Work with other Office applications.

Unit 7: Linking to data sources using ADO:

  • Understanding ActiveX Data Objects.
  • Use Excel to communicate with other data sources.
  • Understand the connection string.
  • Add, read, modify and delete data.

Unit 8: Add-Ins:

  • How does macro security work?
  • Password protecting your code.
  • Distribute macros via an Add-In.

Rome (Italy)
03 - 07 Feb 2025
6900 Euro
Dubai (UAE)
16 - 20 Feb 2025
4900 Euro
Vienna (Austria)
17 - 21 Feb 2025
5900 Euro
Rome (Italy)
24 - 28 Feb 2025
6900 Euro
Online
09 - 13 Mar 2025
2900 Euro
Cairo (Egypt)
23 - 27 Mar 2025
4000 Euro
Barcelona (Spain)
24 - 28 Mar 2025
5900 Euro
Kuala Lumpur (Malaysia)
30 Mar - 03 Apr 2025
4900 Euro
Paris (France)
31 Mar - 04 Apr 2025
5900 Euro
Milan (Italy)
14 - 18 Apr 2025
6900 Euro
London (UK)
28 Apr - 02 May 2025
5800 Euro
Kuala Lumpur (Malaysia)
04 - 08 May 2025
4900 Euro
Manama (Bahrain)
04 - 08 May 2025
5500 Euro
Barcelona (Spain)
19 - 23 May 2025
5900 Euro
Paris (France)
09 - 13 Jun 2025
5900 Euro
Barcelona (Spain)
09 - 13 Jun 2025
5900 Euro
Online
06 - 10 Jul 2025
2900 Euro
Vienna (Austria)
14 - 18 Jul 2025
5900 Euro
London (UK)
21 - 25 Jul 2025
5800 Euro
Lisbon (Portugal)
04 - 08 Aug 2025
5900 Euro
Cairo (Egypt)
17 - 21 Aug 2025
4000 Euro
Online
24 - 28 Aug 2025
2900 Euro
Amsterdam (Netherlands)
25 - 29 Aug 2025
5900 Euro
Istanbul (Turkey)
31 Aug - 04 Sep 2025
5500 Euro
London (UK)
01 - 05 Sep 2025
5800 Euro
Dubai (UAE)
07 - 11 Sep 2025
4900 Euro
Casablanca (Morocco)
08 - 12 Sep 2025
4900 Euro
Brussels (Belgium)
08 - 12 Sep 2025
5900 Euro
Boston (USA)
22 - 26 Sep 2025
9000 Euro
Dubai (UAE)
28 Sep - 02 Oct 2025
4900 Euro
Munich (Germany)
29 Sep - 03 Oct 2025
5900 Euro
Brussels (Belgium)
29 Sep - 03 Oct 2025
5900 Euro
Istanbul (Turkey)
05 - 09 Oct 2025
5500 Euro
Sharm El-Sheikh (Egypt)
12 - 16 Oct 2025
5500 Euro
Istanbul (Turkey)
12 - 16 Oct 2025
5500 Euro
Amman (Jordan)
02 - 06 Nov 2025
4000 Euro
Manama (Bahrain)
09 - 13 Nov 2025
5500 Euro
Geneva (Switzerland)
17 - 21 Nov 2025
7500 Euro
Cairo (Egypt)
23 - 27 Nov 2025
4000 Euro
Kuala Lumpur (Malaysia)
23 - 27 Nov 2025
4900 Euro
Sharm El-Sheikh (Egypt)
28 Dec 2025 - 01 Jan 2026
5500 Euro
Madrid (Spain)
29 Dec 2025 - 02 Jan 2026
5900 Euro
Dubai (UAE)
04 - 08 Jan 2026
4900 Euro
Amsterdam (Netherlands)
05 - 09 Jan 2026
5900 Euro
Amman (Jordan)
18 - 22 Jan 2026
4000 Euro
Online
18 - 22 Jan 2026
2900 Euro
London (UK)
19 - 23 Jan 2026
5800 Euro
Madrid (Spain)
19 - 23 Jan 2026
5900 Euro

Strategic Business, IT, Planning, Deployment, & Management Courses
Microsoft Office with VBA Programming Course (B)

 

Mercury dynamic schedule is constantly reviewed and updated to ensure that every category is being addressed at least once a month, if not once every week. Please check the training courses listed below and if you do not find the subject you are interested in, email us or give us a call and we will do our best to assist.