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.

Online
07 - 11 Jul 2024
2500 Euro
Vienna (Austria)
15 - 19 Jul 2024
5200 Euro
London (UK)
22 - 26 Jul 2024
5800 Euro
Lisbon (Portugal)
05 - 09 Aug 2024
5200 Euro
Cairo (Egypt)
18 - 22 Aug 2024
3500 Euro
Online
25 - 29 Aug 2024
2500 Euro
Amsterdam (Netherlands)
26 - 30 Aug 2024
5500 Euro
Istanbul (Turkey)
01 - 05 Sep 2024
5000 Euro
London (UK)
02 - 06 Sep 2024
5800 Euro
Dubai (UAE)
08 - 12 Sep 2024
4500 Euro
Casablanca (Morocco)
09 - 13 Sep 2024
4000 Euro
Brussels (Belgium)
09 - 13 Sep 2024
5200 Euro
Boston (USA)
23 - 27 Sep 2024
9000 Euro
Dubai (UAE)
29 Sep - 03 Oct 2024
4500 Euro
Brussels (Belgium)
30 Sep - 04 Oct 2024
5200 Euro
Munich (Germany)
30 Sep - 04 Oct 2024
5200 Euro
Istanbul (Turkey)
06 - 10 Oct 2024
5000 Euro
Sharm El-Sheikh (Egypt)
13 - 17 Oct 2024
4500 Euro
Istanbul (Turkey)
13 - 17 Oct 2024
5000 Euro
Amman (Jordan)
03 - 07 Nov 2024
3200 Euro
Manama (Bahrain)
10 - 14 Nov 2024
5500 Euro
Geneva (Switzerland)
18 - 22 Nov 2024
5200 Euro
Kuala Lumpur (Malaysia)
24 - 28 Nov 2024
4500 Euro
Cairo (Egypt)
24 - 28 Nov 2024
3500 Euro
Sharm El-Sheikh (Egypt)
29 Dec 2024 - 02 Jan 2025
4500 Euro
Madrid (Spain)
30 Dec 2024 - 03 Jan 2025
5500 Euro
Dubai (UAE)
05 - 09 Jan 2025
4500 Euro
Amsterdam (Netherlands)
06 - 10 Jan 2025
5500 Euro
Online
19 - 23 Jan 2025
2500 Euro
Amman (Jordan)
19 - 23 Jan 2025
3200 Euro
London (UK)
20 - 24 Jan 2025
5800 Euro
Madrid (Spain)
20 - 24 Jan 2025
5500 Euro
Rome (Italy)
03 - 07 Feb 2025
5500 Euro
Dubai (UAE)
16 - 20 Feb 2025
4500 Euro
Vienna (Austria)
17 - 21 Feb 2025
5200 Euro
Rome (Italy)
24 - 28 Feb 2025
5500 Euro
Online
09 - 13 Mar 2025
2500 Euro
Cairo (Egypt)
23 - 20 Mar 2025
3500 Euro
Barcelona (Spain)
24 - 20 Mar 2025
5500 Euro
Kuala Lumpur (Malaysia)
30 Mar - 20 Apr 2025
4500 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.