Microsoft Certified IT Professional (MCITP): Enterprise Administrator

Introduction
Enterprise administrators are recognized among their peers and managers as leaders in Windows infrastructure design. Make sure your expertise in Windows Server 2008 stands out. Earn the MCITP: Enterprise Administrator certification, distinguishing you as an IT professional committed to excellence in working with Windows Server 2008.

The Microsoft Certified IT Professional (MCITP) credential is the leading certification for Windows Server 2008, providing widely recognized, objective validation of your ability to perform critical, current IT job roles by using Microsoft technologies to their best advantage.

Candidates for this certification are IT professionals who want to be known as leaders and problem solvers in a current or future role in an organization that uses Windows Server 2008.

Course Outline:-
70-640

Configuring Domain Name System (DNS) for Active Directory

Configuring the Active Directory infrastructure

Configuring additional Active Directory server roles

Creating and maintaining Active Directory objects

Maintaining the Active Directory environment

Configuring Active Directory Certificate Services
Course Outline:-
70-642

Configuring IP Addressing and Services

Configuring Name Resolution

Configuring Network Access

Configuring File and Print Services

Monitoring and Managing a Network Infrastructure
Course Outline:-
70-643

Deploying Servers

Configuring Terminal Services

Configuring a Web Services Infrastructure

Configuring Network Application Services

Course Outline:-
70-620

Installing and upgrading Windows Vista

Configuring and troubleshooting Post-installation system settings

Configuring Windows security features

Configuring network connectivity

Configuring applications included with Windows Vista

Maintaining and optimizing systems that run Windows Vista

Configuring and troubleshooting mobile computing
Course Outline:-
70-647

Planning network and application services

Designing core identity and access management components

Designing support identity and access management components

Designing for business continuity and data availability

Microsoft Exchange Server 2010, configuration

Exam Code: 70-662

Description 

Instructor-led course will provide you with the knowledge and skills to configure and manage an Exchange Server 2010 messaging environment. This course requires previous Exchange Server experience and requires that students have good experience in managing Windows Server and Active Directory directory services or Active Directory Domain Services (AD DS). This course will teach you how to configure Exchange Server 2010, as well as provide guidelines, best practices, and considerations that will help you optimize your Exchange Server deployment

Prerequisites

• Fundamental knowledge of network technologies including Domain Name System (DNS) and firewall technologies
• Experience with the Windows Server 2003 and Microsoft Windows Server 2008 operating systems
• Experience with Active Directory directory services in Windows Server 2003 or AD DS Windows Server 2008
• Experience managing backup and restore on Windows Servers
• Experience using Windows management and monitoring tools such as Microsoft Management Console, Active Directory Users and Computers, Performance Monitor, Event Viewer, and Internet Information Services (IIS) Administrator
• Experience using Windows networking and troubleshooting tools such as Network Monitor, Telnet, and NSLookup
• Fundamental knowledge of certificates and Public Key Infrastructure (PKI)
• Basic experience with Windows Mobile

List of Topics

Module 1: Deploying Microsoft Exchange Server 2010

Module 2: Configuring Mailbox Servers 

Module 3: Managing Recipient Objects 

Module 4: Managing Client Access

Module 5: Managing Message Transport

Module 6: Implementing High Availability

 Module 7: Implementing Backup and Recovery

Module 8: Configuring Messaging Policy and Compliance

 Module 9: Upgrading from Exchange Server 2003 or Exchange Server 2007 to Exchange Server 2010

MOC-6422A – Hyper V

 MOC-6422A

MICROSOFT EXCEL 2010 Course Outline:

  Using Excel 2010
• The Excel Cell Referencing System
• Entering Numbers and Text
• Summing a Column of Numbers
• Entering a Date
• Worksheets and Workbooks
• Saving a Workbook
• Creating a New Workbook
• Opening a Workbook
• Switching between Workbooks
• Help

Selection Techniques
• Selecting a Cell, cell range, row & column.

Manipulating Rows and Columns
• Inserting Rows & Columns
• Deleting Rows& Columns
• Column Widths
• Row Heights

