如果现在你对VBA还一无所知，那可真得要Out了。

Excel VBA的功能很强大，用途也非常广泛，比如能使重复的任务自动化，创建报表，对数据进行复杂的操作等等，现在VBA已经成了会计人必备的技能，应用VBA可瞬间提高工作效率。有越来越多的求职者在AA、FA或MA的求职面试中都会被问及Excel-VBA的应用能力。毫不夸张地说VBA成了衡量你的职场竞争力的重要筹码之一，能否熟练运用VBA也关系到你的职场前途。

 

本课程  2 Sessions ，8个学时，包教包会，极高性价比，由财富500强资深会计师精心讲授，

 

课程中我们精心准备了10个VBA应用于工作的实际案例，循序渐进、手把手地教大家运用课程中学到的知识去解决工作中的问题，快速提高工作效率，比如：

 

● Expressions & Variables

● Procedures and Functions

● Work with Objects 

● Work with Event 

● Program Execution

● Forms and Controls

● PivotTable Object

● Images and Charts

 

这些实战案例展现了VBA解决实际问题，提高工作效率的强大功能，在今后的求职面试中大家可以借用这些case去展现自己的achievement、获得雇主的认可，让自己脱颖而出，快速拿到offer，而在入职工作后则可以举一反三，灵活应用这些案例去分析和解决工作中碰到问题，提高工作效率，让同事和雇主对你刮目相看。得到更多晋级加薪的机会。

 

心动不如行动，8小时闭门大课  极速提升VBA能力，让你在心仪大公司的面试中信心满满，再不用担心与FA或MA失之交臂！！！

 

咨询电话

 

报名方式

微信报名，微信号:  VickiAccounting

编辑信息：“姓名、电话、Email” 并注明“报名VBA课程”提交给我们，待确认后会微信通知

 

 

VBA Course Outline

 

Using the VBA editor

·    The VBA editor.

·    Opening and closing the editor.

·    Working with the project explorer.

·    Working with the properties window.

·    Working with the work area.

·    Working with a code module.

·    Setting breakpoints in the editor.

·    Stepping through a procedure.

 

Procedures

·    About procedures.

·    Creating a command procedure.

·    Making sense of intellisense.

·    Using the edit toolbar.

·    Commenting statements.

·    Indenting code.

·    Bookmarking in procedures.

 

Using variables

·    Understanding variables.

·    Creating and using variables.

·    Implicit and explicit declarations.

·    The scope of variables.

·    Procedure level scoping.

·    Module level scoping.

·    Passing variables by reference.

·    Passing variables by value.

·    Data types.

·    Declaring data types.

·    Using arrays.

 

User defined functions

·    About functions.

·    Creating simple user-defined functions.

·    Using user-defined functions.

·    Using multiple arguments.

·    Modifying a function.

·    Creating a function library.

 

Using Microsoft Excel objects

 ·    Application methods and properties.

·    Workbook methods and properties.

·    Viewing Microsoft Excel and the editor together.

·    Using workbook objects.

·    Worksheets methods and properties.

·    Using worksheet objects.

·    Range methods and properties.

·    Using range objects.

·    Using objects in a procedure.

 

Programming techniques

·    Sending messages to the user.

·    Inputbox techniques.

·    Using the inputbox function.

·    Using the inputbox method: the if statement Using if for single conditions.

·    Using if for multiple conditions.

·    The select case statement.

·    Using the select case statement for loop.

·    Looping with known or specified iterations.

·    The do...loop statement.

·    Looping with unknown iterations.

 

Automatic startup

 ·    Programming automatic procedures.

·    Running automatic procedures.

·    Automatically starting a workbook.

 

By the end of this course participants should be able to:

 ·    Work with the VBA editor

·    Understand VBA concepts and features

·    Enable or disable VBA macros

·    Create procedures and sub routines

·    Record macros using macro recording and customise the VBA code

·    Assign macros to object and shortcut to start macros in different ways

·    Work with variables and Excel objects

·    Work with different events (workbook, worksheet, controls, application)

·    Use named range in VBA coding (highly recommended)

·    Create user defined functions (such as user defined lookup functions to replace Vlookup)

·    Create custom forms and design report

·    Work with time & date, manipulate text string

·    Handle errors and resume next