What’s included?

• Authorized Courseware
• Intensive Hands on Skills Development with an Experienced Subject Matter Expert
• Hands-on practice on real Servers and extended lab support 1.800.482.3172
• Examination Vouchers & Onsite Certification Testing- (excluding Adobe and PMP Boot Camps)
• Academy Code of Honor: Test Pass Guarantee
• Optional: Package for Hotel Accommodations, Lunch and Transportation

Curriculum

Word 2013 (Exam 77-418)
• Create and manage documents
o Create a document
? Creating new blank documents, creating new documents using templates, importing files, opening non-native files directly in Word, opening a PDF in Word for editing
o Navigate through a document
? Searching for text within a document, inserting hyperlinks, creating bookmarks, using Go To
o Format a document
? Modifying page setup, changing document themes, changing document style sets, inserting simple headers and footers, inserting watermarks, inserting page numbers
o Customize options and views for documents
? Changing document views, using Zoom, customizing the quick access toolbar, customizing the ribbon, splitting the window, adding values to document properties, using show/hide, recording simple macros, assigning shortcut keys, managing macro security
o Configure documents to print or save
? Configuring documents to print, saving documents in alternate file formats, printing document sections, saving files to remote locations, protecting documents with passwords, setting print scaling, maintaining backward compatibility
• Format text, paragraphs, and sections
o Insert text and paragraphs
? Appending text to documents, finding and replacing text, copying and pasting text, inserting text via AutoCorrect, removing blank paragraphs, inserting built-in fields, inserting special characters
o Format text and paragraphs
? Changing font attributes, using find and replace to format text, using format painter, setting paragraph spacing, setting line spacing, clearing existing formatting, setting indentation, highlighting text selections, adding styles to text, changing text to WordArt, modifying existing style attributes
o Order and group text and paragraphs
? Preventing paragraph orphans, inserting breaks to create sections, creating multiple columns within sections, adding titles to sections, forcing page breaks
• Create tables and lists
o Create a table
? Converting text to tables, converting tables to text, defining table dimensions, setting AutoFit options, using quick tables, establishing titles
o Modify a table
? Applying styles to tables, modifying fonts within tables, sorting table data, configuring cell margins, using formulas, modifying table dimensions, merging cells
o Create and modify a list
? Adding numbering or bullets, creating custom bullets, modifying list indentation, modifying line spacing, increasing and decreasing list levels, modifying the numbering
• Apply references
o Create endnotes, footnotes, and citations
? Inserting endnotes, managing footnote locations, configuring endnote formats, modifying footnote numbering, inserting citation placeholders, inserting citations, inserting bibliography, changing citation styles
o Create captions
? Adding captions, setting caption positions, changing caption formats, changing caption labels, excluding labels from captions
• Insert and format objects
o Insert and format building blocks
? Inserting quick parts, inserting text boxes, utilizing building locks organizer, customizing building blocks
o Insert and format shapes and SmartArt
? Inserting simple shapes, inserting SmartArt, modifying SmartArt properties (color, size, shape), wrapping text around shapes, positioning shapes
o Insert and format images
? Inserting images, applying artistic effects, applying picture effects, modifying image properties (color, size, shape), adding quick styles to images, wrapping text around images, positioning images

