課程介紹

Go from Beginner to Microsoft Excel VBA Expert!

I’ll take you step-by-step through engaging video tutorials and teach you everything you need to know to be able to use VBA to improve your work flow, save time and automate your current Excel projects

…[更多細節]

哪些人適合這堂課？

• Business Professionals who’d like to simplify & automate work flow.
• Data analysts.
• You currently use Excel and like to improve your skills.

學習目標

• Enhance your current Excel files & automate your work with VBA.
• Master Excel VBA & Macros
• Directly apply the Excel VBA example files included to your own work.
• Reduce manual routine tasks to the click of a button.
• Make your work-life easier.
• Create simple solutions to complex problems by levering Excel functionality with Macros.
• Formulas & Excel core functionality can’t do everything. Use VBA when you reach a limitation.
• Easily adjust VBA code you find online to fit your purpose.

課程介紹

Understand what you are going to achieve through the VBA by seeing demo and then see step by step explanation of VBA code. Learn about Excel VBA syntax, Excel VBA form and control, methods of  using forms and controls, several workout examples to see

…[更多細節]

哪些人適合這堂課？

• Microsoft Excel users who wants to learn automation and VBA programming
• Someone who wants to learn by seeing workout examples

學習目標

• Learn to automate their time consuming repeatitive tasks for more accuracy and less time consuming
• Understand VBA syntax for Excel
• Understand usage of tools available in VBA environment
• See several worked out examples
• Learn to fetch access data using Excel as a front end
• Learn to develop VBA froms and interact with the same, load charts on forms
• See inventory management workout
• And many other workout which i am adding step by step

課程介紹

Welcome to Excel VBA Programming – The Complete Guide, Udemy’s most comprehensive VBA course!

Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications like Excel, Access, and Outlook. It allows

…[更多細節]

哪些人適合這堂課？

• Spreadsheet users who want to automate their daily workflow
• Business analysts who want to remove redundancy from their common tasks
• Excel users who are curious about exploring programming in a familiar work environment

學習目標

• Automate tasks and procedures in Excel using Visual Basic for Applications (VBA)
• Utilize the objects in the Excel Object Model to emulate user actions in Excel
• React dynamically to user events like entering a cell value or opening a workbook
• Feel comfortable with the fundamentals of computer programming

課程介紹

Course Material Works in Microsoft Excel 2007, 2010, 2013 and 2016

Join me in this course and take control of Microsoft Excel and master the process of automating routine tasks through the use of Excel Macros and Excel VBA.

During this course you w

…[更多細節]

哪些人適合這堂課？

• This Excel Macro/VBA course is meant for those that use Microsoft Excel and are looking to become more efficient by automating their daily Excel tasks. No prior programming experience is required.

學習目標

• Learn how to automate daily routine tasks within Excel
• Learn best practices when creating macros and streamline your VBA code
• Determine when it’s best to use the Macro Recorder versus VBA
• Learn how to write custom VBA Macros to create more robust automation
• Learn VBA programming concepts to create dynamic, re-usable code
• Complete real world Macro/VBA projects from beginning to end

課程介紹

This course is an Introduction to VBA & Macros in excel.

In this course we have tried to cover all the topics necessary for you get started on creating applications in Excel as per your needs.

As always, to make things easier we have included links

…[更多細節]

哪些人適合這堂課？

• Some knowledge of excel and its features will make it easier for you to follow this course

學習目標

• By the end of this course, you will be able to write programs to customise Excel.

課程介紹

This is an introductory course on how to program Excel using VBA macros. You will learn to automate and extend the Excel environment to supercharge your Excel models, automate routine tasks, customize your user interface, and manage large quantities

…[更多細節]

哪些人適合這堂課？

• This is an introductory programming course, so no previous programming experience is assumed. The student should be at least moderately comfortable with Excel. The more prior exposure to Excel you have the more you will get out of the course, but you do not need to be an Excel expert to take the course.

學習目標

• Course Goal: You will obtain practical fluency in Visual Basic for Applications (VBA) specifically as it applies to Microsoft Excel.
• Course Objectives: 1) You will learn to automate and extend Excel by adding VBA projects to your workbooks. 2) You will learn to enhance, customize and extend the Excel user interface through modifications to the Excel environment, the creation of custom user forms, and the use of ActiveX controls. 3) You will learn how to respond to workbook, worksheet and application events to automate macro execution. 4) You will learn how it is possible to reach outside of Excel by way of VBA, in order to perform cross-application tasks.

課程介紹

Hear What Some of Our Students are Saying…..

“Really, really good course on VBA! *****”

“Great content, great examples, would definitely take another course from this instructor again!”

“Excellent course for getting started with VBA. The instru

…[更多細節]

哪些人適合這堂課？

• You want to learn VBA to take your skills to the next level
• You want to automate reports and save time on repetitive and boring tasks
• This course is probably not for those with VBA experience who are looking for advanced VBA.

學習目標