Manipulating Cells and Cell Content
• Copying a Cell or Range Contents
• Deleting Cell Contents
• Moving the Contents of a Cell or Range.
• Editing Cell Content
• Undo and Redo
• AutoFill
• Sorting
• Searching and Replacing

Worksheets
• Renaming a Worksheet
• Inserting a New Worksheet
• Deleting a Worksheet
• Copying and moving a Worksheet

Font Formatting
• Font Type
• Font Size
• Bold, Italic, Underline
• Cell Border Formatting
• Background Colour
• Font Colour

Alignment Formatting
• Aligning cell contents
• Centring a Title Over a Cell Range
• Cell Orientation
• Text Wrapping
• Format Painter

Number Formatting
• Decimal Point Display
• Comma Style Formatting
• Currency Symbol
• Date Styles
• Percentages

Freezing Row and Column Titles
• Freezing Row and Column Titles

Formulas
• Creating Formulas
• Copying Formulas
• Operators
• Using Operators In Formulas
• Formula Error Messages
• Relative Cell Referencing
• Absolute Cell Referencing

Functions
• Sum Function
• Average Function
• Max Function
• Min Function
• Count Function
• The Counta Function
• The Countblank Function
• Using the If Function

Charts
• Inserting different chart types.
• Resizing and deleting a Chart
• Chart Title or Labels
• Chart Background Colour
• Column, Bar, Line or Pie Slice Colours
• Copying and Moving Charts

Customising Excel
• Modifying Excel Options
• Minimising the Ribbon
• Autocorrect Options

Setup & Printing Issues

• Worksheet Margins
• Worksheet Orientation
• Worksheet Page Size
• Headers and Footers
• Header and Footer Fields
• Scaling Your Worksheet to Fit a Page(s)
• Printing Titles On Every Page
• Printing the Row and Column Headings
• Spell Checking
• Previewing a Worksheet
• Viewing Workbooks Side By Side
• Printing Options

Functions and Formulas
• Getting Help With Functions.
• Nested Functions.
• Consolidating Data using a 3-D Reference Sum Function.
• Mixed References within Formulas.

Time & Date Functions
• TODAY.
• NOW.
• DAY.
• MONTH.
• YEAR.

Mathematical Functions
• ROUND.
• ROUNDDOWN.
• ROUNDUP.

Logical Functions
• IF.
• AND.
• OR.

Mathematical Functions
• SUMIF.

Statistical Functions
• COUNT.
• COUNTA.
• COUNTIF.
• COUNTBLANK.
• RANK.
• TEXT FUNCTIONS
• LEFT.
• RIGHT.
• MID.
• TRIM.
• CONCATENATE.

Financial Functions
• FV.
• PV.
• NPV.
• RATE.
• PMT.

Lookup Functions
• VLOOKUP.
• HLOOKUP.

Database Functions
• DSUM.
• DMIN.
• DMAX.
• DCOUNT.
• DAVERAGE

Named Ranges
• Naming Cell Ranges.
• Removing a Named Range.
• Named Cell Ranges and Functions.

Cell Formatting
• Applying Styles to a Range.
• Conditional Formatting.
• Custom Number Formats.

Manipulating Worksheets
• Copying or Moving Worksheets
• Splitting a Window.
• Hiding Rows, Columns & Worksheets.

Templates
• Creating Excel Templates.
• Editing Excel Templates

Paste Special Options
• Using Paste Special to Add, Subtract, Multiply & Divide.
• Using Paste Special ‘Values’.
• Using Paste Special Transpose Option.

Pivot Tables
• Using a Pivot Table.
• Filtering and Sorting Data
• Grouping Data

Input Tables
• One-Input Data Tables.
• Two-Input Data Tables.

Charts
• Combined Line and Column Chart.
• Adding a Secondary Axis.
• Changing the Chart Type For a Data Series.
• Adding a Data Series to a Chart.
• Removing a Data Series from a Chart.
• Modifying the Chart Title, Legend & Data Labels.
• Chart Axis Scales.
• Inserting Images Into Chart Columns.
• Formatting the Chart Area