Excel 2013 (Exam 77-420)
• Create and manage worksheets and workbooks
o Create worksheets and workbooks
? Creating new blank workbooks; creating new workbooks using templates; importing files; opening non-native files directly in Excel; adding worksheets to existing workbooks; copying and moving worksheets
o Navigate through worksheets and workbooks
? Searching for data within a workbook; inserting hyperlinks; changing worksheet order; using Go To; using Name Box
o Format worksheets and workbooks
? Changing worksheet tab color; modifying page setup; inserting and deleting columns and rows; changing workbook themes; adjusting row height and column width; inserting watermarks; inserting headers and footers; setting data validation
o Customize options and views for worksheets and workbooks
? Hiding worksheets; hiding columns and rows; customizing the Quick Access toolbar; customizing the Ribbon; managing macro security; changing workbook views; recording simple macros; adding values to workbook properties; using zoom; displaying formulas; freezing panes; assigning shortcut keys; splitting the window
o Configure worksheets and workbooks to print or save
? Setting a print area; saving workbooks in alternate file formats; printing individual worksheets; setting print scaling; repeating headers and footers; maintaining backward compatibility; configuring workbooks to print; saving files to remote locations
• Create cells and ranges
o Insert data in cells and ranges
? Appending data to worksheets; finding and replacing data; copying and pasting data; using AutoFill tool; expanding data across columns; inserting and deleting cells
o Format cells and ranges
? Merging cells; modifying cell alignment and indentation; changing font and font styles; using Format Painter; wrapping text within cells; applying Number format; applying highlighting; applying cell styles; changing text to WordArt
o Order and group cells and ranges
? Applying conditional formatting; inserting sparklines; transposing columns and rows; creating named ranges; creating outline; collapsing groups of data in outlines; inserting subtotals
• Create tables
o Create a table
? Moving between tables and ranges; adding and removing cells within tables; defining titles
o Modify a table
? Applying styles to tables; banding rows and columns; inserting total rows; removing styles from tables
o Filter and sort a table
? Filtering records; sorting data on multiple columns; changing sort order; removing duplicates
• Apply formulas and functions
o Utilize cell ranges and references in formulas and functions
? Utilizing references (relative, mixed, absolute); defining the order of operations; referencing cell ranges in formulas
o Summarize data with functions
? Utilizing the SUM function; utilizing the MIN and MAX functions; utilizing the COUNT function; utilizing the AVERAGE function
o Utilize conditional logic in functions
? Utilizing the SUMIF function; utilizing the AVERAGEIF function; utilizing the COUNTIF function
o Format and modify text with functions
? Utilizing the RIGHT, LEFT and MID functions; utilizing the TRIM function; utilizing the UPPER and LOWER functions; utilizing the CONCATENATE function
• Create charts and objects
o Create a chart
? Creating charts and graphs; adding additional data series; switching between rows and columns in source data; using Quick Analysis
o Format a chart
? Adding legends; resizing charts and graphs; modifying chart and graph parameters; applying chart layouts and styles; positioning charts and graphs
o Insert and format an object
? Inserting text boxes; inserting SmartArt; inserting images; adding borders to objects; adding styles and effects to objects; changing object colors; modifying object properties; positioning objects

PowerPoint 2013 (Exam 77-422)
• Create and Manage Presentations
o Create a Presentation
? This objective may include but is not limited to: creating blank presentations, creating presentations using templates, importing text files into presentations, importing Word document outlines into presentations
o Format a Presentation Using Slide Masters
? This objective may include but is not limited to: applying a slide master, adding new layouts, modifying existing layouts, adding background images, controlling page numbers, inserting headers and footers, modifying presentation themes
o Customize Presentation Options and Views
? This objective may include but is not limited to changing page setup options, changing to view in color/grayscale, using views to navigate through presentations, modifying presentation properties
o Configure Presentations to Print or Save
? This objective may include but is not limited to: setting handout print options, printing selections from presentations, packaging presentations for CD, saving presentations as web pages, printing presentations in grayscale, printing speaker notes, maintaining backward compatibility
o Configure and Present Slideshows
? This objective may include but is not limited to: creating custom slideshows, configuring slideshow options, rehearsing timing, configuring slideshow resolution, using Presenter View, navigating within slideshows, annotating slideshows
• Insert and Format Shapes and Slides
o Insert and Format Slides
? This objective may include but is not limited to: adding slides layouts, duplicating existing slides, hiding slides, deleting slides, modifying slide backgrounds, applying styles to slides
o Insert and Format Shapes
? This objective may include but is not limited to: modifying shape backgrounds, applying borders to shapes, resizing shapes, inserting shapes, creating custom shapes, applying styles to shapes
o Order and Group Shapes and Slides
? This objective may include but is not limited to: inserting section headers, modifying slide order, aligning and grouping shapes, displaying gridlines
• Create Slide Content
o Insert and Format Text
? This objective may include but is not limited to: changing text to WordArt, creating multiple columns in a single shape, inserting hyperlinks, applying formatting and styles to text, creating bulleted and numbered lists
o Insert and Format Tables
? This objective may include but is not limited to: creating new tables, modifying the number of rows and columns, applying table styles, importing tables from external sources
o Insert and Format Charts
? This objective may include but is not limited to: creating and modifying chart styles, inserting charts, modifying chart type, adding legends to charts, modifying chart parameters, importing charts from external sources
o Insert and Format SmartArt
? This objective may include but is not limited to: adding shapes to SmartArt, changing the color of SmartArt, moving text within SmartArt shapes, reversing direction, converting lists to SmartArt
o Insert and Format Images
? This objective may include but is not limited to: resizing images, cropping images, applying effects, applying styles
o Insert and Format Media
? This objective may include but is not limited to: adjusting media window size, trimming timing on media clips, setting start/stop times, setting media options, linking to external media
• Apply Transitions and Animations
o Apply Transitions between Slides
? This objective may include but is not limited to: inserting transitions between slides, managing multiple transitions, modifying transition effect options
o Animate Slide Content
? This objective may include but is not limited to: applying animations to shapes, applying animations to text strings, adding paths to animations, modifying animation options
o Set Timing for Transitions and Animations
? This objective may include but is not limited to: modifying the duration of effects, configuring start and finish options, reordering animations, using the Animation Pane
• Manage Multiple Presentations
o Merge Content from Multiple Presentations
? This objective may include but is not limited to: merging multiple presentations, reusing slides from other presentations, viewing multiple presentations
o Track Changes and Resolve Differences
? This objective may include but is not limited to: setting track changes, modifying options for track changes, discarding changes from specific users, managing comments
o Protect and Share Presentations
? This objective may include but is not limited to: encrypting presentations with a password, proofing presentations, marking as final, compressing media, embedding fonts, restricting permissions, removing presentation metadata, checking for accessibility issues, checking for compatibility issues

