· Microsoft Office Outlook 2010/2013 Level 2
Duration: N/A Code: 50258
This intermediate-level Outlook course builds upon basic skills taught in the Level 1 course. Students will learn how to customize messages by setting default message formats and fonts, as well as by adding signatures, themes, and stationery. They will also learn how to create, activate, and turn off Out of Office messages; set message importance and sensitivity; delay delivery of messages; request delivery receipts; and create e-mail polls. Students will learn to mark items for follow-up using Quick Click Flags, perform various mail management tasks using rules, and organize Outlook items using color categories and Search Folders. The course also covers how to address messages using address books and distribution lists, send and respond to meeting and task requests, share Calendars over a network, publish Calendars to Office Online, send Calendar Snapshots, subscribe to Internet Calendars, and configure Outlook to handle other e-mail accounts. The time to take this course will vary based on the student’s individual experience level.
· Microsoft Office PowerPoint 2010/2013 Level 2
Duration: N/A Code: 50260
This intermediate-level course builds upon the basic Microsoft Office PowerPoint skills taught in the Level 1 course. For one, students will learn how to modify the Quick Access toolbar. They will also discover how to use existing information to create a presentation, including importing outlines from Word and inserting slides from other presentations. Students will further explore the use of masters, including how use multiple masters and themes in one presentation, as well as how to create Notes and Handouts masters. Students will work with and modify a variety of graphics, such as WordArt, shapes, pictures, and clip art. Additionally, they will learn about the new Photo Album feature, as well as how to apply a variety of animation effects to both text and graphics. Finally, they will learn how to publish and save presentations as Web pages. The time to take this course will vary based on the student’s individual experience level.
· Microsoft Office Word 2010/2013 Level 2
Duration: N/A Code: 50262
This intermediate-level Word course builds upon basic skills covered in the Level 1 course. Students will learn how to further enhance documents by adding items such as symbols, AutoText, multilevel lists, hyperlinks, and information found using the Research task pane. Paragraph formatting will also be examined, covering skills such as setting indents; changing line spacing and page orientation; setting tab stops; applying paragraph styles; and using Quick Style sets. Students will also learn about sections and how they affect layout decisions such as margins, breaks, and columns. They will also look at how to insert and modify clip art, graphics, shapes, tables, charts, and SmartArt diagrams, as well as how to save documents as Web pages. Finally, a number of revision tools will be introduced, teaching how to insert and modify comments, track changes, accept or reject changes, compare documents, and use the new Document Inspector. The time to take this course will vary based on the student’s individual experience level.
· Microsoft Office Excel 2010/2013 Level 2
Duration: N/A Code: 50264
This course familiarizes students with intermediate-level spreadsheet features. Students will learn how to convert older workbooks to the new default XML-based file format; customize the Quick Access toolbar; use logical and financial functions; format worksheets using themes, styles, and page breaks; use 3-D references; ready workbooks for the Web; use templates to create workbooks; and insert and manipulate objects such as shapes and SmartArt diagrams into a spreadsheet. They will also learn how to customize workbooks by renaming worksheets; inserting, deleting, and hiding worksheets; and changing the color of worksheet tabs. In addition, the course points out how tables in Excel serve as databases and covers how to convert data ranges into tables, apply table styles, freeze and unfreeze rows and columns, sort tables, and use filters in tables. The time to take this course will vary based on the student’s individual experience level.