Udemy

A Gentle Introduction To Advanced Excel Techniques and VBA

立即報名
  • 303 名學生
  • 更新於 8/2024
4.6
(65 個評分)
  • 提示:
  • 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期*
全年招生
課程級別
學習模式
修業期
7 小時 29 分鐘
教學語言
英語
授課導師
Charlie Chiarelli
評分
4.6
(65 個評分)
*提示: 以上時間表僅供參考,以機構網站為準。

課程簡介

A Gentle Introduction To Advanced Excel Techniques and VBA

Take your EXCEL skills to the next level . Learn basic data analysis , lookup techniques, macros and programming in VBA

You may or may not know of the importance of Excel and the dependency businesses have on its use every single day.  There is a HUGE need for advanced Excel users in the marketplace. I hope to transform you from being an ordinary user into your company's leading Excel expert and eventually master the ability to automate tasks with macros and the use of  VBA programming . My hope is to provide you with a very straightforward course which will allow you to use some of the most  advanced Excel techniques. 

VBA is a very useful skill to have and is used in almost all organizations. Knowing VBA can help you work considerably faster. Think of VBA as an extension of Excel skills. If improving your Excel abilities would be beneficial, then you should absolutely consider learning VBA. 

Here's how I will help you to succeed:

o    Each lecture starts with a list of objectives/speaking notes

o    Every example covered in the lecture is available for download in the resources section  … including the objectives/speaking notes

o    Almost every lecture has a set of Practice problems with full solutions provided

o    My style of writing and teaching follows the KISS principle : Keep It Super Simple.   I try to stay away from fancy computer terminology and try to teach like am speaking to a brand new user with little to no previous knowledge on the subject matter.... and  I am always available for help … replying most times within a day.


.... And finally please do not judge a book by it's cover ... don't judge the course by the title or this small description section, if you want to know exactly all the topics covered please go to:

COURSE CONTENT
Sections
Lectures  (press the down arrow) ... This will open up literally thousands of lines of very detailed lecture descriptions leaving no doubt what is and what is not covered.

課程章節

  • 1 個章節
  • 38 堂課
  • 第 1 章 Course Information

課程內容

  • Review some Excel basics to get you up to speed
  • Analyze spreadsheet data using goal seek and solver
  • Implement pivot tables to analyze complex data in a variety of ways
  • Use advanced Excel commands which incorporate conditional statements
  • Implement look up tables using the vlookup and index commands
  • Create simple macros to automate specific procedures
  • Create user defined functions
  • Create simple VBA (Visual Basic Applications) incorporating string and numeric variables
  • Create simple applications which incorporate combo boxes, dialog boxes and other UI interface controls
  • Create simple applications which check user input using the concepts of Selection (IF) and Repetition(DO...LOOP)
  • Create Menu driven workbooks
  • Implement user friendly input techniques by creating custom user forms
  • Create a fully functioning Budget Application to track household or business expenses


評價

  • N
    Nirmal Aluwihare
    2.0

    Cannot open rar files in resources

  • I
    Iosif Bodnar
    5.0

    Very Good!

  • T
    Torben Kliche
    3.5

    To basic. I would have needed more input on VBA, but perhaps that is still coming

  • L
    Liliana S
    4.5

    Great course. I particularly like step-by-step explanations of VBA codes related to different problems. I learned various Excel concepts and became more confident in writing VBA codes. I am looking forward to applying them to my work projects.

立即關注瀏覽更多

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

我已閱讀及同意