Outlook 2013 (Exam 77-423)
• Manage the Outlook Environment
o Customize Outlook Settings.
? This objective may include but is not limited to: including original messages with all reply messages, changing text formats for all outgoing messages, customizing the Navigation Pane, blocking specific addresses, configuring views, managing multiple accounts, setting Outlook options
o Automate Outlook.
? This objective may include but is not limited to: changing quoted text colors, creating and assigning signatures, using Quick Steps, creating and managing rules, creating auto-replies
o Print and Save Information in Outlook.
? This objective may include but is not limited to: printing messages, printing calendars, saving message attachments, previewing attachments, printing contacts, printing tasks, saving messages in alternate formats, creating data files
o Search in Outlook.
? This objective may include but is not limited to: creating new search folders, searching for messages, searching for tasks, searching for contacts, searching calendars, using advanced find, using Search by Location
• Manage Messages
o Create a Message.
? This objective may include but is not limited to: creating messages, forwarding messages, deleting messages, adding/removing message attachments, adding cc and bcc to messages, adding voting options to messages, replying to all, replying to sender only, prioritizing messages, marking as private, requesting delivery/read receipt, redirecting replies, delegating access
o Format a Message
? This objective may include but is not limited to: formatting text, inserting hyperlinks, applying themes and styles, inserting images, adding a signature to specific messages, formatting signatures, creating and using Quick Parts
o Organize and Manage Messages.
? This objective may include but is not limited to: sorting messages, moving messages between folders, adding new local folders, applying categories, configuring junk e-mail settings, cleaning up messages, marking as read/unread, flagging messages, ignoring messages, sorting by conversation, setting attachment reminder options
• Manage Schedules
o Create and Manage Calendars.
? This objective may include but is not limited to: adjusting viewing details for calendars, modifying calendar time zones, deleting calendars, setting calendar work times, using multiple calendars, managing calendar groups, overlaying calendars, sharing calendars
o Create Appointments, Meetings, and Events.
? This objective may include but is not limited to: creating calendar items, creating recurring calendar items, canceling calendar items, creating calendar items from messages, setting calendar item times, categorizing calendar items, using the scheduling assistant, changing availability status, scheduling resources, utilizing Room Finder
o Organize and Manage Appointments, Meetings, and Events.
? This objective may include but is not limited to: setting calendar item importance, forwarding calendar items, configuring reminders, adding participants, responding to invitations, updating calendar items, sharing meeting notes
o Create and Manage Notes, Tasks, and Journals.
? This objective may include but is not limited to: creating and managing tasks, creating and managing notes, attaching notes to contacts, creating journal entries, updating task status
• Manage Contacts and Groups
o Create and Manage Contacts.
? This objective may include but is not limited to: creating new contacts, deleting contacts, importing contacts from external sources, editing contact information, attaching an image to contacts, adding tags to contacts, sharing contacts, managing multiple address books
o Create and Manage Groups.
? This objective may include but is not limited to: creating new contact groups, adding contacts to existing groups, adding notes to a group, updating contacts within groups, deleting groups, deleting group members