Venue
Dusit Thani Manila
Dusit Thani Manila, 1223 Epifanio de los Santos Ave, Makati, 12242 Metro Manila

What is Qwoted?

Qwoted is a free expert network: we help reporters connect with experts & we help those same experts build relationships with top reporters.

Event Date Thu Mar 12 +08 - Fri Mar 13 +08 (almost 2 years ago)
In your timezone (EST): Wed Mar 11 8:30pm - Fri Mar 13 5:00am
Location Dusit Thani Manila
1223 Epifanio de los Santos Ave, Makati, 12242 Metro Manila
Region APAC
Details

Microsoft Excel is an extremely powerful tool that you can use to manipulate, analyze, and present data. Sometimes though, despite the rich set of features in the standard Excel User Interface (UI), you might want to find an easier way to perform a mundane, repetitive task, or to perform some task that the UI does not seem to address. Fortunately, Office applications like Excel have Visual Basic for Applications (VBA), a programming language that gives you the ability to extend those applications.

VBA works by running Macros, step-by-step procedures written in Visual Basic. Once you have learned VBA, it becomes much easier to learn a whole lot more – so the possibilities are limitless.

Topics covered:
• Recorded Macros
• Tagging Macros
• Understanding VBA – Programming Language
• Using the VBA Editor
• The VBA Editor
• Opening & closing the Editor
• Working with the Project Explorer
• Working with the Properties window
Working with and Work Area
Working with A Code Module
Setting Breakpoints in the Editor
• Using Variables
• Using Excel Objects
• Programming – Functions, Statements and Structures
• Programming User Forms
About Custom Forms
Handling Forms Events
Project Transferring Dara From A Form
Running Form

Speakers

2020 Speaker

Maria Anna Masindo
Wholebrain Training & Consultancy