上海易达教育培训中心 Microsoft Excel专业课程培训

地址：易达教育总部地址：浦东南路1525号6楼;浦东八佰伴校区张扬路655号福兴大厦7楼;浦东南路浦电路校区浦东南路1525号6楼;浦东东方路校区浦三路159号3楼;浦东昌里校区浦东新区云台路上南八村27号;浦东上南校区西营路114弄32号206室;上钢新村街道社区学校;徐家汇校区漕溪北路502号;闸北彭浦校区闸北区岭南路1115号2楼;杨浦中原校区包头路市光四村56号殷行社区党员服务中心;静安区万航渡校区万航渡路767弄20号工艺美术职业学院

网报价格：￥电询

课程原价：￥电询

咨询热线：400-850-8622

在线报名

在线咨询

课程详情在线报名

详细介绍 *开班

【学校名称】上海易达教育【交通线路】交通便利【关键字】Excel专业课程, Excel应用基础, Excel入门辅导班

课程简介

Introduction

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

培训对象

培训大纲

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 Select case

更多Microsoft Excel专业课程培训

热门课程

申请试听课程

只要一个电话
我们免费为您回电

姓名不能为空

手机号格式错误