EXCEL Macros Training in Dubai - Princeton Academy

For Beginners - Automate Excel MIS Reports & Presentations

If you need to generate multiple presentations for reporting, week over week, it can get repetitive and boring. In this workshop learn to automate all that ! You will learn to automate Excel functions so you can quickly and easily create and transform charts and slides into Impressive PowerPoint presentations.

This course will help you to write macros in Excel using Simple programming language - Visual Basic Application (VBA), as well as use Recorded macro and edit it to customize it to fulfil your requirements. You will also learn to write your own functions and procedures, design forms and work with add-ins using VBA Macro

Objectives:

  • Write macros to automate routine work.
  • Create functions and procedures.
  • Design and use forms for data entry.
  • Create reports.
  • Convert reports from Excel to PowerPoint

You can utilize excel programming for modifying the reports. Marco creations are possible through these courses. Our experts are well trained in giving these kinds of classes to individuals. If you see building macros is very complex or it’s farther than your capability, do not worry, our Excel VBA programming courses in Dubai are envisioned for individuals who are beginners in programming.

Program Outline

  • 04 Sessions
  • 08 Hours

  • Recording and running macro
  • Storing macro in different books
  • Creating buttons and assigning macro to it
  • Creating My Menu
  • What is Function and Subroutine
  • Writing Functions using VBA Editor
  • Calling function in other workbook
  • Editing macros using VBA Editor
  • Understanding the project explorer
  • Exploring windows properties
  • Modifying code in code window
  • Debugging code
  • Variables, data types and constants
  • Arrays
  • Object Variables
  • Conditional structures
  • Logical Operators
  • Looping constructs (For loops, Do loops, While loops)
  • Built-in functions
  • Creating Subroutines
  • Working with objects properties, events, and methods
  • Application objects
  • Workbook objects, Worksheet objects and Range objects
  • Charts objects
  • Pivot table objects
  • Creating forms
  • Form events
  • Creating custom menus and toolbars
  • Creating Add-ins
  • Working Word, PowerPoint, Outlook and other applications
  • Book Your Seat