Prerequisites

CIT 20600

Offered

Spring

Software

Microsoft Word

Microsoft Excel

Microsoft PowerPoint

Microsoft Access

Microsoft Publisher

Expression Web

Credit By Exam

Yes

Coordinator

J. Starks

Back to Course Description

Advanced topics in Word

• Working with Document Sharing Tools, a Master Document, a Table of Contents, and an Index
• Creating an Online Form
• Enhancing an Online Form and Working with Macros, Document Security, and XML
• Blogging Feature: Creating a Blog Post

Advanced Topics in Excel

• Using Macros and Visual Basic for Applications (VBA) with Excel
• Formula Auditing, Data Validation, and Complex Problem Solving
• Importing Date, Working with PivotCharts, PivotTables, and Trendlines
• Collaboration Feature: Using SharePoint and Excel Services

Advanced Topics in Access

• Advanced Report Techniques
• Advanced Form Techniques
• Administering a Database System
• Web Feature: Sharing Access Data

Advanced Topics in PowerPoint

• Reusing a Presentation with Multimedia
• Creating a Self-Running Presentation Containing Animated Shapes
• Online Feature: Importing Files from the Microsoft Office Online Web Site