Hyperlinks
• Inserting a Hyperlink.
• Editing a Hyperlink
• Removing a Hyperlink

Linking & Embedding
• Linking Data within a Worksheet.
• Linking Cells between Worksheets within a Workbook.
• Linking Data between Workbooks.
• Linking Data from Excel to a Word Document.
• Linking an Excel Chart to a Word Document.
• Updating, Locking and Breaking Links.

Importing Text Files
• Importing a Delimited Text File.

Sorting and Filtering Data
• Sorting Data by Multiple Columns
• Custom Sorts
• Customized List
• AutoFilter.
• Top 10 AutoFilter.
• Advanced Filter Criteria.
• Sub-Totalling.
• Removing Subtotals.
• Expanding and Collapsing Outline Detail.

Tracking and Reviewing Changes
• Enabling or Disabling 'Track Changes'.
• Sharing, Comparing and Merging Worksheets.

Scenarios
• Scenario Manager.
• Scenario Summary Reports.

Validating
• Whole Number.
• Decimal Number.
• List.
• Date.
• Time.
• Text Length.
• Validation Input Message and Error Alert.
• Removing Data Validation.

Auditing
• Tracing Precedent Cells.
• Tracing Dependent Cells.
• Identifying Cells With Missing Dependents.
• Showing All Formulas In a Worksheet.
• Comments..

Macros
• Using Macros
• Assigning a Macro to a Button on the Quick Access Toolbar.
• Deleting Macros.

Passwords & Security Issues
• Password Protection.
• Password Protecting Cells and Worksheets.
• Hiding Formulas.
• Un-Hiding Formulas.

MICROSOFT WORD 2010 Course Outline:

The Microsoft Word 2010 Screen
• The Levels of Command Organisation
• Ribbon Tabs
• Groups
• Dialog Box Launcher

Starting to use Microsoft Word 2010
• Opening and Closing Documents
• Saving Microsoft Word Documents
• Creating a New Document
• Help
• Creating Documents using Templates

Manipulating Text
• Select, then Format
• Selecting Text
• Undo and Redo
• Manipulating Text

The Clipboard
• Using the Clipboard

Text Formatting
• Font Type & Font Size
• Bold, Italic or Underline
• Subscript and Superscript
• Case Changing
• Highlighting
• Font Colour
• Format Painter
• Removing Formatting
• Special Characters and Symbols

Paragraph Formatting
• Paragraph Marks
• Line Breaks
• Aligning Text
• Indenting Paragraphs
• Line Spacing within Paragraphs
• Spacing Above or Below Paragraphs
• Applying Bullets to a List
• Applying Numbering a List

Borders and Shading
• Modifying Borders
• Modifying Shading

Finding and Replacing Text
• Finding Text
• Replacing Text

Tabs
• Tab Stops
• Setting and Removing Tabs

Styles
• Applying Styles
• Style Sets

Page Formatting
• Page Orientation and Paper Size
• Page Size
• Page Margins
• Page Breaks
• Headers and Footers
• Page Numbering
• Header and Footer Fields
• Cover Pages
• Hyphenation

Tables
• Inserting a Table
• Navigating within a Table
• Selecting Cells, Rows, Columns or the Entire Table
• Inserting and Deleting Rows and Columns
• Modifying Column Width or Row Height
• Modifying Cell Borders
• Adding Shading to Cells
• Modifying Cell Border Width, Colour and Style

Using Graphics within Microsoft Word
• Inserting a graphic, Shapes, SmartArt & charts
• Inserting a Screen Shot

Multiple Documents
• Switching between Documents
• Tiling or Cascading Documents
• Comparing Documents Side By Side
• Copying or Moving Selected Items between Documents

Mail Merge
• Starting the Mail Merge Wizard
• Merging a Mailing List to Produce Labels

Customisation
• Customising Microsoft Word
• Setting the User Name
• Setting the Default Folder

