More Than 250
Courses
Developed through years of expertise, CPS HR teaches up-to-date skills applicable on the job.

Part 2: Automation Cross-Functionality and Application Development with VBA

Part Two includes two projects. The first project will give you the skills you need to create an advanced form that will allow users to import ranges of data in one workbook into a different workbook. The imported data will be manipulated using VBA built-in functions. You will write code to export to a Word file formatted as a report. The second project will focus on customizing the Excel interface using VBA. Specifically, you will create an Excel Add-in and modify shortcut menus in the Excel application. You will also use Workbook events to further automate your work. We will use some of the code created in Part One in this part.