Education Information

• Purpose of Education: This education will teach VBA software language so you can use effective MS Office programs. You will save time by creating Excel files more regularly and automating repeated operations.
• Who Can Participate: Suitable for individual participants and corporate employees who can use advanced MS Office Excel programs.
• Education Dates: First preregistration is required, then trainings are scheduled according to demand.
• Method of Education: Online education (synchronous)
• Duration: 24 hours
• Number of Participants: Minimum 10 people

Learning Outcomes

• Learn Visual Basic for Applications (VBA) to automate routine Excel operations.
• Develop own applications using VBA codes in Excel.
• Create recording macros and assign macros to objects.
• Learn basic concepts using the VBA window, operators, loops, procedures, and function structures.
• Create user forms and perform error checking in codes.

Education Content

• Module 1: Overview and Record a Macro
  • General knowledge about macros
  • Types of macros
  • Recording a macro
  • Running a macro
  • Editing a macro
  • Macro warnings and virus protection
  • Assigning macros to buttons/menus
  • Deleting saved macros
  • Addresses in macros
• Module 2: Learning Windows VBA
  • Writing macros in VBA
  • Project window
  • Properties window
  • Encrypting codes
• Module 3: Variables, Loops, Conditional Structures
  • Variables and data types
  • Constants
  • Loops (For Each, Do While, Do Until, etc.)
  • Conditional structures (If...Then...Else, Select Case)
• Module 4-15: Writing code, workbook/worksheet operations, MsgBox/InputBox, functions, user forms, events, error checking, filtering, sorting, etc.

Education Process

Training will be broadcast live online.

Participants must have internet access, camera, and microphone. Devices such as smartphones, tablets, or preferably computers can be used.

Participants will join the system with cameras and microphones turned on during specified hours.

Usernames and passwords will be sent to participants via email before training starts.

The system remains open for 7 days after completion. By the 7th day at 23:00, the system closes completely.

A WhatsApp group will be created for support messages sent only by the administrator. Participants may contact usem@uludag.edu.tr for any issues.

Important Information

• Certificates are issued for 80% or above attendance. No certificates for 79% or below attendance.
• After training completion, certificates will be issued and sent via PTT Cargo. Make sure your address is up-to-date.
• All questions can be sent to usem@uludag.edu.tr during training. E-mails are monitored in real-time.
• Applications and tuition payment are online. Installment payments are not available via bank/credit card.