This training is for professional development and the certificate obtained does not replace the MYK certification required for training programs that demand it.

Training Objective

By taking this training, you will learn the VBA programming language and use MS Office Excel more effectively. You will be able to create Excel files in a more organized way and automate your repetitive tasks to save time.

Who Should Participate?

This training is for individuals who are proficient in using MS Office Excel, particularly for employees in departments like information management and reporting, as well as any information workers handling report generation in their institution.

After completing this training, participants will:

• Learn Visual Basic for Applications (VBA) to automate repetitive tasks in MS Excel.
• Develop their own applications using VBA code in MS Excel.
• Create and assign macros in Excel.
• Learn basic concepts through the VBA window.
• Understand operators, loops, procedures, and function structures in detail.
• Perform error checking in their code and create user forms.

Training Content

Module 1: Overview and Macro Recording

• General Information About Macros
• Types of Macros
• Recording a Macro
• Running a Macro
• Editing a Macro
• Warnings When Opening a Macro-Recorded Workbook
• Understanding Macro Viruses
• Detecting Excel Viruses
• Changing Protection Levels for Macro Virus Protection
• Changing Macro Options
• Assigning a Macro to a Button or Menu
• Deleting Recorded Macros
• Addresses in Macros

Module 2: Introduction to the Visual Basic for Applications (VBA) Window

• Writing Programs (Macros) in Visual Basic
• Project Window
• Properties Window
• Encrypting Codes

Module 3: Variables, Loops, Conditional Structures

• Variables and Data Types
• Types and Declarations of Variables
• Constants
• Loops
• Loop Types
• For Each...... Next
• Do While......Loop
• Do .......Loop While
• Do Until...... Loop
• Do.....Loop Until
• Goto Loop
• Conditional Structures
• If.....Then....Else
• Select Case

Module 4: Introduction to Writing Code

• Selecting Cells
• Selecting Rows
• Selecting Columns
• Selecting All Cells
• Selecting All Cells in a Selected Row
• Selecting All Cells in a Selected Column
• Selecting Filled Cells Around Active Cell
• Finding the Number of Selected Cells
• Finding Row / Column Count of a Selection
• Finding Selection Count
• Writing Formula to a Cell
• Assigning Value to a Cell
• Assigning Value to Selected Cells
• Auto Formatting
• Assigning the Same Value to All Selected Cells
• Changing Cell and Font Properties
• Automatically Filling Cells
• Filling Target Cells Based on Source Cells
• Assigning Random Numbers to Cells
• Running Other Applications from Excel

Module 5: Workbook and Worksheet Codes

• Saving Active Workbook
• Saving All Open Workbooks
• Closing Active Workbook
• Adding a New Workbook
• Opening an Existing Workbook
• Adding a New Worksheet to a Workbook
• Selecting a Worksheet
• Moving a Worksheet
• Finding Number of Worksheets
• Getting the Active Worksheet's Name
• Sorting Worksheets from Smallest to Largest
• Counting Filled Cells in Selection
• Finding Visible Cells on the Screen
• Excel Window Position

Module 6: MsgBox and InputBox

• Message Box - MsgBox
• MsgBox Function
• Data Entry Box - InputBox
• Selecting Cell Range in InputBox
• Application Object in InputBox Function

Module 7: Offset, Character, WorksheetFunction, Set

• Offset Function
• Interacting with Characters Inside Cells
• WorksheetFunction Object Properties
• Sum Function
• SumIf Function
• Count Function
• CountA Function
• CountBlank Function
• CountIf Function
• Min Function
• Max Function
• Rank Function
• Set Assignment Statement

Module 8: Copy-Paste Operations

• Copy and Paste
• Reverse Paste (Undo Operations)
• Copying a Worksheet
• Moving a Worksheet

Module 9: Operators

• Arithmetic Operators
• Comparison Operators
• Logical Operators
• LIKE Operator
• IS Operator
• Logical Operators (NOT, AND, OR)

Module 10: Functions

• Creating Functions
• User Defined Functions
• Common Functions
• Date, Day, IsDate, IsEmpty, IsNumeric, and other Date/Time/Conversion Functions

Module 11: UserForms and Their Properties

• Forms
• Option Explicit

Module 12: Toolbox and Control Objects

• Toolbox
• Label
• TextBox
• ComboBox
• ListBox
• OptionButton
• Checkbox
• Group
• Frame
• ScrollBars
• ToggleButton
• RefEdit
• Image

Module 13: Events

• Activate
• Change
• Click
• DblClick
• Enter
• Exit
• Initialize

Module 14: Filtering and Sorting Operations

• Auto Filtering
• Subtotals and Sorting
• Print Preview and Printing

Module 15: Error Handling

• Debugging Window
• Error Handling Statements

Training Process

• The training will be held online (via the internet).
• To participate, you need internet access and a suitable data plan.
• A device with camera and microphone capabilities (smartphone, tablet, preferably computer) is required to access the training system.
• Participants must log in to the system at the specified class times with their cameras and microphones turned on, along with the instructor.
• Before the training, participants will receive their username and password via email.
• The system will remain open for 7 more days after the training ends, closing completely at 11:00 PM on the seventh day.
• A WhatsApp group will be created for support, with the admin sending messages. All support information will be provided by the admin during the training, and any questions can be sent to usem@uludag.edu.tr, with emails monitored in real-time during training.

The training is open for institutional cooperation (company/institutional package), and individual applications are not accepted. The training content can be re-planned based on the corporate profile and needs. After mutual discussions, the scope and method of training (Face-to-Face or Online) will be determined and the relevant processes will be completed. If agreed, the training date and time will be scheduled according to the availability of participants from your institution and our trainers.