Search result for Courses taught by Justin Yu
Get Course Alerts by Email
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
Top Online Courses and Specializations | Coursera
- 0.0
Find Courses and Specializations from top universities like Yale, Michigan, Stanford, and leading companies like Google and IBM. Join Coursera for free and transform your career with degrees, certificates, Specializations, & MOOCs in data science, computer science, business, and dozens of other topics....
Coursera | Online Courses & Credentials From Top Educators. Join for Free
- 0.0
Learn online and earn valuable credentials from top universities like Yale, Michigan, Stanford, and leading companies like Google and IBM. Join Coursera for free and transform your career with degrees, certificates, Specializations, & MOOCs in data science, computer science, business, and dozens of other topics....
Course Definition & Meaning - Merriam-Webster
- 0.0
course: [noun] the act or action of moving in a path from point to point....
Free Online Courses | Stanford Online
- 0.0
Free Online Courses. Our free online courses provide you with an affordable and flexible way to learn new skills and study new and emerging topics. Learn from Stanford instructors and industry experts at no cost to you....
Online Courses - Learn Anything, On Your Schedule | Udemy
- 0.0
Udemy is an online learning and teaching marketplace with over 185,000 courses and 49 million students. Learn programming, marketing, data science and more....
Courses » Academics | Boston University
- 0.0
Courses. The listing of a course description here does not guarantee a course’s being offered in a particular semester. Please refer to the published schedule of classes on the Student Link for confirmation a class is actually being taught and for specific course meeting dates and times....
Courses | Learn WordPress
- 0.0
These courses will help you find your feet in the project and help you get involved in the mission to democratize publishing. Polyglots Contributor Training. Translation is a great way to contribute to WordPress if you understand English and another language....
Courses - Colorado Motorcycle Academy
- 0.0
Our basic courses are for those who have never ridden a motorcycle before, have less than approximately 40 total hours of riding, or haven’t seen the seat in a while and want a refresher. These courses are perfect for beginners to learn how to be safe on the road while riding....
Golf Longmont | City of Longmont, Colorado
- 0.0
Adult and youth instruction is available at our municipal courses and through the Recreation Services department. City of Longmont Recreation Services has two summer golf camps, and drop-in group lessons are available at Twin Peaks and Ute Creek. For more information about instructional offerings, call Ute Creek's Tray Shehee (303-875-5050) or ....
Golf Longmont - Longmont, CO
- 0.0
Celebrating 100 Years of Sunset Golf Council approves course in 1922, originally called the Longmont Golf Club. Sunset Golf Course is celebrating its 100th birthday with a free “Par Tee” at the clubhouse from 5-8 pm on Thursday, Aug. 18. Commemorative 100 Year Anniversary merchandise is now on sale in the pro shop at 1900 Longs Peak Ave....