Basics of Spreadsheet Programming

Course Objective
To make the student familiar with the fundamentals of spread sheets with special focus on Microsoft Excel and VBA

Learning Outcomes
Upon completion of this course, students will be able to
Use Microsoft Excel effectively
Produce quality VBA code that can be used in a wide variety of circumstances.
Understand complex data types and the best ways to perform operations on them.
Detailed Syllabus

  1. Introduction to Spreadsheets: Basics of Microsoft Excel other spreadsheets.
  2. Introduction to the Visual Basic for Applications
  3. The Excel Object Model: The Application Object, Workbooks and Worksheets, Ranges and Cells
  4. Advanced VBA: Manipulating Data with VBA, Formatting Excel, Creating Add-Ins and

COM Add-Ins, Understanding and Using Events, Manipulating Files, Developing Class

  1. Manipulating Excel Objects: Charts, PivotTables and Pivot Charts, Command Bars,

Customizing Dialog Boxes

  1. Creating User Forms, Creating Advanced User Forms
  2. Excel and the Outside Applications: Excel and Other Office

Applications, Excel and the Structured Query Language, Introducing ADO, Excel Query Program, Excel and the Web,  Excel and the Extensible Markup Language (XML)