VBA Training – Intermediate Level

Catalogue index: IFS/68

  • In stock
  • Delivery: free
  • Dedicated training:
  • Producer:
  • Training level:
    • Średniozaawansowany
  • 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:
  • Średniozaawansowany
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

The VBA training – intermediate level is a course intended for individuals who already have basic knowledge of programming in Visual Basic for Applications (VBA) in the Excel environment and wish to expand their skills with advanced techniques.

Who is the training for

The target group includes individuals working with data in Excel, including business analysts, financial specialists, and anyone who wants to use VBA more effectively for task automation and data analysis.

Objectives

 

Benefits

As a result, participants will gain advanced skills in programming in VBA, allowing them to manage data in Excel more effectively and automate processes, which will contribute to increased productivity and efficiency in working with data.

Training Program

  • Error Handling

    • Using the Err variable

    • Using labels to handle errors

  • Advanced Variable Types

    • Object Variables

    • Array Variables

  • Functions

    • Using the VBA editor functions

    • Using worksheet functions

  • Range Operations

    • Applying sample properties and methods of ranges

  • Functions

    • Creating functions using VBA

    • Using functions in procedures and in worksheets

  • Creating and Managing Excel Objects

    • Pivot Tables

    • Charts

Duration

16 h/2 days

Price Includes
  • Certificate of completion
  • Monthly access to the training recording (for online format)
  • Customization of the training program to client needs

Zamów szkolenie