Free Classified Ads in United Arab Emirates
Home >> Classes >> Computer - Multimedia Classes >> Microsoft Excel VBA course in Dubai

Microsoft Excel VBA course in Dubai | Please contact us

Next Previous
Ad Options
  • Call me on
    0552239282
  • AD Type

    Offered

  • AD ID
    3420
  • Ad Posted on
    February 6, 2019
  • Ad Modified on
  • Ad Viewed:
    9 times
  • Business
  • Member Profile
  • Member ID
    272
  • Member Location
    Dubai , United Arab Emirates
  • Member Since
    2018-03-06 08:36:15
  • Total Listed Ads
    106
Description
  • Call Me On
    0552239282

Do you want to automate your routine tasks and customize Excel UI? Enroll with MCTC Dubai and learn on your schedule, with affordable fees, from well qualified and highly experienced trainers!.VBA, which stands for Visual Basic for Applications, is a programming language developed by Microsoft. Excel, along with the other members of Microsoft Office 2003, includes the VBA language (at no extra charge). In a nutshell, VBA is the tool that people use to develop programs that control Excel.


During our training, we will cover:


Features



  • Automating repetitive operations

  • Automating a task you perform frequently

  • Inserting a text string

  • Automating repetitive operations

  • Creating a custom command

  • Creating a custom toolbar button

  • Creating a custom menu command

  • Creating a simplified front end

  • Developing new worksheet functions

  • Creating complete, macro-driven applications

  • Creating custom add-ins for excel


The VBA Language



  • Simple Input & Output

  • Variables & Data Types

  • VBA & Worksheet Functions

  • Object Type Variables

  • Branching: IF…THEN

  • Branching: SELECT…CASE

  • Looping: DO…LOOP

  • Looping: FOR…NEXT

  • Looping: FOR…EACH

  • User-Defined Functions

  • Variable Scope

  • Error Handling


Launching Macros: Events & Shortcuts



  • Macro Launching Shortcuts

  • Modifying the Ribbon

  • Workbook & Worksheet Events

  • Application Events

  • Project 2 – Event Handling

  • Launching Macros: Events & Shortcuts


Modifying the User Interface



  • Enhanced Message Box

  • ActiveX & The Worksheet (No Code)

  • ActiveX & The Worksheet (With Code)

  • Basic User Forms

  • Project 3 – User Forms & ActiveX

  • Modifying the User Interface


Object-Oriented Programming



  • Classes and Objects

  • Creating classes

  • Creating and Destroying Objects

  • Create methods

  • Create property

  • Validation data using property

  • The default properties and methods

  • Error handling in the class


For further queries, feel free to contact us on 0552239282/ 042970083 / 042556969


www.mctcdubai.com

Stay Safe

Our top tips for safe and secure shopping
These tips can help you determine that you're shopping with secure and trustworthy sellers.


  • Avoid deals that are too good to be true.
  • Deal with people in your area by meeting face to face to see the item.
  • Never provide your personal or banking information.
  • See our Safety tips regarding vehicle buying and selling.
  • Follow the guide lines about How to shop online more safely?
  • How to spot scam ads?
  • How to protect yourself?
  • Were you a victim of an online scam? See our safety advice and tips
Add a Comment
Leave your comments
Comments about Microsoft Excel VBA course in Dubai

Similar ads

About Us

Post a Free Classifieds ad around the world for Cars, Van, Truck, Heavy machinery, Property for sale, for rent, Jobs, Community News, Pets, Travel, Classes, Services and many more for free all at ZoBaZo.com (Trading name of Stockkcots Ltd) London, UK.

Newsletter

Free Weekly Deals
Be the first to know about new deals, offers and product updates free.

zobazo Help Button
Find us on Facebook