Excel Advanced with VBA Training Course

Primary tabs

Course Language

This course is delivered in Polish or English.

Course Code

3029

Duration Duration

21 hours (usually 3 days including breaks)

Requirements Requirements

Ability to work with a spreadsheet, knowledge of Windows.

Overview Overview

Participants will be able to excel themselves, in the most optimal way to create, consolidate and manage data. A number of tools designed to streamline the work often significantly reduces the time to activities carried out so far and can help you design an application that could perform new tasks.

Course Outline Course Outline

Adjustment of the working environment

  • Keyboard shortcuts, facilities
  • Create and modify toolbars
  • Excel Options (autosave, input, etc.).
  • Options paste special (transpose)
  • Formatting (style, format painter)
  • Tool go to

Organization of information

  • Management sheets (naming, copying, color change)
  • Assign and manage the names of cells and ranges
  • Protect worksheet and workbook
  • Secure and encrypt files
  • Collaboration and track changes, comments
  • Inspection sheet
  • Create your own templates, charts, worksheets, workbooks

Data analysis

  • Logic
  • Basic functions
  • Advanced functions
  • Scenarios
  • Search by
  • Solver
  • Charts
  • Graphics support (shadows, charts, AutoShapes)

Database management (list)

  • Data consolidation
  • Grouping and outlining data
  • Sorting data (over 4 columns)
  • Advanced data filtering
  • Database Functions
  • Subtotal (partial)
  • Tables and Pivot Charts

Cooperation with other applications

  • Get External Data (CSV, TXT)
  • OLE (static and link)
  • Web Queries
  • Publication sheets on site (static and dynamic)
  • Publication PivotTables

Automation of work

  • Conditional Formatting
  • Create your own formats
  • Check the correctness
  • Recording and editing macros

Visual Basic for Applications

  • Create your own functions
  • Results in VBA
  • VBA Forms

Guaranteed to run even with a single delegate!
Public Classroom Public Classroom
Participants from multiple organisations. Topics usually cannot be customised
From 1500PLN
(70)
Private Classroom Private Classroom
Participants are from one organisation only. No external participants are allowed. Usually customised to a specific group, course topics are agreed between the client and the trainer.
From 1500PLN
Request quote
Private Remote Private Remote
The instructor and the participants are in two different physical locations and communicate via the Internet
From 2700PLN
Request quote

The more delegates, the greater the savings per delegate. Table reflects price per delegate and is used for illustration purposes only, actual prices may differ.

Number of Delegates Public Classroom Private Classroom Private Remote
1 1500PLN 1500PLN 2700PLN
2 1350PLN 1350PLN 1950PLN
3 1300PLN 1300PLN 1700PLN
4 1275PLN 1275PLN 1575PLN
Cannot find a suitable date? Choose Your Course Date >>
Too expensive? Suggest your price

Related Categories


Course Discounts