Proofing and Printing
• Spell Checking a Document
• Adding Words to the Dictionary
• Removing a Word from the Dictionary
• Printing Options
• Selecting a Printer
• Choosing What to Print
• Setting the Number of Copies to Print
• Setting the Pages per Sheet
• Printing only Odd or Even Pages
• Previewing and Printing a Document

Compatibility Mode
• What is Compatibility Mode?
• Using the Convert Button

Paragraph Formatting
• Line Spacing Formatting Options.
• Using the Widow/Orphan Control.
• Using ‘Keep Lines Together’.
• Using the 'Keep With Next' Option.
• Using ‘Page Break Before’.
• Multilevel List Formatting.

Pictures
• Compatibility Mode & Picture Editing.
• Screen Shots
• Clipping Screen Shots.
• Picture Tools.
• Removing a Background.
• Picture Corrections
• Picture Colour
• Picture Artistic Effects
• Compressing Pictures
• Resetting Pictures
• Picture Styles
• Picture Borders
• Cropping a Picture

Sections
• Inserting 'Next Page' Section Breaks.
• Inserting 'Odd Page' Section Breaks.
• Changing the Section Break Type.
• Deleting Section Breaks.
• Page Orientation and Sections.
• Page Vertical Alignment and Sections.
• Margins and Sections.

Headers & Footers
• Applying Different Headers and Footers to Sections.
• Applying Different Headers and Footers to the First Page.
• Applying Different Headers and Footers to Odd and Even Pages.

Watermarks
• Adding a Pre-Defined Watermark.
• Adding a Custom Text Watermark.
• Removing a Watermark.
• Modifying a Text Watermark.
• Adding a Picture Watermark.

Tables
• Table Styles.
• Merging Cells within a Table.
• Splitting Cells within a Table.
• Modifying Cell Alignment.
• Modifying Cell Margins.
• Modifying Text Direction within Cells.
• Repeating the Table Heading Rows
• Controlling Row Breaking Across Pages.
• Performing a Single Column Sort.
• Multilevel Sorting.
• Converting Delimited Text to a Table.
• Converting a Table to Text.

Styles
• What are Styles?
• Applying Styles.
• Types of Styles.
• Creating a Paragraph Style.
• Creating a Character Style.
• Modifying a Style.
• Enabling Automatic Style Updating.
• Deleting a Style.

Text Wrapping
• Applying Text Wrapping
• Text Wrapping and Tables.

Columns
• Applying Column Formatting to an Entire Document.
• Applying Column Formatting to ‘Selected Text’.
• Changing the Number of Columns within a Column Layout.
• Changing Column Widths and Spacing.
• Using Pre-Set Column Formatting.
• Lines between Columns.
• Inserting Column Breaks.
• Deleting Column Breaks.

AutoCorrect
• Creating, Modifying and Deleting an Autocorrect Entry.

Building Blocks (Formerly Called AutoText)
• Creating and Inserting Building Block Items.
• Modifying a Building Block Item.
• Deleting a Building Block (AutoText) Item.

Advanced Find and Replace
• Advanced Find and Replace Options
• 'Paste Special' Options using Formatted and Unformatted Text.

Captions
• Manually adding a Caption to an Object.
• Adding and Removing Caption Labels.
• Changing the Caption Number Formatting.

Footnotes and Endnotes
• Inserting Footnotes.
• Editing and Formatting Footnotes.
• Inserting Endnotes.
• Editing and Formatting Endnotes.
• Converting Footnotes to Endnotes.
• Converting Endnotes to Footnotes.

Bookmarks and Cross-References
• Adding a Bookmark.
• Creating Cross-References
• Deleting Cross-References.
• Deleting a Bookmark.

 Master Documents

• Creating a New Master Document
• Inserting Sub-Documents
• Unlinking or Removing a Sub-Document
• Using Text Outline Options.

Tracking and Comments
• Tracking Changes.
• Accepting or Rejecting Changes.
• Comments.

Comparing and Combining Documents
• Comparing Documents.
• Combining Revisions.

