This course covers post-advanced microcomputer applications including Microsoft
Office Word 2003, Microsoft Office Excel 2003, Microsoft Office Access 2003, and Microsoft
Office PowerPoint 2003. Topics include: creating an online form; working with macros and
Visual Basic for Applications (VBA); working with a master document, an 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 multi-page forms; administering a database system; creating a self-running presentation containing shapes, templates and clips.
College of Engineering and Computer Science