VBA Training – Advanced Level

Catalogue index: IFS/69

  • In stock
  • Delivery: free
  • Dedicated training:
  • Producer:
  • Training level:
    • Zaawansowany
  • Type of training:
    • stacjonarnie; online
PLN993.33 net / particip. PLN14,899.95  net for 1 workshop PLN1,221.80 gross incl. 23% VAT / particip.

product- line 1

Features

Features
Certification:
  • TAK
Dedicated training:
Number of training hours:
  • 16
Producer:
Training language:
  • polski
Training level:
  • Zaawansowany
Type of training:
  • stacjonarnie; online

Description

Company Description

InfoShare Academy is a leading IT academy offering comprehensive educational programs in new technologies for companies. Since 2015, we have been supporting organizations in developing technology teams through dedicated courses in Machine Learning, DevOps, Data Engineering, Python, UX/UI Design, AWS, and Kubernetes. Our training is based on practical skills and real business cases. We collaborate with over 300 industry practitioners, ensuring that our programs are tailored to current market needs. We specialize in reskilling and upskilling employees. With us, you will build effective teams implementing new technologies that will accelerate innovation and strengthen your company's competitiveness in the market. Check out our training offerings designed for companies, created to enhance your employees' competencies in the IT field.

Training Description

Are you looking for a way to effectively automate tasks in Excel? The "Advanced Programming Techniques in VBA" training is dedicated to individuals who want to expand their knowledge of programming in Visual Basic for Applications (VBA) and utilize advanced techniques for data manipulation, file handling, and integration with other Microsoft Office applications.

Who is the training for
  • For individuals with basic knowledge of programming in VBA or experience working with spreadsheets in Excel.
  • For data analysts, financial controllers, business analysts, and anyone looking to enhance their skills in automating tasks in Excel.
Objectives

 

Benefits

Take your automation skills in Excel to the next level and learn advanced programming techniques that will enable you to effectively manage data and integrate with other Microsoft Office applications. Join our training and gain the essential knowledge and skills to become an expert in VBA programming!

Training Program

  • Module 1: File and Folder Operations

    • Creating and Deleting Folders

    • Modifying Files and Folders

  • Module 2: Using FSO for File and Folder Operations

    • Checking if a File or Folder Exists

    • Generating a List of Files in a Folder

  • Module 3: Importing and Exporting Data Between Workbook and Text File

  • Module 4: Opening Files Using Shell Function

  • Module 5: Creating and Unpacking ZIP Archives

  • Module 6: Importing Data from Workbooks

    • Using the Open Method to Open a Workbook

    • Importing Data from a Closed Workbook Using ExecuteExcel4Macro

    • Importing Data from a Closed Workbook Using ADO Object

  • Module 7: Integrating Excel with Microsoft Office Applications

    • Sending Emails from Outlook Application

    • Connecting with Word to Generate Documents

  • Module 8: Recursive Procedures

Duration

16 hours/2 days

Price Includes
  • Certificate of Completion
  • Monthly Access to Training Recording (for online format)
  • Customization of Training Program to Client Needs

Zamów szkolenie