• Write powerful Excel VBA code to automate processes
• Identify real world situations where you can apply your new VBA skills
• Understand, test and debug VBA errors
• Lifetime access to the lessons, practice files, exercises, and 1-on-1 instructor support
• Fun and effective lessons including ‘real world’ Excel VBA projects to complete
• Projects and challenges to practice your skills

課程介紹

領取高額優惠券請點下方”關於講師”的頭貼

你難道還想繼續浪費大量的寶貴時間在收集資訊嗎?

你難道想繼續處在資訊不對稱的劣勢嗎?

你難道不想做出一個可以客製化，列出自己所有需要的資訊的Excel檔嗎?

你難道不想用最輕鬆的方式學習網路資料蒐集的能力嗎?

當別人已經著手做決策時，人工找資料的你晚了別人多少?

若你想要有所改變，並且實際行動，那麼這個課程絕對是您的首選！

甚麼是VBA?

VBA是「Visual Basic for Applications」的簡稱，可以幫你快速搞定

…[更多細節]

哪些人適合這堂課？

• 對於完全沒寫過程式語言的你: 本課程會從程式基本架構開始講解，並且用生活中的例子來講解專業術語，讓沒有基礎的程式新手也可以快速學會。
• 對於已經有VBA基礎的你: 本課程會帶你運用VBA抓取網路上的資料，讓VBA的功能不再侷限於Excel的內部操作。
• 對於總是花許多時間整理投資資訊的你: 本課程會教同學如何將網站上的投資資訊利用程式抓進Excel裡，將蒐集資訊的繁瑣工作自動化，把寶貴的時間留給分析資訊及擬定策略!
• 對於已經開始用VBA抓資料，但找不到一套固定方法的你: 本課程歸納講師過去抓資料的經驗，擬定成一套SOP，並且在實戰的課程中，手把手的將SOP演示給同學看，讓同學快速學會。

學習目標

• 1.從0到成為專業的爬蟲高手，能看到的資料幾乎都能夠快速抓取
• 2.學習到網路相關知識，了解爬蟲原理
• 3.學習到VBA的基礎知識以及進階應用
• 4.了解程式運作方式，往後學習其他程式更容易上手

課程介紹

— 我適合這門課程嗎? —

底下有兩個授課方式，請評估一下喜不喜歡，這會決定是否適合我的課程。

一開始教你一大堆枯燥乏味的VBA名詞解釋   (喜歡 或 不喜歡)

少少的實作教學，只看冗長無趣的條列式教學投影片(ppt)  (喜歡 或 不喜歡)

如果上述都不喜歡，那麼我敢肯定 你會喜歡我的課程。

—本課程怎麼進行? —

教你建構一套能收集並整理的股市資料庫程式，

從無到有，從想法轉成作法，從單一功能進化成多種複雜功能。

讓你知道要達到某功能時，我是如何思考問

…[更多細節]

哪些人適合這堂課？

• 對股市投資有興趣，想利用Excel建立大數據的人
• 努力上進的大學生、研究生、博士生等
• 資訊工程師、會計師、財金相關人士、專職投資人等
• 對Excel是零基礎程度(含以上) 以及 對Excel VBA零基礎程度 (含以上) 的人 都歡迎來上課

學習目標

• 自動從網路下載台股上市櫃盤後數據檔(影片範例是200個檔，學會後可擴增更多)
• 自動將下載的零碎檔案匯入並整合到同一個Excel檔，創造出更有價值的檔案。
• 自動複製、剪下、貼上、刪除等調整Excel儲存格順序語法，讓你隨心所欲控制所有的儲存格。
• 自動選擇Excel需要的資料範圍邏輯語法，將有用的資訊擷取出來!
• 自動篩選與排序資料語法，讓資料看起來更有秩序!
• 儲存格以及變數的關係，知悉ExcelVBA幾個常用的變數類型
• 利用 FileSystemObject 物件的控制或取得資料夾或檔案資訊，讓你除了會控制Excel還會控制檔案與資料夾!!~
• 能恰當選擇Sub與Function的程序，讓程式運作起來更有效率
• Excel儲存格在VBA內是物件，搞懂什麼是物件，讓你靈活運用儲存格的屬性與方法。
• 當遇到不可避免的錯誤問題時，讓程序自動處理錯誤訊息並持續執行下一段程序。

課程介紹

Excel所有重複工作都能VBA自動化。贊贊小屋這堂線上課程從VBA基本認識到流程控制及常用物件設計，實務案例分享如何自動複製修改日報表，自動沖銷帳款。全部循序漸進分廭四個單元如下：

一、VBA基本認識：

首先介紹如何在Excel設置開發人員面板及巨集安全性，進入VBA編輯環境，設計第一個簡單的程式模組，進而認識VBA有哪些程式類型，VBA編輯視窗的基本操作。

二、VBA基本元素：

第二單元將以實際工作中的日報表及ERP表單為例，學習如何設計VBA程式高效率建立新報表，重點學習VBA基本

…[更多細節]

哪些人適合這堂課？

• 任何工作上會用到Excel、對於操作Excel如何提升效率有興趣的人

學習目標

• 設計VBA程式，Excel資料處理自動化