Udemy

Excel Macros/VBA: Create 4 Real World Projects from Scratch

立即報名
  • 23,143 名學生
  • 更新於 10/2017
3.6
(220 個評分)
CTgoodjobs 嚴選優質課程,為職場人士提升競爭力。透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
2 小時 14 分鐘
教學語言
英語
授課導師
Think Forward Online Training
評分
3.6
(220 個評分)
3次瀏覽

課程簡介

Excel Macros/VBA: Create 4 Real World Projects from Scratch

Learn to solve any problem with Excel by watching me do it in real time. Experience full and uncut problem solving!

Imagine if everything you had to do in Excel could be reduced to a click of a button. How much time would that save you in your workday? How much stress would disappear because now you don’t have to dread completing your tedious Excel work? If you’re reading this course description, I bet the answer is quite a bit.


The entire purpose of my day job is to automate tedious work that people don’t want to do. This increases the productivity of my company, which is very valuable. It allows us to continue growing without adding many more employees, which increases our profits. I use many tools to achieve automation, but Excel is one of the best because it’s simple to learn yet very powerful in application. My goal with this course is to enable you to increase your own productivity, just like I do for many people at my day job.


I will use real world projects, some that I have had to deal with myself. You will see the process that I go through to figure out how to automate these tasks. It may be surprising, but I usually don’t know how to accomplish an automation project from the get-go. It takes some planning and critical thinking for every project you take on. That’s why you should think of this course more as providing the tools for you to solve any problem, rather than an encyclopedia-like course that will give you a bunch of information. For those of you still reading, I hope you enjoy the course. I put a lot of work into creating the most useful course I could!

課程章節

  • 6 個章節
  • 12 堂課
  • 第 1 章 Introduction
  • 第 2 章 Project 1 - Easy: "My First Macro" or "The Fun Macro"
  • 第 3 章 Project 2 - Intermediate: "Compose Customer Emails from Your Customer List"
  • 第 4 章 Project 3 - Intermediate: "Prepping Unstructured Data for Data Analytics"
  • 第 5 章 Project 4 - Advanced: "Format and Create a CSV Export from Client Data"
  • 第 6 章 Project 5 - Advanced: Create Your Own Project

課程內容

  • Tackle any Excel problem that is thrown at you (and many other problems too!), Use Excel Macros to reduce your Excel workload to almost nothing, Increase your productivity (and those around you, if you're nice), Put a portfolio of 5+ complex Excel problems you have solved on your resume


評價

  • G
    Gaizka Galvez
    5.0

    Perfect to learn while practicing, which makes this course more entertaining than the ones based on pure theory

  • A
    Aybars Topcu
    3.0

    Lots of things are just given but not explained... He writes some codes by himself and explains the half of it.... and you watch him writing codes by himself and talking to himself...

  • M
    MEHAK CHOPRA
    5.0

    yes it is a good match but next time please zoom out the window show we can see clear

  • J
    John Zschoche
    2.5

    Other then having a micro font that can't be read without bugging your eyes out of your head The course would teach people more of the use of IF or When statements

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策使用條款才繼續瀏覽。

我已閱讀及同意