Hands-On Computer Seminars

To see all current Hands-On Office Seminars, click here. [1]

Word Level I
Overview the Word screen and Ribbon. Craft letters and documents with ease using the introductory topics in this class. Enter and edit text; create tables, spell and grammar check; insert headers and footers; insert graphics; proof and print documents; save and browse documents. Most topics apply to Word 2007 and 2010. (Textbook included) Prerequisite: General computer skills required before taking this class.

Word Level II
Move your documents from bland to brilliant as you enhance your basic skills using Word. Focus on creating your own style with templates; insert and arrange graphics; format tables; manage document revisions; use mail merge, print labels and envelopes. Pre-requisite: Word Level I. Most topics apply to Word 2007 and 2010. (Textbook included.)

Excel Level I
Bigger and better spreadsheets are even easier with the new Excel. Overview of the Excel interface. Create workbooks and navigate within worksheets. Enter and edit text and numbers; create basic formulas and insert functions; move and copy data; format text, cells, and worksheets; work with ranges, rows, and columns. Most topics apply to both Excel 2007 and 2010. (Textbook included)  Prerequisite: Windows PC skills required before taking this class.

Excel Level II
Improve your average workbook visual appeal and usability. Organize data with sorts and filters; use multiple worksheets and workbooks efficiently; learn to use range names; save workbooks as Web pages or a PDF/XPS file; insert and edit hyperlinks. Pre-requisite:  Excel Level I.  Most topics apply to Excel 2007 and 2010.  (Textbook included)

Excel Level III
Add on to your Level II knowledge and work with advanced concepts/customization.  Import and export data; create custom ranges and use VLOOKUP; work with PivotTables and PivotCharts. Use the analytical features of Excel (such as Goal Seek and Solver), run and record macros, and share Excel worbooks collaboratively. Pre-requisite: Excel Level II. Most topics apply to Excel 2007 and 2010.  (Textbook included)

Access Level I
Manage, store, search, analyze, and display important relational database information with this latest version of Access.  Work with tables, fields, and records; sort and filter data; restructure tables.  Most topics apply to Access 2007 and 2010.  (Textbook included)

Access Level II
Manage your data better and improve your data-reporting techniques in this Level II class.  Create table relationships and enforce data integrity; form controls and objects; print reports and labels; explore additional query capabilities.  Pre-requisite: Access Level I.  Most topics apply to Access 2007 and 2010.  (Textbook included)

Access Level III
Access Level III builds on the skills and concepts taught in Access Level II.  Create multiple table and action queries and link database objects.  Also perform database maintenance tasks including compact and repair; password protection, change properties.  Most topics apply to Access 2007 and 2010.  Pre-requisite: Access Level II.  (Textbook included)

PowerPoint Level I
Create your own professional presentations including text, graphics, WordArt, tables, charts and diagrams.  Make bulleted and numbered lists; SmartArt graphics; edit and format slide content; print slide content; and understand how to manage and deliver a presentation.  Most topics apply to PowerPoint 2007 and 2010.  (Textbook included)

PowerPoint Level II
In Level II, customize the PowerPoint environment and design templates; edit your master hyperlinks; audio and special effects; document revocery; customize slide shows; and finalize a presentation.  Pre-requisite: PowerPoint Level I.  Most topics apply to PowerPoint 2007 and 2010.  (Textbook included)

Outlook
Wrap up your busy life with the new features of Outlook 2010.  Explore the Outlook interface; send and respond to mail; handle junk mail; organize email messages into folder; attachments; stationary; flagging messages; spellchecking; manage contacts and address books; schedule appointments; schedule a meeting.  Pre-requisite: General computer skills.  (Textbook included)

For more information, contact Jack Drooger at 240-500-2453, or e-mail jadrooger@hagerstowncc.edu [2].