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).
Accessing Advanced Excel SolutionsCornell Course
Course Overview
This course offers valuable insights and practical skills that will empower you to tackle complex tasks in Excel effectively. You will begin by immersing yourself in VBA events, where you'll discover how to automate actions based on specific triggers. You'll explore event triggers, brainstorm creative business solutions, and create event handlers. From workbook events to worksheet interactions, you'll gain the ability to respond dynamically to user actions.
You will also examine Excel's new dynamic array functions and assess how they are different from traditional functions. While this is not specifically about VBA, it addresses essential Excel functionalities that can significantly enhance your projects.
Finally, you will apply your VBA skills to a case study in which you'll design a comprehensive business solution for a small coffee shop. You'll determine how to create a user-friendly interface to manage daily operations and automate some repetitive tasks. This case study will serve as a practical summary of many of the foundational VBA concepts studied previously, allowing you to apply your knowledge to realistic situations.
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
- Enhancing the Excel User Experience With VBA
Key Course Takeaways
- Trigger code with workbook or worksheet VBA events
- Apply Excel's new solution for a dynamic range with dynamic array functions
- Record macros to write more advanced VBA code
- Apply VBA fundamentals to create a business solution for a case study
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