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.

 

How It Works

Course Length
2 weeks
Effort
3 to 5 hours of study per week
Format
100% online, instructor-led
  • 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
Get It Done 100% Online
Our programs are expressly designed to fit the lives of busy professionals like you.
Learn From cornell's Top Minds
Courses are personally developed by faculty experts to help you gain today's most in-demand skills.
Power Your career
Cornell's internationally recognized standard of excellence can set you apart.

Request Information Now by completing the form below.

Act today—courses are filling fast.

By providing your contact information, you consent to receive communications from Cornell University, including with the use of automated technology.  You can opt out at any time.  By selecting the text box, you consent to Cornell texting you.  You confirm this phone number belongs to you.  Message and data rates may apply.  You can reply STOP to opt out of texts at any time. Full Terms | Privacy Policy