How to Program Microsoft Excel as a Modbus Master HMI (Udemy.com)
Learn how to use Microsoft Excel to communicate Serially or via TCP/IP with any Modbus Slave
Created by: Emile Ackbarali
Last updated May 2026
What you will learn
- 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
How it compares
Against the other 1,182 rated Udemy courses in IT & Software on CourseDuck:
- Rating4.6 out of 5higher than 67% of them
- Reviews281#736 of 1,183 by number of reviews
- Length1.4 hoursshorter than 91% of them
- Last updatedMay 2026more recently than 75% of them
Course Description
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!
Instructor Details
- 4.6 Rating
281 Reviews
Emile Ackbarali
I have been working in the fields of Software Development, Software Systems Integration and Process Automation since 1996. In 2003, I stepped out on my own and started working for myself providing software development and systems integration services to small and medium businesses.
Teaching has always been a passion for me. I have taught at the tertiary level for many years on the subjects of programming, control systems as well as systems integration. In the last few years I found myself incorporating more and more videos into the curriculum with amazing results.
When I heard of uDemy I just could not help but sign up. With teaching in a classroom, you can reach only so many students, but with uDemy you can reach the world! I plan to publish and promote as many courses as I possibly can on the uDemy platform.
More courses by Emile Ackbarali
Mastering Modbus RS485 Network Communication (2026)
4.7 (3,854 Reviews)
Provider: Udemy
Time: 3.9h
$19.99
An Introduction to the Controller Area Network (CAN) Bus (2026)
4.5 (2,087 Reviews)
Provider: Udemy
Time: 1.8h
$10.99
Mastering Modbus TCP/IP Network Communication (2026)
4.7 (1,845 Reviews)
Provider: Udemy
Time: 2.8h
$11.99
A Practical Introduction to the BACnet Protocol (2026)
4.7 (1,060 Reviews)
Provider: Udemy
Time: 3.1h
$11.99
How to Install and Configure OPC Client/Server Software (2026)
4.6 (1,018 Reviews)
Provider: Udemy
Time: 2h
$11.99
More IT & Software courses
D3.js Data Visualization Fundamentals - Hands On (2026)
4.9 (3,917 Reviews)
Provider: Udemy
Time: 4.6h
$49.99
Hands-On Training: Streaming Data with Apache Kafka on Azure (2025)
4.9 (103 Reviews)
Provider: Udemy
Time: 3.7h
$10.99
Oracle Grid Infrastructure and RAC using Oracle Database 19c (2026)
4.8 (2,499 Reviews)
Provider: Udemy
Time: 8.7h
$19.99
PowerShell Scripting & Automation: The Complete Hands-On (2026)
4.8 (1,750 Reviews)
Provider: Udemy
Time: 9.6h
$11.99
AWS EC2 Crash Course + Load Balancing with Demos and PDFs (2025)
4.8 (866 Reviews)
Provider: Udemy
Time: 3.7h
$19.99
Reviews
By Charles Bustilos on 7/5/2022
Great course, the content is wonderful and well explain. I really enjoy it and I actually after the course I was able to modify the code to write to any Holding Register and Coil address! This Excel Program is a powerful tool for Modbus Testing and Troubleshooting. Two thumbs up!
By Kenny Sililo on 12/11/2020
I am yet to find another instructor with a better delivery than Emile. His approach to teaching and his explanations are so clear that one does not have to struggle to understand the basics of his courses. No wonder I keep enrolling for the courses. This is my 5th and am still going.
By Olivier Haerlingen on 11/5/2020
Straight to the point, clear and complete. I have now all the tools I need to design an HMI and a datalogging systeme via Excel. I've been loosing lot of time searching those info on the web. I highly recommend this course.
By PJ Mann on 6/9/2020
Was good on the Excel tools and configuration. Would have benefited from a bit more how to set things up on the PLC side (understanding that there are many different types, but even just demonstrate one - how to setup registers, Modbus comms, etc).
By Pasupathy Sithirapathy on 4/13/2020
Course introduced a few things which speeded up the development of excel based monitoring and control of Modbus devices. as a negative, the use of licensed libraries and software was not mentioned until the enrolment.
By Alfred Tolaget on 10/23/2019
I really learnt a lot on this course and will continue to practice the course content to master the it. I will continue to purchase more short courses to upgrade my skills
By Jon Leman on 4/1/2019
I'm an electrical engineer with no experience in networking, SCADA or MODBUS. I've done a little VBA in the past. I needed a simple, customizable SCADA system for a combined cyber-power system simulation project. This was exactly what I needed and very easy to follow. Thanks for the great content!
By Richard Kowalsky on 8/20/2018
The course was an excellent demonstration of how to use Excel for communicating via Modbus with target devices. The presentation and explanations were very clear and easy to follow. Money well spent! Thanks Emile, keep up the good work!
By Bryan Shuman on 3/11/2018
Helped me understand the VBA side to get MBAXP Modbus ActiveX Control running the way I wanted. My goal was to get a HMI put together for trouble shooting end devices. He showed me everything I needed to accomplish the task.
By John Stilwell on 12/8/2017
As usual, Emile is right on. Comprehensive friendly style. Repetition (but not overly so) helps to reinforce concepts. The only minor thing is that IMHO it is stretching it a bit to consider Excel a full fledged HMI without adding other widgets such as meters, sliders, etc. Great course though.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100












