上海易达教育培训中心 Excel VBA Introduction Training Course

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

网报价格：￥电询

课程原价：￥电询

咨询热线：400-850-8622

在线报名

在线咨询

课程详情在线报名

详细介绍 *开班

【学校名称】上海易达教育【交通线路】交通便利【关键字】Excel基础, Excel 入门培训, Excel基础辅导班

课程简介

Overview:This course has been created for anyone who works with Excel and wants to automate most of their tasks. The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions, debug programs and write complete applications using VBA forms.

适合人群

Requirements:Good Excel user knowledge.

培训大纲

Macros
Recording and Modifying Macros
Assigning Macros to Toolbar, Buttons, Shortcut key
Visual Basic for Applications Environment
Visual Basic Editor and its options
Component Management
Shortcuts
Environment Optimization
Introduction to Procedural Programming
Procedures: Functions and Sub-routines
Data Types
Control Flow
If ...Then....Elseif....Else....Endif
Case
Do...Loop , While
For... Next
Exit
Arrays and Loops
Strings
Visual Basic
VBA and Sheet Data Exchange (Cells, Range Methods)
Getting and Printing Data from Users (InputBox, MsgBox)
Variable Declaration
Scope and LifeTime of Variables and Objects
Operators and Their Priorities
Modules Options
Creating Worksheet Functions
Objects, Classes, Methods and Properties
Locking Project for Viewing
Debugging
Run Time, Design Time, and Break Mode
Brakes and Watches
Local Window
Immediate Window
Call Stack
Error Handling
Errors Types
On Error GoTo
On Error Resume Next
Excel Model Object
Application Object
Workbook Object and Workbooks Collection
Worksheet Object and Worksheets Collection
ThisWorkbook, ActiveWorkbook, ActiveCell, ....
Selection Object
Range Collection
Cells Collection
Using Status Bar
Screen Updating and Optimizing
Timer and Time Measuring
Events Handling in VBA
VBA Forms
Creating and Using Forms
Invoking Forms in VBA Code
Using VBA Forms in Worksheet

更多Excel VBA Introduction Training Course

热门课程

申请试听课程

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

姓名不能为空

手机号格式错误