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

Part 1: Automating in Excel with Visual Basic for Applications (VBA)

Part One includes two projects. The first project will give you the skills you need to write VBA code that retrieves data from one workbook and pastes it into another. The data will then be appended to existing data on another sheet tab in the destination workbook. Both workbooks will be saved and closed as a result of the VBA code. Your second project will result in the creation of an interactive user form. You will learn to write code for the controls on the form to process user inputs and generate PivotTable reports based on the users’ form selections.