MS EXCEL and VBA training + artificial intelligence (AI)
Learn the intricacies of automating Excel and increase your productivity!
- All lectures are held live online with a lecturer
- Runtime: 68 h 8 weeks - 23 classes
- Time: 3 times a week, 3 hours each, from 18.00:21.00 p.m. to XNUMX:XNUMX p.m.
- Possibility to repeat the course FREE 12 months after completing the course
- Access to lecture recordings
- July 10th Evening
Our students are working
Our students are working
What will I learn?
Possible job positions after training:
- Data analyst
- Business analyst
- Financial analyst
Training program
- introduction
- Excel window and files
- Actions with worksheets
- Operations with rows and columns
- Data entry
- Table decoration
- Cell formatting
- Data formats
- Independent task
- Fixing part of the worksheet
- Search in an Excel table
- Changing information in an Excel table
- Copying and pasting information
- Creating sequences
- Names of cell blocks
- Printing an Excel table
- Independent task
- Formula creation tools
- Arithmetic calculations in the table
- Absolute and relative coordinates
- Common functions
- Word processing functions
- Date functions
- Conditional functions
- Detection and elimination of errors in formulas
- Search functions
- Formula Audit Tool
- Independent task
- Compilation of the table
- Splitting text into columns
- Removing equal values from the list
- Sorting the list
- List filtering
- Conditional formatting
- List grouping
- Independent task
- Data protection during entry
- Password protect the file
- Data protection against corruption
- Different passwords for different parts of the table
- Independent task
- Combined table
- Selection of formula parameters
- Creating a data table based on the existing formula
- Script tool
- Creating and formatting a chart
- Chart data
- Chart axes
- Bar chart
- Pie chart
- Line chart
- Combined type charts
- Charts for monitoring stock price movements
- Thumbnails
- Creating and editing a dynamic table
- Calculations in a dynamic table
- Dynamic table layouts
- Data filtering
- Data grouping
- Dynamic table filtered reports
- Control of multiple dynamic tables with one filter
- Dynamic table parameters
- Dynamic chart
- Creation of Excel power query
- Creation of Excel power query
- Security settings for Excel macros
- Storage locations for macros
- Automatic recording of macros
- Calling macros
- Recording and calling a macro
- Independent task
- Macro programming environment
- Editing macro text
- Manually stopping macro execution
- Breakpoints
- Comments in the macro text
- Conditions (If -When – Else, Select – Case)
- Loops (For – Next, Do – While)
- Objects and collections in a macro
- Addressing cells in a macro
- File reference
- Cell count
- Final project example: Creating new Excel files
- Assigning a macro to a button
- Adding a macro to a menu
- Creating and calling a custom Excel function
- Final project assignment
- Assuredness
- Time management
- Effective learning
- Imposter syndrome
- feedback
- Emotional intelligence
- Critical thinking
- Prisitaikymas
- Problem solving
- Teamwork
- Conflict management
- Introduction to artificial intelligence and its basic concepts
- Main areas of AI: Natural language processing and computer vision
- How AI is transforming various industries and jobs
- Practical exercises in the application of DI
- Tips for integrating AI tools into everyday work tasks
- Case studies of successful AI integration
- Ethical aspects of AI and responsible use
- History and Evolution of Artificial Intelligence
- Additional resources and course summary
Registration for these trainings
You don't know which training choose?
Why is it worth studying with us?
Vilnius coding School CERTIFICATE
strong evidence that you are ready career ITEM!
Official certificate approved by the Education and Science Register
Recognized by the strongest companies in Lithuania and abroad
Reliable proof of acquired skills
The certificate confirms that you attended at least 95% of the course lectures, completed and defended the final thesis.
Flexible billing
The most popular ways
When paying the full amount at once:
You can pay the full amount for the training at once and receive it discount.
The discount applies to training courses lasting 160 hours or more.
Paying in installments without any increase in price:
The number of installments is agreed upon individually with each student.
Some training
paid by the company:
Company employees can join training groups. We apply discounts to employees of "partner companies" and "super company partners" whose training is paid for by the company or to employees who pay for training themselves.
Installments with GENERAL FINANCING BANK
Payment term up to 84 months.
Discount system
Normal cost of training
€ 500
ALUMNI
we apply a 15% discount!
€ 425
(Full price
500 €)
Applies to all school graduates for all training and weekend workshops
RECOMMEND US TO A FRIEND
we apply a 10% discount!
€ 450
(Full price
500 €)
Applies if you come to study as a couple
Employment success stories
2025 04 28
Edit
Edita is a great example that it is never too late to reinvent yourself and take a completely different career path. After completing data analytics training at VILNIUS CODING SCHOOL, she successfully found a job as a planning and operational data analyst. 📊✨ "Work …
2025 05 13
Mist
Miglė is a former stage artist who boldly stepped into a completely new field. After completing data analytics training at VILNIUS CODING SCHOOL, she got a job as a BI analyst at Danske Bank and is today successfully building her career in the IT sector. 📊 "If …
2025 04 10
Austėja
Changing your career direction is a bold decision that requires determination. 💡 Austėja is a great example of how change can open up new, exciting opportunities! From a project manager position, she retrained as a data analyst and today she successfully works at Mediaskopas. …
2025 03 27
Gabriele
Changing your career direction is never easy, but we are glad that Gabrielė bravely decided to make a change and is happy with her decision today. 🚀 From a psychologist, she became a data analyst at Futurae Media - a new challenge, new opportunities! 💡 …
VILNIUS CODING SCHOOL
Žalgirio str. 90,
Building A, 2nd floor,
Vilnius
For training questions, please contact:
[email protected]
For cooperation and other questions, please contact:
[email protected]
+370 606 75071
DETAILS
UAB "UAB Vilnius Coding School"
Company code: 304299909
Address: Žalgirio str. 90, Vilnius
Former address: Žalgirio st. 90
Company number: LT087044060008107796
AB SEB bankas, bank code: 70440
Phone: +370 606 75071
Email: [email protected]