Course Venue Course Date Course Price [Remote/Classroom]
Administracja serwerem Apache Tomcat Kraków, ul. Rzemieślnicza 1 Mon, 2016-10-03 09:00 2344PLN / 1736PLN
Programming in Scala Poznan, Garbary 100/63 Tue, 2016-10-04 09:00 3479PLN / 2114PLN
Web Application Development in PHP Szczecin, ul. Małopolska 23 Tue, 2016-10-04 09:00 2688PLN / 2081PLN
Visual Basic for Applications (VBA) in Excel - Introduction to programming Warszawa, ul. Złota 3/11 Tue, 2016-10-04 09:00 1941PLN / 1504PLN
Introduction to Linux Poznan, Garbary 100/63 Tue, 2016-10-04 09:00 1640PLN / 1100PLN
Docker for Developers and System Administrators Gdańsk, ul. Powstańców Warszawskich 45 Wed, 2016-10-05 09:00 2507PLN / 1963PLN
Adobe InDesign Lublin, ul. Spadochroniarzy 9 Wed, 2016-10-05 09:00 1220PLN / 1144PLN
ITIL® Foundation Certificate in IT Service Management Warszawa, ul. Złota 3/11 Mon, 2016-10-10 09:00 2639PLN / 2076PLN
Visual Basic for Applications (VBA) in Excel - Advanced Wroclaw, ul.Ludwika Rydygiera 2a/22 Mon, 2016-10-10 09:00 1689PLN / 1296PLN
Market Forecasting Poznan, Garbary 100/63 Thu, 2016-10-13 09:00 2936PLN / 2112PLN
ITIL® Foundation Certificate in IT Service Management Łódź, ul. Tatrzańska 11 Mon, 2016-10-17 09:00 2639PLN / 2160PLN
Excel and VBA Programming for Audit and Finance Professionals Katowice ul. Opolska 22 Mon, 2016-10-17 09:00 1941PLN / 1682PLN
Effective working with spreadsheet in Excel Rzeszów, Plac Wolności 13 Tue, 2016-10-18 09:00 598PLN / 737PLN
Market Forecasting Warszawa, ul. Złota 3/11 Wed, 2016-10-19 09:00 2936PLN / 2112PLN
ITIL® Foundation Certificate in IT Service Management Szczecin, ul. Małopolska 23 Wed, 2016-10-19 09:00 2639PLN / 2134PLN
Podstawy inżynierii wymagań i analizy Gliwice ul. Karola Marksa 11 Thu, 2016-10-20 09:00 2735PLN / 1967PLN
ITIL® Foundation Certificate in IT Service Management Zielona Góra, ul. Reja 6 Mon, 2016-10-24 09:00 2639PLN / 2118PLN
Apache Tomcat and Java EE Administration Warszawa, ul. Złota 3/11 Mon, 2016-10-24 09:00 2344PLN / 1555PLN
A Practical Guide to Successful Pricing Strategies Poznan, Garbary 100/63 Wed, 2016-10-26 09:00 1427PLN / 1093PLN
Creating and delivering presentations in Power Point (social skills workshop) Poznan, Garbary 100/63 Thu, 2016-10-27 09:00 1572PLN / 1121PLN
Agile Project Management with Scrum Kraków, ul. Rzemieślnicza 1 Wed, 2016-11-02 09:00 1746PLN / 1449PLN
Adobe InDesign Lublin, ul. Spadochroniarzy 9 Mon, 2016-11-07 09:00 1220PLN / 1144PLN
Agile Project Management with Scrum Poznan, Garbary 100/63 Mon, 2016-11-07 09:00 1746PLN / 1315PLN
Administration of Linux System Olsztyn, ul. Kajki 3/1 Tue, 2016-11-08 09:00 1940PLN / 1509PLN
SQL Fundamentals Warszawa, ul. Złota 3/11 Wed, 2016-11-09 09:00 1358PLN / 853PLN
Excel For Statistical Data Analysis Warszawa, ul. Złota 3/11 Mon, 2016-11-14 09:00 1343PLN / 1031PLN
Visual Basic for Applications (VBA) in Excel - Advanced Białystok, ul. Malmeda 1 Mon, 2016-11-14 09:00 1689PLN / 1413PLN
Python Programming Szczecin, ul. Małopolska 23 Tue, 2016-11-15 09:00 5790PLN / 3824PLN
Creating and managing Web sites Kraków, ul. Rzemieślnicza 1 Mon, 2016-11-21 09:00 3410PLN / 2836PLN
Graphic techniques (Adobe Photoshop, Adobe Illustrator) Wroclaw, ul.Ludwika Rydygiera 2a/22 Tue, 2016-12-06 09:00 1963PLN / 1470PLN

Upcoming Courses

VenueCourse DateCourse Price [Remote/Classroom]
Kielce, ul. Warszawska 19Mon, 2016-10-17 09:001575PLN / 1450PLN
Tarnów ul. Kościuszki 10 Mon, 2016-10-17 09:001575PLN / 1450PLN
Katowice ul. Opolska 22Mon, 2016-10-17 09:001575PLN / 1450PLN
Opole, Wladyslawa Reymonta 29Wed, 2016-10-19 09:001575PLN / 1533PLN
Zielona Góra, ul. Reja 6Wed, 2016-10-19 09:001575PLN / 1350PLN

Some of our clients