Microsoft Excel Automating with Macros and VBA Eğitimi

• Navigate, edit and manage Excel workbooks
• Format worksheets and workbooks
• Understand the difference between absolute and relative references
• Understand the basics of Excel formulas and functions, e.g. Sum, text functions

Learning Outcomes

• Create, edit and run Macros
• Use VBA and examine the Visual Basic Editor
• Work with Procedures and Subroutines

Course Outline

• Macros and VBA explained
• Recording Macros
• Running recorded Macros
• Exploring the Visual Basic Editor
• Editing a Macro
• Adding macros to shortcuts, Quick Access Toolbar and Command buttons
• Understanding Modules
• Understanding Procedures
• Create a Subroutine
• Create a Function procedure
• Calling Procedures
• Scope (Public versus Private procedures)