Search result for Online Courses & Certifications
Get Course Alerts by Email
The Ultimate Excel VBA Arrays Course
by Daniel Strong- 4.4
3.5 hours on-demand video
Learn To Manipulate Data Invisibly and At Lightning Speeds with Arrays! Arrays are present in many programming languages, but most people don’t take the time to master them and can get frustrated when their code seems sloppy, difficult to read, and often can take a long time to run. Glean information from and Manipulate text like never before...
$12.99
Complete Web Automation with Excel VBA
by Daniel Strong- 4.7
9.5 hours on-demand video
Fill Out Web Forms Dynamically, Navigate Web Pages Intuitively, And Extract & Manipulate Data To Increase Efficiency! Using a website has become part of everyday life in both work and play. Many of us spend hours a day scouring the web or filling out tedious forms online for work! Introducing “Complete Web Automation with Excel VBA” course....
$12.99
Ultimate Beginners Excel VBA Finance Course for Banking
by VBA Finance- 2.8
2 hours on-demand video
Proven core methodology to master VBA and become competitive on the banking job market. This course will provide you with essentials about Visual Basic Applications (VBA) Excel for Finance. VBA is the programming language of Excel and is a fast programming language. When correctly mastered, it can automate almost every task that is required in Banking and Investment Banking....
$9.99
Visual Basic For Applications (VBA) - Excel
by Matthew Fried- 4.4
4.5 hours on-demand video
Being the best of the best of the best at Spreadsheet Programming and Analysis A complete and total immersion in VBA. Learning to program and interact with Excel. A fun learning experience that balances practical tools of data and financial analysis with professional attribution. We will cover absolute basics through the management of different objects and variants thereof....
$19.99
Project Based Excel VBA Course
by Brandon Brown- 4.5
11 hours on-demand video
Become an Excel Programmer, fueled by plenty of practice Learn how to automate tasks in the world's most popular business tool, Microsoft Excel. This course only requires access to Excel, and it will teach you the core concepts to launch your programming career. Some highlights of this course: A step-by-step guide in making a comprehensive game of Battleship....
$12.99
Excel VBA & Microsoft Outlook Mastery and Automation
by Daniel Strong- 4.6
11 hours on-demand video
Create And Manipulate Outlook Emails, Attachments, Calendars, Tasks, and Contacts Automatically With Excel VBA The world has well over a billion Microsoft Office users, and many of them are starting to realize that you can automate your work life with VBA. . You’ll learn to: Utilize and manipulate Outlook’s organizational structure and folder system to...
$12.99
Excel VBA Formulas, Functions, UDFs + Create Your Own AddIn!
by Daniel Strong- 4.1
2.5 hours on-demand video
Learn Built-In VBA Functions, Build Your Own Custom UDF (User-Defined Functions) and Learn To Share Them! Microsoft Excel has some amazing built-in formulas, but they don't always have the special customizations that you need. [Enter custom functions and formulas. ] You'll learn the ins and outs of using VBA to supercharge your productivity in Excel....
$13.99
Excel VBA : 教你製作台灣股市資料庫
by Justin Yu- 4.7
7.5 hours on-demand video
只需按一鍵! 自動下載百天台灣上市櫃盤後數據檔並整理匯集至Excel資料庫。 --- 我適合這門課程嗎? --- 底下有兩個授課方式,請評估一下喜不喜歡,這會決定是否適合我的課程。 一開始教你一大堆枯燥乏味的VBA名詞解釋 (喜歡 或 不喜歡) 少少的實作教學,只看冗長無趣的條列式教學投影片(ppt) (喜歡 或 不喜歡) 如果上述都不喜歡,那麼我敢肯定 你會喜歡我的課程。 ---本課程怎麼進行? --- 教你建構一套能收集並整理的股市資料庫程式, 從無到有,從想法轉成作法,從單一功能進化成多種複雜功能。 讓你知道要達到某功能時,我是如何思考問題並如何解決這個問題, 在你知道怎麼解決後,對應的VBA語法很容易就學起來了。 我會從一個Excel檔案開始說起, 讓你能辨識哪個檔案類型才能存寫巨集, 教你利用VBA 自動下載網頁資料, 也教你利用VBA 讓數百個下載檔案自動彙整到同一個Excel資料庫內 還教你利用VBA 自動整理成一個正確有秩序的Excel資料庫。 這些過程都會適時地引入需要的VBA語法與相關知識, 再利用許多的生活經驗以及對應的小實驗,讓你深刻體悟程式運作原理。 從一小段程式碼擴大到幾十段程式碼, 再教你提高程式碼效率的寫法, 這時你就有能力從冗長的程式碼淬鍊成幾段程式碼。 同時也有能力從多個程序整合成一個全自動化的程序。 還有能力解決已知又無法避免的異常程序,讓程序可以繼續執行不等待。 最後,你只需按下一程式啟動鍵,就能自動且迅速地完成下載、匯集、整理等複雜動作。 ---要學全部的VBA觀念與用法,才能做出一個完整的程式? --- 不需要,本課程會先教你一兩個基本的VBA觀念後,就開始實作了, 遇到沒辦法克服的問題,才適時地教你對應的VBA觀念以及語法。 到課程結尾時,你會發現早已學會許多的VBA用法。 讓你覺得學程式是如此的簡單、易懂。 因為課程都是讓你先透過思考問題,構思可能的解決辦法,最後撰寫對應的程式碼。 有經過這段歷程,日後在工作上或者投資上想藉助VBA,自然就容易聯想到對應的程式碼了。 ---對新手來說,靠錄製巨集學習VBA,這方法好嗎? --- 我的建議是 "千萬不要用錄製巨集學習VBA",原因如下: 採用錄製巨集方式,只會建構一個冗長又毫無效率的程式...
$199.99
Excel VBA In Depth USERFORMS Series7
by ajay parmar- 4.4
5.5 hours on-demand video
Covering every type of useful form controls . From their design to coding - i have everything for you here. Course is focusing on basic level developers who know arrays. loops and variable pretty well and now want to take their knowledge to next level. Collection loops structure in User-forms and their use practically....
$9.99
VBA for Financial Modeling | Excel Automation
by DealMaker Financial Training- 4.5
4.5 hours on-demand video
Automate repetitive work tasks and revolutionise your productivity! THIS COURSE WILL CHANGE EVERYTHING. . . !!!Yes, of course I'd say that. . . . but this time it's true!How many times have you. . . Had to clean up your financial model to share with clients? Had to reconfigure Excel display settings because they got messed up?...
$12.99