V1-en
Automation of work in MS Excel with VBA
|
beginner + intermediate 30 hours Classes in a computer room Certificate |
Rating course: 4,91/5,00 – 100% positive grades Coordinator: Przemysław Kusztelak PhD (pkusztelak@labmasters.pl) Software: Microsoft Excel 2016 in 2 language versions (EN / PL) Where: Faculty of Economic Sciences UW, Warszawa ul. Długa 44/50 – next to Ratusz-Arsenał metro station (map) |
847 zł*
*Podana cena kursu jest ceną:
- brutto (zawiera podatek VAT 23%), jeśli zakupu dokonują osoby fizyczne nie prowadzące działalności gospodarczej;
- netto (nie zawiera podatku VAT 23% – cena brutto 1041,81 zł), jeśli zakupu dokonują osoby fizyczne prowadzące działalność gospodarczą lub osoby prawne.
Cena zawiera m.in. certyfikat zdania egzaminu (na podstawie rozwiązanych zadań sprawdzających), zaświadczenie ukończenia kursu (na podstawie obecności), komplet materiałów w formie elektronicznej i papierowej, darmowe konsultacje (więcej), zajęcia w sali komputerowej lub w formie zdalnej (więcej) – do wyboru.
Course description
Why learn in English? Learning in English is beneficial to the participant for many reasons. Companies tend use English as a main language inside the office. Projects people work on are usually for different countries, which forces us to prepare them in English. It makes collaboration easier – if you work in a multinational company it is easier to explain something in Excel using English function names. Problem solving is easier as well – most of questions raised in the Internet regarding Automation of work in MS Excel with VBA are asked and answered in English. Those are only a few benefits of learning in English.
Automation of work in MS Excel with VBA begins with a short introduction to VBA environment, but ends in an intermediate level. You will learn how VBA editor works, how to record macros, edit code – but also how code is built and how to optimize it, how to define variables, how VBA syntax looks like – constructions, conditional statements, loops and dialog boxes. Course is very intensive. Numerous animations, presentations and examples will allow participants to create own macros after only a few hours of classes.
Registration is open
Course form: this course is currently available in the e-learning form.
Price: 550 zł
Date: flexible time – one year online access to the course.See Details
Sign up for english language
Right now registration for the stationary course Automation of work in MS Excel with VBA in english language is not active. If you are interested in participating in this course, register an initial willingness to participate. Thanks to this, you will receive information about a new course before anyone else and will have the priority.
Detailed course subjects
VBE editor structure.
Recording macros.
Developer tab, recording macros, relative and absolute references, running macros.
Structure and optimization of code.
VBE editor structure, Excel file elements, code syntax, procedure syntax, reading, describing and organizing recorded code.
Referencing ranges of cells.
ActiveCell, Selection, Cells, Range.
VBA objects.
Properties and methods, classes, collections, hierarchy.
VBA variables.
Numeric, text, logic, objective variables.
Functions and formulas in VBA.
Formulas in VBA, formulas in Excel, function in VBA, worksheet functions in VBA, functions (dialog boxes) MsgBox and InputBox.
Constructions.
With … End With, For Each … Next.
Conditional statements.
If … Then, Select Case.
Instructions.
GoTo, Dir.
Loops.
For … Next, Do … While, Do … Until.
Error handling.
Accelerating macro speed.
Numerous application examples.
Applying knowledge gained during the whole course and showing acquired skills, e.g. application importing periodic sales data (separate text files) to Excel, consolidating them into one database, creating reports for respective product groups or cities and saving them in separate xlsx and pdf files.
Learning results
On Automation of work in MS Excel with VBA course you will acquire the ability to automate work in MS Excel with Visual Basic for Applications (VBA) programming language. Subject matter consistes of the following: introduction to VBA, recording macros, editing code, its’ structure and optimization, defining variables: numeric, text, array, objective, constructions: With … End With, For Each … Next, conditional statements: If…Then…Else, Select Case, loops: Do While… Loop, Do Until… Loop, For… Next, instruction: GoTo, dialog boxes: MsgBox and InputBox. You will be able to automate e.g. importing data from many files, creating consolidated databases, dynamically setting ranges, editing and formatting ranges as well as whole worksheets, preparing periodic sales reports, printing selected ranges and exporting results to separate Excel and PDF files.
Participant opinions
„Amazing course!!! It is incredible how much knowledge Przemyslaw Kusztelak can give to participants in 30 hours of course and how much he can motivate to work! Phenomenal course program and great teacher! It’s hard to dream of a better programming course!!!”
„The best course I have ever attended! It leaves you wanting more!:)”
„Amazing teacher. Perfectly prepared. I recommend this course to everyone.”
„Great courses, the best I have ever attended. I will definitely sign up for more.”
„I believe that courses led by Mr. Kusztelak, this was my second, are conducted on a very high level, with a huge care for usability of the knowledge and provide a great alternative for other, expensive courses, that do not exhaust the subject enough.”
„Very well organized course. One of the best I had the occasion to participate in.”
„Course explains / organizes basic knowledge of VBA well. Exercises and examples are well selected, because they can be used in future work.”
„Very well thought course. Teacher cares that participants learn specific skills. Materials professional, thoughtful and well prepared. I will recommend this course to my colleagues.”
„For Mr Przemysław there should be another grade: Very well! and Definitely yes!”
„Course was prepared and conducted in an excellent. I will go to more than one course led by Mr Kusztelak again for sure.”
„Very professional attitude, nice contact. Teacher helps, explains and presents in an interesting way, showing practical use of vba and excel in everyday work (…).”
„Amazing course! I will gladly participate in a similar course – extended.”
„I will gladly sign up for advanced course.”
„Course was great! I have already recommended it to everyone at my work and I am starting to use gained knowledge right now:)”