Microsoft Office - VBA Advanced Training in Denmark

  • Learn via: Classroom
  • Duration: 2 Days
  • Level: Expert
  • Price: From €2,210+VAT
We can host this training at your preferred location. Contact us!

In this course, you will learn the skills to enable you to use the Visual Basic for Applications (VBA) programming language to simplify or automate activities and tasks using Microsoft Office applications. The course covers examples in; Excel 2016 – 2019, Word 2016 – 2019, Outlook 2016 – 2019, PowerPoint 2016 – 2019

Please Note: Microsoft Excel 2016 is used as the primary application during the course for demonstration purposes.

  • You have attended the QA course Microsoft Office - VBA Essentials or have equivalent knowledge
  • Able to write macros which include variable declarations with appropriate scope, intrinsic functions, decision-making structures and repeating code actions
  • Have a working knowledge of Microsoft Office applications 2016 – 2019 (Excel, Word, Outlook and PowerPoint)
  • Understand how to create Charts and PivotTables and apply filters and sorting to data sets

Target Audience

Delegates looking to gain enhanced skills to apply VBA to develop macros to work with Office applications. You will work with the application object models, manipulate data across applications and manage files and folders using VBA.

A dual monitor setup is required when attending this course via the QA Attend from Anywhere delivery method.

  • Overview of the VBA Essentials
  • Connecting to external data
  • Preparation of datasets
  • Develop charts and build data visuals
  • Analyse data with Pivots
  • Reporting the results in other MS applications

Module 1: VBA overview

Objects, Dimensions, Loops, and Decisions

Module 2: Connecting to data

Understanding connections, importing data, coding the Power Query

Module 3: Data Preparation

Importance of data preparation, data preparation techniques

Module 4: Visualise data

Report building with tables, graphs, and charts

Module 5: Analyse data

Introduction to Pivot reports, building a PivotTable, and creating the PivotChart

Module 6: Reporting the results

Introduction to external libraries – PowerPoint, Outlook, and the FileSystemObject



Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Denmark facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

Classroom / Virtual Classroom
27 november 2024
Kopenhag, Aarhus, Odense
2 Days
Classroom / Virtual Classroom
12 december 2024
Kopenhag, Aarhus, Odense
€2,210 +VAT Book Now
Classroom / Virtual Classroom
06 januar 2025
Kopenhag, Aarhus, Odense
2 Days
Classroom / Virtual Classroom
27 november 2024
Kopenhag, Aarhus, Odense
2 Days
Classroom / Virtual Classroom
12 december 2024
Kopenhag, Aarhus, Odense
€2,210 +VAT Book Now
Classroom / Virtual Classroom
21 januar 2025
Kopenhag, Aarhus, Odense
2 Days
Classroom / Virtual Classroom
25 januar 2025
Kopenhag, Aarhus, Odense
2 Days
Classroom / Virtual Classroom
06 januar 2025
Kopenhag, Aarhus, Odense
2 Days

Related Trainings

Microsoft Office - VBA Advanced Training Course in Denmark

Denmark is a constitutionally unitary state that is in Northern Europe. The population of the country is 5.91 million and 800,000 of them live in the capital and largest city, Copenhagen. And Danish is the official language. Denmark is a part of Scandinavia, like Norway and Sweden. The country experiences changeable weather, since it's located in the meeting point of diverse air masses. The coldest month of Denmark is February while July is the warmest month.

The most popular tourist attractions are Tivoli Gardens, Nyhavn, Kronborg Slot and Viking Ship Museum. Tivoli is considered as the inspiration behind the Disney theme parks, which also contains roller coasters, puppet theaters, restaurants and food pavilions. And the reason why Kronborg Slot attracts tourists is because the castle is the setting of Shakespeare's Hamlet, and also a UNESCO World Heritage Site.

With a focus on meeting the unique requirements of Denmark, Bilginç IT Academy integrates advanced training methodologies into our diverse range of Certification Exam preparation courses and accredited corporate training programs. Prepare to revolutionize your perception of IT training with us.
By using this website you agree to let us use cookies. For further information about our use of cookies, check out our Cookie Policy.