INFOCHINA全国office培训中心(46家)

加盟电话:400 600 1998

金融/保险专区

客户:中行  建行 法兴 三菱东京 PICC...

汽车/制造专区

客户:宝马 丰田 卡特彼勒 三一重工...

通信/电子专区
客户:移动、联通、澳电、 VERIZON 
石化/能源专区
客户:中石油 中石化 康菲 斯伦贝谢...
医疗/生物专区
客户:辉瑞、强生、合生元、诺和诺德...

 敬 告

诸多培训机构复制INFOCHINA培训大纲、培训客户、培训方案甚至公司简介,却没有专业讲师授课,让客户蒙受损失!INFOCHINA是宝马、华夏银行、卡特彼勒...全国唯一指定高端Office培训与服务提供商,如有雷同,绝非巧合。

Excel VBA Training in English:Excel Macros and VBA Fundamentals

用户评价:  / 394
好 

--------------------------------------------------------------------------------

The training course is designed to give advanced users of Microsoft Excel an understanding of how to automate procedures using excel Macros and Microsoft Visual Basic for Applications (VBA).This course concentrates on introductory programming topics and good programming practices, showing how these programming techniques can be used to model and manipulate date. Participants will be encouraged to write programs to meet their specific needs, as there is an increase in the need to analyze and develop ever more complex “what if” scenarios.

--------------------------------------------------------------------------------

At Course Completion

After completing this course, students will be able to:

Record macros

Write control structures

Build procedures, which use variables

Program components within Excel

--------------------------------------------------------------------------------

Key topics

1. Introduction to Excel Macros

1) What is a macro?

2) Record a macro

3) Urn a macro

4) Relative references

5) Assign a macro to a button on a worksheet

6) Assign a macro to a button on a toolbar

7) Button image editor

2. Editing Excel Macros

1) The Visual basic editor

2) The project explorer

3) The code window

4) Procedures

5) Insert comments

3. Introduction to VBA

1) Development environment

2) Menu and toolbars

4. Structure of Procedures

1) Call procedures

2) Organize procedures

5. Working with objects

1) Introduction to objects and collections

2) Control objects

3) Use the object browser

4) Use objects, properties and methods

6. VBA codes

1) If …Then …Else

2) Select case

 

 Fred Warner Authentic Jersey

客户展示 - 涵盖56.4%的世界500强企业


企业Office培训专线:400 808 3680
咨询QQ 徐老师: 点击这里给我发消息
咨询QQ 李老师: 点击这里给我发消息

战略合作伙伴

   
   
   
   
   
   
   
   @2004 北京助力东方(INFOCHINA)科技有限公司版权所有 京ICP备06024442全国业务咨询热线:400-600-1998   

十大经典课程 + 十大金牌讲师 + 独创5S教学法 + 一年完美技术服务 = INFOCHINA|中国Office培训专家