University of Connecticut, Center for Continuing Studies

CCS Home> Professional Studies> Professional Education

Computer Training

	Index of Classes
	Class List

	Transition to MS 2007
	Windows XP File Management
	Word
	Excel
	PowerPoint
	Access
	Outlook

Payment Information

All classes are in Microsoft Office 2007. To upgrade your software
click here.

University of Connecticut
Center for Continuing Studies
One Bishop Circle, Unit 4056
Storrs, CT 06269-4056
860-486-5941

Class List

To register for these classes, click on the class links below.

Transition to MS 2007
	Transition to Word 2007 The top of the application window for Word 2007 has been substantially changed and redesigned. The new ribbon area replaces the menu bar and toolbars that users have applied for many years in the definition and manipulation of information in their Word documents. This session covers the following topics: Major differences between Word 2003 and Word 2007; identifying the relationship between the old commands and toolbar buttons to buttons in ribbon groups; the new file format that Word 2007 uses for its saved files; and useful new features in Word 2007. Experience with previous versions of Word is necessary.
	Transition to Excel 2007 The top of the application window for Excel 2007 has been substantially changed and redesigned. The new ribbon area replaces the menu bar and toolbars that users have applied for many years in the definition and manipulation of information in their Excel documents. This session covers the following topics: Major differences between Excel 2003 and Excel 2007; identifying the relationship between the old commands and toolbar buttons to buttons in ribbon groups; the new file format that Excel 2007 uses for its saved files; and useful new features in Excel 2007. Experience with previous versions of Excel is necessary.
	Transition to Access 2007 The top of the application window for Access 2007 has been substantially changed and redesigned. The new ribbon area replaces the menu bar and toolbars that users have applied for many years in the definition and manipulation of information in their Access documents. This session covers the following topics: Major differences between Access 2003 and Access 2007; identifying the relationship between the old commands and toolbar buttons to buttons in ribbon groups; the new file format that Access 2007 uses for its saved files; and useful new features in Access 2007. Experience with previous versions of Access is necessary.
	Transition to Power Point 2007 The top of the application window for PowerPoint 2007 has been substantially changed and redesigned. The new ribbon area replaces the menu bar and toolbars that users have applied for many years in the definition and manipulation of information in their PowerPoint documents. This session covers the following topics: Major differences between PowerPoint 2003 and PowerPoint 2007; identifying the relationship between the old commands and toolbar buttons to buttons in ribbon groups; the new file format that PowerPoint 2007 uses for its saved files; and useful new features in PowerPoint 2007. Experience with previous versions of PowerPoint is neccesary.

Windows XP File Management
	Understanding Windows XP and File Management Understanding Windows and its file management functions can enhance your computer productivity. As an operating system, many users don't understand the value of knowing how to use Windows, particularly its file management capabilities. This session covers basic Windows tasks including working with multiple applications, the nature of scraps, using Windows Explorer, storage devices and file management principles. Prerequisites: None

Word 2007
	Understanding Word Identifying the parts of the Word screen; moving around in a document; selecting, inserting, deleting, formatting and printing text. Prerequisites: None
	Word Mail Merge Doing a Word Mail Merge: Preparing the merge document; creating merge data files; using other sources for merge data; printing or saving merge results. Prerequisites: Word Beyond the Basics, or a good working knowledge of the basics of Word documents.
	Word: Beyond the Basics Working with tabs, manipulating toolbars, creating document sections, establishing columns, adding tables. Prerequisite: Understanding Word, or a good working knowledge of the basics of Word documents.

	Creating Tables and Working with Graphics in Word Establishing columns; working with graphic objects. Prerequisite: good working knowledge of Word fundamentals.

Excel 2007
	Understanding Excel Identifying parts of Excel screen, navigating a worksheet, entering data including simple formulas, selecting ranges, formatting and printing ranges. Prerequisite: none
	Excel: Beyond the Basics Moving and copying ranges, inserting and deleting rows and columns, working with text boxes, understanding absolute cell address references in formulas. Prerequisite: Understanding Excel, or a good working knowledge of the basics of Excel worksheets.
	Building Charts and Graphs in Excel Constructing and editing Excel charts including pie, bar, and line charts. Prerequisite: Excel Beyond the Basics, or a good working knowledge of the basics of Excel worksheets including the use of simple formulas.
	Using Excel Database Capabilities Sorting and filtering database information in Excel, using database functions. Prerequisite: Excel Beyond the Basics, or a good working knowledge of the basics of Excel worksheets including the use of simple formulas.
	Enhancing Excel Formulas Using functions, identifying external references, working in 3-D across sheets in a workbook. Prerequisites: Excel Beyond the Basics, or a good working knowledge of the basics of Excel worksheets including the use of simple formulas.
PowerPoint 2007
	Understanding PowerPoint Identifying the different presentation views; working with text, bullet, and picture objects; using the slide sorter, understanding slide layouts and designs. Prerequisite: none
	Creating and Enhancing PowerPoint Slide Shows Applying transitions, setting custom animation, adding action buttons. Prerequisites: PowerPoint Beyond the Basics, or good working knowledge of PowerPoint presentation fundamentals including the use of bullet objects, designs, and slide sorter.
	PowerPoint Beyond the Basics Applying designs, understanding the role of the masters, creating templates. Prerequisites: Understanding PowerPoint, or a good working knowledge of the basics of PowerPoint presentations.
Access 2007
	Working with Access Tables Management of database tables including creating tables as well as adding, editing, deleting, sorting, finding, and printing table records. Prerequisite: none
	Using Access Select Queries Creating and developing select queries covering establishing fields, making sorting arrangements, and establishing criteria. Prerequisite: Working with Access Tables, or a good working knowledge of Access database tables.
	Developing Access Reports Designing, constructing, modifying, and printing Access reports. Prerequisite: Using Access Select Queries, or a good working knowledge of Access database tables and select queries.
	Integrating Access Forms Designing, constructing, modifying, and printing Access forms. Prerequisite: Using Access Select Queries, or a good working knowledge of Access database tables and select queries.
	Understanding Access Expressions Creating Access expressions and using them in queries, reports, and forms. Prerequisites: Developing Access Reports, or a good working knowledge of Access database tables, select queries, reports, and forms

Outlook 2007
	Understanding Outlook Email management is a vital part of using Outlook. This session covers enhancing effective email processing including the following topics: composing an email message, adding a file attachment, flagging emails, filtering emails, managing your inbox, and interacting with schedules and contacts. Prerequisites: None
	Outlook Beyond the Basics Working with contacts; managing your schedule; monitoring tasks. Prerequisite: good working knowledge of basic Outlook email fundamentals.