Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js HTML5 PHP Vue JS
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA Microsoft AZ-900 AWS Certified Developer - Associate
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Business Intelligence MySQL Qlik Sense Blockchain
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Virtual Reality
Google Flutter Android Development iOS Development React Native Swift Dart (programming language) Mobile App Development Kotlin SwiftUI
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting Canva InDesign Character Design Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Meditation CBT Cognitive Behavioral Therapy Sound Therapy
Entrepreneurship Fundamentals Business Fundamentals Freelancing Business Strategy Startup Business Plan Online Business Blogging Home Business
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Google Analytics Copywriting Email Marketing YouTube Marketing Podcasting

Office ProductivityMicrosoftExcel VBA

投資效率翻倍必學 | 零基礎學習 Excel VBA 自動化擷取網頁投資資訊

打造屬於自己的投資利器
Rating: 4.1 out of 54.1 (74 ratings)
226 students
Created by Raymond Chien
Last updated 9/2018
Traditional Chinese

What you'll learn

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

Requirements

  • 不需任何程式基礎,因為讓你從0基礎到成為爬蟲高手,就是本課程的目標!
  • 作業系統建議為Windows,使用MAC的同學可以安裝parallel desktop安裝WINDOWS作業系統,再安裝OFFICE即可。

Description

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

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

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

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

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

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

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


  • 甚麼是VBA?

VBA是「Visual Basic for Applications」的簡稱,可以幫你快速搞定重複繁雜的工作與強化Excel的功能,不過很多人一看到原始碼就頭大,因此課程先從最基礎的操作開始,再告訴你如何修改VBA程式、常用的變數與常數、運算子等,讓你從基礎打好,往後就可以依照需求,快速寫好適用各種情況的工作表單喔!


  • 你可能擔心,自己完全沒有程式基礎,會不會聽不懂?

身為一個完全自學VBA的過來人,我十分了解一個完全沒有基礎的新手會在那些地方遇到問題,因此我會在影片中為大家建立完整且正確的觀念,並且也告訴大家我在自學時曾經犯過甚麼錯,讓大家可以避免

此外,在我自學,上網查資料時,最害怕的就是看到一堆專業術語,即使反覆看了幾個小時仍不知如何解決,因此在課程中,我將這些專業術語轉化成我們生活中常見的景象,以最平易近人的方式教會大家


  • 你可能認為,網路上應該就有相關資源了,為什麼需要來這堂課?

網路上的確有相關資源,但根據我自學的經驗,若沒有一個系統性的整合,不論怎麼學都像是一盤散沙,只能改改別人的程式碼,卻無法自己做出一個成品,甚至遇到問題也不知從何下手,而這個課程會有系統將爬蟲方式分類,並針對每個方式舉出許多實例,以及可能碰到的問題,同時也會過濾掉許多非必要的資訊,讓大家用最短的時間掌握最重要的概念



Who this course is for:

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

Instructor

Raymond Chien
VBA網路擷取資料
Raymond Chien
  • 4.1 Instructor Rating
  • 74 Reviews
  • 226 Students
  • 1 Course

我是Raymond,努力藉著Excel自動化提升工作效率,於是學習VBA,沒想到VBA超乎預期的容易上手,因此展開程式學習之路,對於程式相當熱愛,常常研究到半夜兩三點還不休息

本身有在投資,因此努力專研用VBA做網路爬蟲,讓程式幫我快速蒐集所有我想要的資訊,並且下載到我們最熟悉的Excel裡,至今也累積了不少相關知識,希望藉著課程分享給有需要的人, 一起大幅提高投資效率!

經歷: 輔大金融大數據-網路爬蟲 課程講師


Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.