Course Descriptions

Sinnott School

Training For Confidence and Success Since 1985

Course Descriptions

Level I: Creating a document, formatting text, Editing text, formatting paragraphs, adding tables, using word timesavers, setting page display and printing options.

Level II: Creating and modifying templates, managing templates and table data in documents, adding graphics, creating a newsletter, sending from letters, managing document changes.

Level III: Creating and distributing forms, automating tasks, referencing document information, preparing a document for publication, revising documents.

Microsoft Word I, II, III

Level I: Editing your worksheet, performing calculations, formatting, working with multiple worksheets, creating and modifying charts, setting page display and printing options.

Level II: Working with templates, sorting and filtering data, importing and exporting data, working with advanced formulas, analyzing data, collaborating.

Level III: Customizing your workbook, working with multiple data sources, collaborating with others using workbooks, enhancing your worksheet using charts, using graphic objects to enhance your worksheet.

Excel Introduction to VBA

Prerequisite: Excel Level 1 and Excel Level 2

Developing Macros: Create a Macro with the Macro Recorder; Edit a Macro; Debug a Macro; Customize Toolbars, Menus, and Hotkeys

Formatting Worksheets: Sort Data; Insert Rows and Columns; Insert Text; Format Text; Duplicate Data; Generate a Report

Creating an Interactive Worksheet: Determine Dialog Box Type; Capture User Input

Working with Multiple Worksheets: Insert, Copy, and Delete Worksheets; Rename Worksheets; Modify the Order of Worksheets; Print Worksheets

Performing Calculations: Create User-defined Functions; Automate SUM Functions

Microsoft Excel I, II, III, VBA

Level I: Starting a new presentation, drawing and working with objects, Clipart, Tables, WordArt, creating charts, working with templates and the slide master, slide show and output, preparing presentations for the web.

Level II: Creating a custom design template, creating presentations with special effects, delivering a presentation, creating presentations for the web, reviewing and broadcasting presentations.

Microsoft PowerPoint I, II

Level I: Working with a relational database, planning a database, building the basic structure, working with tables, creating and working with the select queries, creating and using forms, creating and using reports.

Level II: Managing a database and data, controlling data entry, finding and joining data, creating flexible queries, improving your forms, customizing your reports, making your data available on the web.

Level III: Structuring existing data, summarizing data, simplifying tasks with Macros, adding interaction and automation with Macros, making forms more usable, making reports more powerful, expanding the reach of your data.

Microsoft Access I, II, III

Microsoft Outlook I, II

Level I: Sending messages, acting on messages, scheduling appointments events and meetings, using contacts, creating tasks, managing messages, using notes.

Level II: Customizing your mail, working with contacts, managing your work, managing your mailbox and calendar, customizing outlook, sharing information, saving and archiving mail.

Microsoft Publisher

Creating a basic publication, modifying a publication's layout and structure, editing content in a publication, formatting a publication, formatting pictures in a publication, preparing a publication for distribution.