Tables of Contents & Indexes
• Creating a Table of Contents.
• Updating a Table of Contents.
• Creating and Updating a Table of Figures.
• Marking an Index Entry.
• Marking an Index Sub-Entry.
• Compiling and Updating an Index.

Linking & Embedding
• Linking Data from a Document.
• Updating a Linked Document.
• Breaking the Link to a Document.
• Embedding Data Into a Document
• Editing Embedded Data.
• Deleting Embedded Data.

Hyperlinks
• Inserting Hyperlinks.
• Editing a Hyperlink.
• Removing a Hyperlink.

Macros
• Inserting Macros
• Assigning a Macro to a Button on a Toolbar.

Fields
• Inserting Fields
• Inserting Fill-In Fields.
• Deleting Fields.
• Updating, Locking and Unlocking Fields.
• Using the Sum Formula within a Table.

Forms
• Text Fields.
• Check Boxes.
• Drop-Down Menus.
• Protecting a Form.
• Password Protecting a Form.

Templates
• Creating and using a Word Template.
• Modifying a Word Template.

Mail Merging
• Editing and Sorting a Mail Merge List.
• Ask Fields and Bookmarks.
• Inserting Ask Fields.
• Inserting If…Then…Else… Fields.
• Using Merge Criteria in a Mail Merge.

Passwords & Editing Restrictions
• Adding and removing passwords .
• Allowing Only Tracked Changes or Comments.
• Marking a document as a Final Version.

MICROSOFT POWERPOINT 2010 Course Outline:

  Using PowerPoint 2010
• Navigating between Slides
• Zoom Tool
• PowerPoint Views
• Help
• Saving a Presentation
• Closing a Presentation
• Closing PowerPoint
• Using Multiple Presentations

Creating a Presentation
• Creating a New Presentation
• Inserting a New Slide
• Undo and Redo

Manipulating Slides
• Inserting Slides
• Modifying the Slide Layout
• Changing the Background Colour

Themes
• Applying a Theme to a Presentation
• Modifying the Theme Colours
• Modifying the Theme Fonts

Text Boxes (Placeholders)
• Editing Text Boxes (Placeholders)
• Resizing a Text Box (Placeholder)
• Moving a Text Box (Placeholder)

Manipulating Text
• Selecting Text
• Copying & Moving Text
• Deleting Text
• Using Find & Replace

Font Formatting
• Font Type
• Font Size
• Font Size
• Bold, Italic or Underline
• Strikethrough
• Shadow Effects
• Character Spacing
• Changing Case
• Font Colour
• Clearing All Text Formatting

Paragraph Formatting
• Text Alignment
• Columns
• Modifying Bullet Point Formatting
• Changing the List Level
• Indenting Bulleted Text
• Line Spacing
• Paragraph Spacing
• Outline View
• Presenter Notes
• Text Direction
• AutoFit
• Format Painter

Tables
• Table Selection Techniques
• Creating a Table
• Applying a Style to a Table
• Cell Background Shading
• Table Effects
• Adding 'Quick Styles' to Selected Text
• Applying Borders to Cells
• Deleting Rows or Columns
• Inserting Rows or Columns
• Modifying Column Width and Row Height
• Distributing Rows and Columns

Graphics
• Manipulating Illustration
• Pictures
• Clip Art
• Shapes
• Inserting Text Into a Shape
• Inserting Perfect Circles / Squares
• Inserting a Line
• Inserting a Free Drawn Line
• Inserting an Arrow
• Inserting a Text Box
• Inserting SmartArt

Manipulating Graphics
• Shape Background Fill Colour Style
• Shape Line Weight and Style
• Shape Line Colour
• Shadow effects
• Modifying Arrow Lines
• Rotating or Flipping
• Layering Illustrations to the Front or Back
• Aligning Graphics
• Grouping and Ungrouping Objects

Charts
• Inserting Charts
• Changing the Chart Type
• Changing the Background Colour In the Chart
• Changing the Column, Bar, Line or Pie Slice Colours In the Chart
• Chart Title Manipulation
• Adding Data Labels to a Chart

