Reza Moghimi is a Senior Lecturer at the Charles H. Dyson School of Applied Economics and Management within the SC Johnson College of Business at Cornell University. He is a Microsoft MVP, and he has a PhD in Industrial Engineering. His teaching focuses on applied data skills, offering courses such as Spreadsheet Modeling for Management and Economics, Managerial Spreadsheet Modeling, Introduction to Database Management Systems, Excel VBA Programming, and Python Programming for Data Analysis & Business Modeling. Reza has received several prestigious teaching awards, including the SUNY Chancellor’s Award for Excellence in Teaching (2024), the inaugural Dean’s Distinguished Award for Teaching Innovation (2023), and the Dyson Teaching Excellence Award (2021).
Automating Processes With Macros and Excel VBACornell Course
Course Overview
In this course, you will explore Excel automation techniques using Excel macros and Visual Basic for Applications (VBA) code. This practical course equips you with the knowledge to streamline repetitive tasks efficiently, whether you're an Excel novice or you're looking to enhance your existing Excel skills. Without any previous coding experience, you'll be able to write and utilize VBA code to perform tasks in Excel.
You will discover how to record and run macros before delving into some of the limitations of recording macros. You'll then begin to enhance Excel functionality with VBA, manipulate ranges, and engage in hands-on projects. By the end of this course, you'll be well prepared with the basics of using Excel VBA to automate tasks, save time, and boost productivity.
Please note: This course requires Microsoft Excel for Windows. You must have access to a Windows version to successfully complete the course. Microsoft Excel for Mac does not offer the comprehensive VBA functionality necessary to complete the course.
Key Course Takeaways
- Record and run Excel macros
- Describe how to enhance Excel functionality with VBA
- Modify and format ranges with VBA
How It Works
Course Author
Who Should Enroll
- Excel users looking to automate tasks
- Business analysts
- Office administrators and managers
- IT and technical support professionals
- Educators and trainers
- Project managers
- Small business owners
- Individuals transitioning to data-driven roles
- Anyone interested in learning a new programming language
100% Online
cornell's Top Minds
career