Microsoft Excel. Level 4. Macros in VBA - course RUB 27,990. from Specialist, training, Date: November 30, 2023.
Miscellaneous / / December 03, 2023
The latest version of Microsoft Office 2019/2016 has a built-in programming language called Visual Basic for Applications (VBA) still remains the main most important means of automating the work of users with office applications.
The largest number of application tasks that require the use of macros arise when working with Excel spreadsheets. Experienced users can independently cope with automation issues in Microsoft Excel 2019/2016 if they master the capabilities of programming macros in VBA.
The training course is designed for specialists who constantly use Excel in their daily professional activities and who want to learn how to parse program code in VBA and program macros yourself, which will allow you to automatically perform repetitive routine actions, save time and increase efficiency labor.
The basic commands of the VBA language and basic Excel objects are compatible at the macro level with previous versions of Excel, so the knowledge gained in the course and Macro programming skills can be successfully applied both in Microsoft Excel 2019/2016 and in earlier versions of Microsoft Excel 2013/2010.
We help our graduates with employment: we teach them how to write a strong resume, introduce them to employers and advise them on how to pass interviews.
Upon completion of the course, students receive a Certificate from the Center “Specialist”
You will learn:
-Use automatic macro recording in Excel and correct shortcomings of automatically generated program code
-Create projects in the VBA editor, edit, debug and execute program code
-Program work with variables, conditional jumps and loops, dialogs for entering values and displaying messages
-Program access and control of Excel objects (such as workbook, worksheets and cell ranges)
-Create and apply custom functions
6
coursesA true expert teacher, Microsoft Certified Trainer. Andrey Nikolaevich has more than 15 years of teaching experience. He is able to present the most complex material in an accessible manner. Its grateful graduates invariably note the friendliness towards students, the use of practical examples...
A true expert teacher, Microsoft Certified Trainer. Andrey Nikolaevich has more than 15 years of teaching experience. He is able to present the most complex material in an accessible manner. Its grateful graduates invariably note the friendliness towards students, the use of practical examples from life in the classroom and the desire to convey all their vast experience and deep knowledge.
Andrey Nikolaevich graduated with honors from the Moscow State Aviation Technological University (RGTU named after. TO. E. Tsiolkovsky). He worked as a research assistant at the Central Institute of Aviation Engine Engineering (CIAM) named after. P.I. Baranova. He has been teaching at Specialist since 1999. Specializes in providing training on Microsoft Access databases and programming in the Microsoft Office environment in VBA. In addition to teaching at the Center, he provides consulting services and participates in the development of applications for desktop databases and automation projects for Microsoft Office applications.
Author of popular training courses “Visual Basic for Application (VBA). Automation of work in Microsoft Excel", "Microsoft Access. Database development" and many others. The teacher has many publications in the popular computer magazine “Computer Press”.
Over the years of teaching at the center, Andrei Nikolaevich has successfully trained several thousand specialists. Among its graduates are employees of many large companies and organizations, including Coca-Cola, Bosco Sport, Dirol Cadbury, Michelin, Bosch-Siemens, Canon and many others.
5
coursesPractical teacher, professional in analytics and production reporting. Winner of the prestigious international certification MOS Excel 2019 Expert. Microsoft Certified Trainer. In his work with PC users, he always takes into account the entry level...
Practical teacher, professional in analytics and production reporting. Winner of the prestigious international certification MOS Excel 2019 Expert. Microsoft Certified Trainer. In his work with PC users, he always takes into account the initial level of knowledge of students and strives to show the most effective options for performing actions for each production task!
Andrey Vladimirovich graduated from MIIT in 2009 with a degree in Economics and Transport Management. Later he received a second higher education degree in World Economics (diploma with honors). He worked for OJSC Russian Railways for more than 9 years and for 3 years at NefteTransService, where he was the chief specialist in the analytics and reporting departments.
Andrey Vladimirovich’s total experience with Excel is 12 years. He has mastered the basic functions of data analysis, has extensive experience in writing macros and creating pivot tables, and knows how to work with the PLEX add-in. During classes he is always attentive to questions and comments. Calm. It is not difficult for him to explain some point several times if the listener could not understand it the first time.
Module 1. Automatic macro recording in Microsoft Excel 2019/2016 (2 ac. h.)
-Using a macro recorder to record a macro in Microsoft Excel 2019/2016
-Use of absolute and relative links when recording a macro
- Correction of deficiencies in automatically generated program code
Module 2. Working in the Visual Basic editor. Fundamentals of programming in VBA (6 ac. h.)
-Creating a VBA project. Using the Project Window. Working with modules.
-Entering and editing program code
-Create, save and run a VBA procedure
-Data types, variables, constants
-Instructions for controlling the order of command execution: If...Then...Else and Select Case
Module 3. Programming Excel objects. Properties and methods of workbooks, sheets and cell ranges (6 ac. h.)
-The concept of object-oriented programming
-Excel object model, object references
-Overview of Workbook object properties and methods
-Sheet management: using the Worksheets collection and the Worksheet object
-Working with cell ranges: using the Range object, its properties and methods
-Using object variables and the With...End With construct
Module 4. Cycles: programming multiple actions (6 ak. h.)
-Types of loops in VBA
-Cycle with counter For... Next
-Cycles with condition Do... Loop
-Loop through objects For Each... Next
-Examples of cyclic operations with cells and sheets of Excel workbooks
Module 5. Creating a custom function. Examples of user functions (2 ac. h.)
-Creating a Function procedure
-Using Custom Function in VBA Procedure and Worksheet
-Solving common automation problems in Excel using custom functions
Module 6. Error processing. Debugging and testing a program (1 ac. h.)
-Types of errors
-Creating a Run-time error handling procedure
-Debugging and step-by-step testing of the program
Module 7. VBA project protection. Automation of running macros (1 ac. h.)
-Setting security levels
-VBA project protection
-Create custom buttons to run macros
-Using workbook and sheet events to run macros