Udemy

How to Program Microsoft Excel as a Modbus Master HMI

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

課程資料

報名日期
全年招生
課程級別
學習模式
修業期
1 小時 25 分鐘
教學語言
英語
授課導師
Emile Ackbarali
評分
4.6
(279 個評分)

課程簡介

How to Program Microsoft Excel as a Modbus Master HMI

Learn how to use Microsoft Excel to communicate Serially or via TCP/IP with any Modbus Slave

If you design and implement projects in the area of Process Automation or SCADA, you will know from your experience that "one size does not fit all" when it comes to data acquisition and Human Machine Interfaces (HMIs). There is always some type of customization to be done. Always some feature that the standard HMI software does not offer.


And sometimes, using a very expensive HMI with all sorts of bells and whistles for a small project can just be overkill. There are times when you just need a very simple application that acquires a few data points from a Modbus network and displays them on a computer screen.


These are the reasons for this course!


I teach you how to use Microsoft Excel to create your own Modbus Master application and Human Machine Interface.


If you apply yourself in this course and execute all that I ask you to do, then at the end, you would be essentially be creating an application with all of the superb data analysis capabilities of Microsoft Excel and applying it to Modbus data!


This is the start of your journey into a whole new area of Process Automation / SCADA and one that is increasingly in very high demand!


Looking forward to seeing you on the inside!

課程章節

  • 7 個章節
  • 17 堂課
  • 第 1 章 Introduction
  • 第 2 章 The Software We Will Be Using
  • 第 3 章 Quick Start - Our First Excel Modbus Master HMI Application
  • 第 4 章 Expanding the Quick Start Excel Modbus Master Example
  • 第 5 章 Adding Modbus Write Commands to the Excel Application
  • 第 6 章 Changing from Modbus Serial Communications to Modbus TC/IP Communications
  • 第 7 章 Bonus Section - How to Always get the Lowest Prices for my Courses

課程內容

  • Have an understanding of how ActiveX controls work with Microsoft Excel, Install the MBAXP Modbus ActiveX control in Microsoft Excel, Write VBA code to read Modbus data from a Modbus Slave/Server, Write VBA code to write Modbus data to a Modbus Slave/Server, Use Modsim32 as a Modbus Test Slave and Server, Establish both Modbus Serial and TCP/IP Communications using Microsoft Excel


評價

  • S
    SHOHARAT ALI ANSARI
    4.5

    The detailing in explanation is very good.

  • R
    Rodolfo Alonso Rodríguez Aguilar
    5.0

    .

  • F
    Fong WK
    5.0

    Looking forward to working with Modbus/Excel

  • G
    Gonzalo Carbo
    5.0

    The course was extremely clear and useful for me. As soon as I finished it, I could succesfully meet my initial goal which was to establish a modbus tcp link between an Excel spreadsheet and a Schneider M221 plc. Thanks a lot to the teacher for this course, now I'm sure I'll take other courses from him in the near future.

立即關注瀏覽更多

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

我已閱讀及同意