UAE | NZ +971 65464400 | +971 506016017 | +64 22 4563165

Office Address

  • #207 #208, Bin Hamooda Building,
    AlBustan, Liwara 2, Near ABCD Bank
    Ajman, UAE
  • theunitedinstitute@gmail.com
  • +971 54 7899 234 ,0506016017

Our Courses

Advanced Excel +VBA

Advanced MS Excel + VBA Training Course in Ajman

This Advanced MS Excel course covers all of the fundamentals and advanced concepts of VBA Excel. It's a mix of Visual Basic, Microsoft's event-driven programming language, and Microsoft Office applications like Excel.

Advanced Excel+VBA-pic

VBA allows you to automate a variety of tasks in Excel, such as creating reports, creating charts and graphs, and performing calculations. Macro is another name for this automation activity. In this way, users can save time by not having to repeat the same steps over and over again.
Excel VBA allows you to write instructions for various applications using English-like statements. Excel VBA is simple to learn and use, with an intuitive user interface that allows you to drag and drop interface controls. It also allows you to customize Excel's functionality so that it works the way you want it to.VBA is used for both personal and professional purposes. Simple VBA macros for personal use can help you automate your daily routine tasks. You can use VBA to create powerful programs and leverage the power of Excel in your custom programs for business purposes.


Who this course is for:
• Automate a variety of tasks
• Want to save a lot of time working with Excel

What you’ll learn:
• Concepts of VBA Excel
• Learn Intuitive User Interface


United Excel Courses

Course Overview

    Session 1: Introduction to VBA :
  • 1.01 Introduction to Excel
  • 1.02 Introduction to Programming
  • 1.03 VBA Overview and the IDE
  • 1.04Quick Review of Macros
  • 1.05 Working with Macros
  • 1.06 How to use Visual Basic Editor (Programming Environment)
  • Session 2: Advantages of VBA
  • 2.01 An easy-to-use and versatile language
  • 2.02 Integrated with off-the-shelf products
  • Session 3: Understanding the VBA editor, Module and Procedures
  • 3.01 The Visual Basic Editor
  • 3.02 Parts of the VBA Editor
  • 3.03 Modules and Macros
  • 3.04 About VBA Forms, Sub Procedures & Modules
  • 3.05 Creating Forms
  • 3.06 Using Controls and their Properties
  • Session 4: VBA Syntax and Grammar
  • 4.01 Objects – The Grammar
  • 4.02 Using Properties and Methods
  • 4.03 Understanding Parameters
  • 4.04 The Object Browser
  • 4.05 Understanding object hierarchy
  • 4.06 Tools for better coding
  • 4.07 Moving to Other Cells
  • 4.08 Editing Specific Cells
  • Session 5: Storing data in variables
  • 5.01 How and when to declare variables
  • 5.02 Selecting data types
  • 5.03 Fixed and dynamic arrays
  • 5.04 Constants
  • Session 6: Control struture and Program Flow
  • 6.01 IF (Else If, Else)
  • 6.02 Select Case()
  • 6.03 For Next Loop
  • 6.04 For Each Loop()
  • 6.05 Do Until Loop and Do While Loop
  • 6.06 With, End With
  • 6.07 Nesting Code
  • Session 7: Building Procedures
  • 7.01 Creating Sub and Function procedures
  • 7.02 Calling procedures
  • 7.03 Passing arguments to procedures
  • Session 8: Building Intuitive User Interfaces
  • 8.01 Communicating with the user through the message box
  • 8.02 Gathering user information with the input box
  • 8.03 Utilizing the File Dialog object and Dialogs collections
  • Session 9: Variables, Arrays & Constants
  • 9.01 Using the Immediate Window
  • 9.02 Gaining greater control through the immediate window
  • 9.03 Formatting Cells
  • 9.04 Using Variables
  • 9.05 Constants
  • 9.06 Object Variables
  • 9.07 Dimensioning and usage of variables
  • 9.08 Displaying data and obtaining data from the user
    Session 10: Creating customized dislogs with User Form objects
  • 10.01 Command buttons
  • 10.02 List and Combo boxes
  • 10.03 Labels
  • 10.04 Option buttons
  • 10.05 Check boxes
  • 10.06 Text boxes
  • 10.07 Frames
  • 10.08 Adding more functionality with advanced ActiveX control
  • Session 11: Fonts & Background
  • 11.01 Using Font Property in cells
  • 11.02 Using Various Background Properties in Excel VBA
  • 11.03 Creating a Counter
  • 11.04 String Handling
  • 11.05 Using Left, Right, Mid and Len Functions in VBA
  • 11.06 Range Selection and Manipulation
  • Session 12: Objects and Collections
  • 12.01 Workbook and Worksheet Object
  • 12.02 Range Object and Cell Properties
  • 12.03 Methods and Properties
  • 12.04 Assigning Objects
  • 12.05 Using Name Arguments
  • Session 13: Array
  • 13.01 What is Array& why use array
  • 13.02 Declaring an Array
  • 13.03 Sorting Data in Array
  • 13.04 2-Dimention Array
  • 13.05 Dynamic Array
  • 13.06 UBourd
  • 13.07 Storing Data in a range of an Array Elements
  • 13.08 Using various array functions
  • Session 14: Functions
  • Using Excel Worksheet Functions in VBA
  • 14.02 VBA Functions
  • 14.03 User-Defined Functions
  • 14.04 Adding Help to User Defined Functions
  • 14.05 Declaring Variables in User Defined Functions
  • 14.06 Using Ranges in User Defined Functions
  • 14.07 Creating and Managing an Add-in for User Defined Functions
  • Session 15: Error Handling
  • 15.01 Run Time Error
  • 15.02 GoTo line
  • 15.03 GoTo 0
  • 15.04 GoTo 1
  • 15.05 Resume Next
  • Session 16: Internet and Excel
  • 16.01 Copy Hyperlinks and Text from a webpage to Spreadsheet
  • Session 17: Interacting with other office Apllications
  • 17.01 Communicating with Word and PowerPoint using Excel VBA
  • Session 18: Running SQL Queries within Excel Environmment
    Session 19: Modifying Menus and Toolbars
  • 19.01 Simplifying user interaction with the Command Bar object
  • 19.02 Adding and removing CommandBarControl objects
Call Us Now
0506016017 | 065464400