For questions and/or additional information contact Lisa Stahley
at (302) 857-1400 or via email at: lstahley@dtcc.edu
Courses descriptions, prerequisites, dates and times:
- Microsoft Office 2007
- PowerPoint 2007
- Microsoft Word 2007
- Microsoft Excel 2007
- Microsoft Access 2007
- Quickbooks
This class is for students will little or no experience with Microsoft Office. You will learn the similar or identical components of the Office software applications, including basic editing commands, common shortcut keys, customizing toolbars and menus, using page setup commands, printing files, working with fonts, cutting/copying and pasting data, and all of the exciting new features of Office 2007. (12 hours, 1.2 CEUs) Cost: $239
M & W 4/19 – 4/28 6:30–9:30pm
Combine, link and embed data within Microsoft Office documents (Word, Excel, Access and PowerPoint) to eliminate repetitive typing and decrease errors. Use names and addresses in an Access database as the data source for a Word mail merge, create a hyperlink from a PowerPoint presentation to an Excel document, insert a Word outline in PowerPoint presentation, insert a link to an Excel file from a Word document, and embed an Excel chart into a PowerPoint slide or Word document.
T & R 4/20 – 4/29 6:30–9:30pm
Topics include creating presentations from scratch and using the AutoContent wizard, rearranging and deleting slides, entering, editing and formatting text, setting tabs, templates, slide masters, adding transitions and timings, speaker notes and footers, setting up slide shows, proofing tools, running and printing presentations, drawing tools, AutoShapes and all of the exciting new features of PowerPoint 2007.
(12 hours, 1.2 CEUs) Cost: $239
M&W 2/15 – 2/24 6:30–9:30pm
T & W 2/2 – 2/3 9:00am–4:30pm
M & W 3/1 – 3/10 6:30–9:30pm
PowerPoint Intermediate 2007
*Prerequisite: PowerPoint Basics
(12 hours, 1.2 CEUs) Cost: $239
M & T 3/8 – 3/16 6:30–9:30pm
M & T 3/22 – 3/30 6:30–9:30pm
Includes modifying templates, custom templates, custom slide masters, advanced clip art and drawing techniques, adding movies, adding sound clips, animations, scanned images, advanced organization chart options, formatting and modifying tables, adding special effects, working with slide show options, review cycles, advanced presentation delivery techniques and more.
(12 hours, 1.2 CEUs) Cost: $239
M & W 4/5 – 4/14 6:30–9:30pm
Topics include entering and editing text, moving and copying text, formatting text and paragraphs, proofing tools, page layout features, printing a document, creating basic tables and using graphics as well as all of the exciting new features of Word 2007. (12 hours, 1.2 CEUs) Cost: $239
M & T 1/25 – 1/26 9:00am–4:30pm
T & R 2/2 – 2/11 6:30–9:30pm
T & R 3/9 – 3/18 6:30–9:30pm
T & R 4/13 – 4/22 6:30–9:30pm
Topics include managing lists, tables and charts, advanced text formatting, styles, advanced graphics editing, AutoShapes, WordArt, text boxes, section breaks, columns, basic macros, templates, mail merge and more. *Prerequisite: MS Word Basics 2007. (12 hours, 1.2 CEUs) Cost: $239
T & R 2/2 2/11 6:30–9:30pm
T & R 3/2 –3/11 6:30–9:30pm
T & R 3/2&3/4 9:00am–4:30pm
Topics include document collaboration, file formats, research sites, document versions, collaboration, tracking changes, reference marks, working with long documents, document security features, forms and more. *Prerequisite: MS Word Intermediate 2007. (12 hours, 1.2 CEUs) Cost: $239
T & R 2/16 – 2/25 6:30–9:30pm
Topics include entering and editing data and formulas, modifying worksheets, relative and absolute references, using functions, formatting worksheets, printing and basic charts as well as all of the exciting new features of Excel 2007.
(12 hours, 1.2 CEUs) Cost: $239
M & W 2/15 – 2/17 9:00am–4:30pm
W & R 1/20 – 1/21 9:00am–4:30pm
M & W 3/1 – 3/10 6:30–9:30pm
T & R 4/27 – 5/6 6:30–9:30pm
Microsoft Excel Intermediate 2007
Topics include working with large worksheets, multiple worksheets and workbooks, borders and shading, custom number formats, date functions, styles, conditional formatting, lists, advanced charting, auditing features, comments, text boxes, protecting worksheets and workbooks, workgroup collaboration, templates and more. *Prerequisite: MS Excel Basics 2007. (12 hours, 1.2 CEUs) Cost: $239
M & T 3/8 – 3/16 6:30–9:30pm
M & T 3/22 – 3/30 6:30–9:30pm
Topics include naming cells, advanced functions, lookup and data tables, advanced list management, database functions, data forms, Pivot Tables and Pivot Charts, Goal Seek, Solver, scenarios, views, macros and more. *Prerequisite: MS Excel Intermediate 2007
(12 hrs, 1.2 CEUs) Cost: $239
M & W 4/5 – 4/14 9:00am–4:30pm
Topics include database terminology, understanding relational databases, the Access environment, managing data in forms and tables, table relationships, select queries, calculated fields in queries and reports, designing forms and designing reports, and all of the exciting new features of Access 2007.
(12 hours, 1.2 CEUs) Cost: $239
M&W 2/22/ – 2/24 9:00am–4:30pm
T & R 1/19 – 1/28 6:30–9:30pm
M & W 3/8 – 3/17 6:30–9:30pm
T & R 4/13 – 4/22 6:30–9:30pm
Microsoft Access Intermediate 2007
Topics include planning an effective and efficient database, building the database structure, controlling data entry, finding and joining data, queries, advanced forms, customizing reports, and more. *Prerequisite: MS Access Basics 2007.
(12 hours, 1.2 CEUs) Cost: $239
M & W 2/1 – 2/10 6:30–9:30pm
Microsoft Access Advanced 2007
Topics include importing data, analyzing tables using Analyzer Wizard, junction tables, advanced queries, macros, forms (conditional formatting, displaying a calendar on a form, creating tab pages), reports (including a chart on a report, columns, report snapshots), database maintenance and more. *Prerequisite: MS Access Intermediate 2007
(12 hrs, 1.2 CEUs) Cost: $239
T&R 2/16 – 2/25 6:30–9:30pm
Includes creating a company file, creating and modifying lists, ordering items, adjusting inventory, receiving items, receiving and paying bills, invoicing customers, recording cash sales, and other tasks. (12 hours, 1.2 CEUs) Cost: $239
M & W 4/19 – 4/28 6:30–9:30pm
Includes customizing forms; working with credit card accounts, asset accounts, liability accounts and equity accounts; creating, modifying, memorizing and printing reports; creating and working with graphs; tracking and paying sales tax; and doing payroll. *Prerequisite: Intro to QuickBooks
(12 hours, 1.2 CEUs) Cost: $239
T & R 4/20 – 4/29 6:30–9:30pm
