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
- 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.
Book Your Seat
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
Variables, data types and constants
Looping constructs (For loops, Do loops, While loops)
Working with objects properties, events, and methods
Workbook objects, Worksheet objects and Range objects
Pivot table objects
Creating custom menus and toolbars
Working Word, PowerPoint, Outlook and other applications