Document Type



This course covers post-advanced microcomputer applications including Microsoft Office Word 2007, Excel 2007, Access 2007, and PowerPoint 2007. Topics include: creating an online form, working with macros and Visual Basic for Applications (VBA), working with a master document, and index and a table of contents, linking an Excel worksheet and charting its data in Word, formula auditing, data validation, and complex problem solving in Excel, importing data into Excel, working with PivotCharts, PivotTables, and trendlines in Excel, creating a PivotTable List, advanced Access report and form techniques, and creating a multi-page form, administering a database system, creating a self-running presentation containing shapes, templates and clips.

Publication Date

Spring 2011


College of Engineering and Computer Science


Computer Science

Course Number

CS 207