上海易達教育培訓中心
15757356768
全國統一學習專線 8:30-21:00
上海易達教育培訓中心
15757356768
全國統一學習專線 8:30-21:00
授課機構：上海易達教育培訓中心
地址：易達教育總部地址：浦東南路1525號6樓;浦東八佰伴校區張揚路655號福興大廈7樓;浦東南路浦電路校區浦東南路1525號6樓;浦東東方路校區浦三路159號3樓;浦東昌里校區浦東新區云臺路上南八村27號;浦東上南校區西營路114弄32號206室;上鋼新村街道社區學校;徐家匯校區漕溪北路502號;閘北彭浦校區閘北區嶺南路1115號2樓;楊浦中原校區包頭路市光四村56號殷行社區黨員服務中心;靜安區萬航渡校區萬航渡路767弄20號工藝美術職業學院
網報價格：￥電詢
課程原價：￥電詢
咨詢熱線：15757356768
課程詳情 在線報名
詳細介紹 *開班
【學校名稱】上海易達教育 【交通線路】交通便利 【關 鍵 字】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專業課程培訓