Organisation Charts
• Creating an Organisation Chart
• Adding Labels to an Organisation Chart
• Adding a Co-Worker
• Adding a Subordinates
• Adding a Manager
• Changing the Hierarchical Structure

Manipulating Slides
• Copying & Moving Slides
• Deleting Slides

Slide Masters
• Inserting a Picture into a Master Slide
• Removing a Graphic from a Master Slide
• Creating a Footer
• Automatic Slide Numbering
• Inserting Dates Into the Footer

Slide Shows
• Running a Slide Show
• Transition Effects
• Animation Effects
• Hiding Slides

Printing and Proofing
• Spell-Checking
• Portrait or Landscape Orientation
• Selecting Your Output Format
• Printing Options
• Selecting a Different Printer
• Printing Selected Slides
• Number of Slides Per Page to Be Printed

Customising and Compatibility Issues
• Modifying PowerPoint Options
• Compatibility Issues When Saving a Presentation
• Saving a Presentation As a Template
• Customised Templates

PowerPoint Sections
• Creating & Renaming Sections
• Collapsing & Expanding Sections
• Reordering Sections
• Removing Sections

Slide Masters
• Inserting Slide Masters
• Editing a Customised Slide Master
• Customised Slide Masters

Themes
• Applying Themes
• Modifying a Themes
• Setting the Default Theme
• Deleting a Theme
• Modifying a Template

Formatting Pictures & Images
• Removing a Picture Background
• Colouring Pictures
• Artistic Effects
• Picture Styles
• Picture Brightness and Contrast
• Compressing Pictures
• Resetting a Picture
• SmartArt & Pictures

Manipulating Graphics
• Ruler and Gridlines
• Snapping to the Grid and Grid Spacing
• Positioning a Graphic Relative to the Top-Left Corner of a Slide
• Distributing Graphics on a slide
• Cropping a Graphic
• Re-Scaling Pictures
• Background Graphics

Formatting AutoShapes
• AutoShape Background Fill Effects
• AutoShape Transparency Effects
• AutoShape Shape Effects
• AutoShapes Format Painter
• AutoShape Defaults 

Diagrams
• Organisation Chart
• Cycle Diagram
• Pyramid Diagram
• Flowchart

Charts
• Chart Title, Legend, Labels & Axes Labels
• Changing Chart Type
• Chart Gap and Overlaps
• Using Images In Chart Columns / Rows
• Axis Scales

Video and Audio
• Video Brightness and Contrast
• Re-Colouring a Video
• Adding a Poster Frame Image to a Video
• Resetting a Video
• Applying a Video Style
• Playing a Video In a Shape
• Video Special Effects
• Trimming Video
• Video Looping
• Using Audio

Animation
• Animation Effects
• Animation Triggers
• Animation Painter
• Custom Animation Effects
• Custom Animation Sequence
• Animating Chart Columns By Series
• Animating, or Not Animating, the Chart Grid and Legend
• Animating SmartArt

Linking and Embedding
• Action Buttons
• Linking and Updating Objects
• Breaking a Link
• Inserting a Link to a Graphics File
• Embedding Data Into a slide
• Editing or Deleting Embedded Data

Hyperlinks
• Creating and Editing Hyperlinks

Merging, Comparing & Exporting
• Merging all the slides from one Presentation Into another Presentation
• Comparing Presentations
• Saving a Slide as a graphics File
• Using the Screen Shot Feature

Slide Shows
• Custom Slide Shows
• Editing a Custom Slide Show
• Slide Show Transitions and Timings
• Slide Show Looping
• Setting a Slide Show to use Timings
• Enabling or Disabling Slide Show Animations
• Controlling a Slide Show

Sharing Presentations
• Marking As Final
• Permissions – Encrypting With a Password
• Converting a Presentation to a Video
• Packing For a CD
• Saving As a PDF Format

Presentation Design & Compatibility
• Planning Your Presentation
• The Accessibility Checker
• The Document Inspector
• The Compatibility Checker