Course Description
Overview
Excel programming using VBA course bundle is designed to teach students programming using visual basic programming language. The bundle encapsulates within it the integrated visual basic development environment required for building applications using excel. The course content is structured to meet basic to advance visual basic taught Modules as well as project class. The lessons are strategically taught to transfer the needed visual basic programming skills required for building applications using excel VBA
Course Objectives
- Students will gain an understanding of core function programming and creation using excel VBA.
- Students will gain core insight into object oriented programming using Excel Integrated Development Environment IDE
- Students will gain insight into data analysis, visualization, and reporting in excel VBA
- Students will evaluate his/her course module quotiently vis-a-vis problem solving capabilities of excel VBA in data analysis and visualization as assigned in the course module(PROJECT CLASS).
Learning Outcomes
- Students will know function programming in excel VBA.
- Students will know Object Oriented Programming using Excel Integrated Development Environment(IDE).
- Students will know the concepts of data analysis, visualization, reporting in excel VBA.
- Students will do course evaluation.