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).
Enhancing the Excel User Experience With VBACornell Course
Course Overview
This course will provide you with the skills needed to create powerful and customized solutions within Excel that improve the user experience. You will discover how to write your own custom functions in VBA, allowing you to perform calculations and automate repetitive tasks that go beyond the built-in Excel functions. You'll then delve into importing data from external files, understanding how to access data from various sources. Practical examples will guide you through importing worksheets and handling multiple external files efficiently.
You will also practice designing and coding interactive forms that communicate with users. From basic form design to retrieving information and handling user input with VBA code, you'll gain confidence in creating user-friendly solutions. Finally, you'll explore workbook settings, sheet navigation, and access restrictions, enabling you to zoom in on specific content, protect your workbook, or control user access. By the end of this course, you'll be equipped with the confidence to design user-friendly solutions.
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.
You are required to have completed the following courses or have equivalent experience before taking this course:
- Automating Processes With Macros and Excel VBA
- Applying Logic for Efficient Processing of Tasks
Key Course Takeaways
- Create user-defined Excel functions
- Develop a VBA solution for working with external files
- Design and code forms to communicate with the user
- Control user activity in Excel
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