Location:
Warszawa
Date:
17.08.2020 - 18.08.2020
Language:
PL
Net price:
PLN 1 200
Course objectives

The course allows you to gain a wide knowledge in the field of tasks automation in MS Excel, Visual Basic for Applications, form design, error handling.

Benefits

Acquiring skills of data processing, filtering and its analysis. Learning effective methods of working with MS Excel.

Acquiring the ability to use advanced methods of data analysis, creating reports, transforming data sets into information sets. Acquiring the ability to present information effectively.

Training scope
  • Automate tasks in sheets by recording macros
  • Environment overview, code management
  • Introduction to Visual Basic for Applications
  • Operators, procedures and functions in MS Excel
  • Controlling the course of the program
  • Interacting with the user
  • Using MS Excel objects from the VBA level
  • Designing forms
  • Error handling
  • Passing parameters
  • Event procedures
  • Tables
  • Work automation
Audience

People who know the MS Excel environment well (cell addressing modes, sorting, autofilter, ability to use basic functions).

Course objectives

The course allows you to gain a wide knowledge in the field of tasks automation in MS Excel, Visual Basic for Applications, form design, error handling.

Benefits

Acquiring skills of data processing, filtering and its analysis. Learning effective methods of working with MS Excel.

Acquiring the ability to use advanced methods of data analysis, creating reports, transforming data sets into information sets. Acquiring the ability to present information effectively.

Training scope
  • Automate tasks in sheets by recording macros
  • Environment overview, code management
  • Introduction to Visual Basic for Applications
  • Operators, procedures and functions in MS Excel
  • Controlling the course of the program
  • Interacting with the user
  • Using MS Excel objects from the VBA level
  • Designing forms
  • Error handling
  • Passing parameters
  • Event procedures
  • Tables
  • Work automation
Audience

People who know the MS Excel environment well (cell addressing modes, sorting, autofilter, ability to use basic functions).

The number of participants: 8-15 people

Duration: 2 days

Available language: PL/ EN

Available course material: PL / EN

Course form
Lecture, workshop.

Download materials

Download

Thank You!

Sorry, something went wrong.

Please refresh the page and try again.

Processing...

Download materials

Download

Other dates and locations

Office applications

MS Excel VBA

Location:
Gdańsk
Language:
PL
Date:
14.12.2020 - 15.12.2020
Net price:
PLN 1 200

Contact our expert with questions

about any of our trainings

Agnieszka Rzeczkowska

Training Practice Manager

CONTACT OUR EXPERT

Agnieszka Rzeczkowska

or drag and drop your file here

Allowed extensions: DOC, DOCX, PDF (max 5MB)

Thank you for filling out the form

We will look over your message and get back to you as soon as possible

Sorry, something went wrong and your message couldn’t be delivered

Please refresh the page and try again

Processing...

ITIL® and PRINCE2® are registered trademarks of AXELOS Limited, used under permission of AXELOS Limited. All rights reserved.
AgilePM® is a registered trademark of DynamicSystem Development Method Ltd.
All AgilePM® Courses are offered by Sii, an Affiliate of Quint Wellington Redwood, an Accredited Training Organization of The APM Group Ltd.
Lean IT® Association is a registered trademark of the Lean IT Association LLC. All rights reserved. Sii is an Affiliate of Accredited Training OrganizationQuint Wellington Redwood.
All prices presented on the website are net prices. 23% VAT should be added.

SUBMIT