Course: Microsoft Office Training

What is MCSA: Office 365?

Demonstrate your skills in transitioning to and administering cloud-hosted business applications with Office 365.

Earning an MCSA: Office 365 certification qualifies you for a position as a software as a service (SaaS) administrator or cloud applications administrator focused on managing Office 365 business productivity products like Exchange, SharePoint and Lync.

Key Areas

There are two areas that are covered in the Office 365:

  • Intuitive and rewarding online training resources

    • Optional Training: 70-346
    • Required Training: 70-346
  • Official Microsoft Exams

    • Optional Training: 70-346
    • Required Training: 70-347

Who should take this exam?

This exam is designed for IT professionals who take part in evaluating, planning, deploying and operating the Office 365 services, including its dependencies, requirements and supporting technologies. They should have experience with the Office 365 Admin Centre and an understanding of Exchange Online, Lync Online, SharePoint Online, Office 365 ProPlus and Azure Active Directory. This includes experience with service descriptions, configuration options, and integrating services with existing identity management and on-premises infrastructure to support the business requirements of an organisation.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
Exam 70-346

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area in the exam. The higher the percentage, the more questions you are likely to see on that content area in the exam.

*Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Provision Office 365 (15-20%)

Provision Tenants

  • Configure the tenant name, tenant region, global administrator; manage tenant subscriptions; and manage the licensing model

Add and configure custom domains

  • Specify domain name, confirm ownership, specify domain purpose, and move ownership of DNS to Office 365

Plan a pilot

  • Designate pilot users, identify workloads that don’t require migration, run the Office 365 on-ramp readiness tool, create a test plan or use case, and connect existing email accounts for pilot users, service descriptions

For more information, contact one of our course advisors

Plan and implement networking and security in Office 365 (15-20%)

Configure DNS records for services


  • Creating DNS records for Exchange, Lync and SharePoint

Enable client connectivity to Office 365


  • Configure proxy server to allow anonymous access to Office 365 URLs, configure firewalls for
    outbound port access to Office 365, recommend bandwidth, Internet connectivity for clients,
    and deploy desktop setup for previous versions of Office clients

Administer rights management (RM)


  • Activate rights management, Office integration with rights management, assign roles for
    Microsoft Azure Active Directory RM and enable recovery of protected document

Manage administrator roles in Office 365


  • Permission model, create or revoke assignment of administrative roles or the administrative model,
    determine and assign global administrator, billing administrator and user administrator, delegated
    administrator, and control password resets

For more information, contact one of our course advisors

Manage cloud identities (15-20%)

Configure password management

  • Expiry policy, password complexity, password resets and Administration Centre

Manage user and security groups

  • Bulk import, Azure Active Directory Graph API, soft delete, Administration Centre and multi-factor authentication

Manage cloud identities with Windows PowerShell

  • Configure passwords to never expire, bulk update of user properties, bulk user creation, Azure Active Directory cmdlets, bulk user licence management and hard delete users

For more information, contact one of our course advisors

Implement and manage identities by using DirSync (15-20%)

Prepare on-premises Active Directory for DirSync

  • Plan for non-routable domain names, clean up existing objects, plan for filtering Active Directory, and support for multiple forests

Set up DirSync [WAAD sync tool]

  • Soft match filtering and identify synchronised attributes, password sync, and installation requirements

Manage Active Directory users and groups with DirSync in place

  • Delete, create, modify, and schedule and force synchronisation

For more information, contact one of our course advisors

Implement and manage federated identities (single sign-on [SSO]) (15-20%)

Plan requirements for Active Directory Federation Services (AD FS)

  • Namespaces and certificates, plan AD FS internal topologies and dependencies, plan AD FS proxy topologies, network requirements, multi-factor authentication, and access filtering using claims rules

Install and manage AD FS servers

  • Create AD FS service accounts, configure farm or stand-alone settings, add additional servers, convert from standard to federated domain, and manage certificate life cycle

Install and manage AD FS proxy servers

  • Set up perimeter network name resolution, install required Windows roles and features, set up certificates, configure AD FS proxy settings, and set custom proxy forms login page

For more information, contact one of our course advisors

Monitor and troubleshoot Office 365 availability and usage (15-20%)

Analyse reports

  • Service reports, mail protection reports, auditing log and portal email hygiene reports

Monitor service health

  • RSS feed, service health dashboard (including awareness of planned maintenance, service updates and historical data), Office 365 Management Pack for System Centre Operations Manager, and Windows PowerShell cmdlets

Isolate service interruption

  • Create a service request, Microsoft Remote Connectivity Analyser (RCA), Microsoft Online Services Diagnostics and Logging (MOSDAL) support toolkit, Transport Reliability IP Probe (TRIPP), Microsoft Connectivity Analyser tool, and hybrid free/busy troubleshooter

For more information, contact one of our course advisors

Exam 70-347

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area in the exam. The higher the percentage, the more questions you are likely to see on that content area in the exam.

*Please note that the questions may test on, but will not be limited to, the topics described in the bulleted text.

Manage clients and end-user devices (20-25%)

Manage user-driven client deployments

  • Restrict self-provisioning of Office 365 ProPlus, Windows Store Apps and Mobile Apps, activation/revoke activation, and Office for Mac

Manage IT deployments of Office 365 ProPlus

  • Manage deployment, manage streaming updates, use the Office deployment tool and customise deployment

Set up telemetry and reporting

  • Enable telemetry through Group Policy, set up telemetry service, report user issues and deploy agent

Plan for Office clients

  • Outlook, Lync client, Office on Demand, Office Web Apps, and click-to-run versus MSI

For more information, contact one of our course advisors

Provision SharePoint Online site collections (20-25%)

Configure external user sharing

  • Configure the tenant name, tenant region, global administrator; manage tenant subscriptions; and manage the licensing model

Create SharePoint site collection

  • Set SharePoint Online site collection administrator, set resource quota and warning level, configure public website, set storage quota for site collection, and configure name and URL of site collection

Plan a collaboration solution

  • Yammer versus newsfeeds, co authoring, Project Online, access files across multiple client devices (for example, migrate files to OneDrive for Business), Excel services, Visio services, App Store and the need for enterprise eDiscovery

For more information, contact one of our course advisors

Configure Exchange Online and Lync Online for end users (20-25%)

Configure additional email addresses for users

  • Change style/reply to address, bulk add/remove for new domain, manage secondary email aliases and SIP addresses

Create and manage external contacts, resources and groups

  • Create and manage resource mailboxes, create shared mailboxes, create external contacts, assign additional email address to contacts, create and manage distribution lists and members, and delegate permissions

Configure personal archive policies

  • Enable personal archives for mailboxes, create custom retention policy, create retention tags, apply retention policy to mailboxes, and review and modify default retention policy

Configure Lync end-user communication settings

  • Turn off non-archived features for compliance, configure presence, available services, and configure per-user external communication

For more information, contact one of our course advisors

Plan for Exchange Online and Lync Online (20-25%)

Manage anti-malware and anti-spam policies

  • Release quarantine, configure SPAM confidence level, configure white and black lists, and configure notifications

Recommend a mailbox migration strategy

  • Staged, cutover, hybrid and IMAP

Plan for Exchange Online

  • Plan client requirements for archive, manage eDiscovery, enable Legal hold, configure OWA access, and configure ActiveSync

Manage Lync global external communications settings

  • Enable external access, manage domains, manage public IM connectivity, customise meeting invitations, and disable push notification service

For more information, contact one of our course advisors

About Excel Training

This Microsoft Excel training package teaches users how to confidently approach Microsoft Excel, enabling proficiency in the program through an easy to digest online learning format. Nine modules are broken up into manageable topics that cover the basic, intermediate and advanced functions of Excel; this includes essentials such as formatting content, presenting data or modifying page setups.

Each module is followed with an online test, to ensure you picked up the topics in each module. Friendly and helpful tutors will ensure that you will always have a point of contact should you get stuck on any particular topic. With 18-months unlimited access to course content users can comfortably learn at their own pace, allowing a stress-free learning experience. This can be a stepping stone for a MOS certification and builds towards official Microsoft exams.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Nine comprehensive modules, with online testing.
  • Introductory, intermediate and advanced levels of Excel, teaching you how to use the Microsoft software in a business environment. This includes sections on PivotTables and VLookup
  • Knowledge to increase productivity and create high quality Excel workbooks and spreadsheets
  • Business standard skills in Microsoft Excel
  • 18 months unlimited access to course content
  • Tutor and technical support available via a local US phone number and email
  • Completion certificate, which will show employers that you are proficient with Excel
  • Study anytime, anywhere in a world for a flexible learning experience
Excel 2013 Breakdown

Click below to expand the areas and see more information:

Create and manage worksheets and workbooks
  • 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
  • Navigate through worksheets and workbooks
    • Searching for data within a workbook; inserting hyperlinks; changing worksheet order; using Go To; using Name Box
  • Format worksheets and workbooks
    • Changing worksheet tab colour; 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
  • Customise options and views for worksheets and workbooks
    • Hiding worksheets; hiding columns and rows; customising the Quick Access toolbar; customising 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
  • 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

For more information, contact one of our course advisors

Create cells and ranges
  • 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
  • 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
  • Order and group cells and ranges
    • Applying conditional formatting;inserting sparklines; transposing columns and rows; creating named ranges; creating outline; collapsinggroups of data in outlines; inserting subtotals

For more information, contact one of our course advisors

Create tables
  • Create a table
    • Moving between tables and ranges; adding and removing cells within tables; defining titles
  • Modify a table
    • Applying styles to tables; banding rows and columns; inserting total rows; removing styles from tables
  • Filtering and sort a table
    • Filtering records; sorting data on multiple columns; changing sort order; removing duplicates

For more information, contact one of our course advisors

Apply formulas and functions
  • Utilise cell ranges and references in formulas and functions
    • Utilising references (relative, mixed, absolute); defining order of operations; referencing cell ranges in formulas
  • Summarise data with functions
    • Utilising the SUM function; utilising the MIN and MAX functions; utilising the COUNT function; utilising the AVERAGE function
  • Utilise conditional logic in functions
    • Utilising the SUMIF function; utilising the AVERAGEIF function; utilising the COUNTIF function
  • Format and modify text with functions
    • Utilising the RIGHT, LEFT and MID functions; utilising the TRIM function; utilising the UPPER and LOWER functions; utilising the CONCATENATE function

For more information, contact one of our course advisors

Create charts and objects
  • Create a chart
    • Creating charts and graphs; adding additional data series; switching between rows and columns in source data; using Quick Analysis
  • Format a chart
    • Adding legends; resizing charts and graphs; modifying chart and graph parameters; applying chart layouts and styles; positioning charts and graphs
  • Insert and format an object
    • Inserting text boxes; inserting SmartArt; inserting images; adding borders to objects; adding styles and effects to objects; changing object colours; modifying object properties; positioning objects

For more information, contact one of our course advisors

Excel Package Offer

Click below to expand the areas and see more information:

Excel 2013 & Excel Expert 2013
  • If you are looking to purchase the Excel 2013 and the Excel expert 2013
  • Click the buy button below to purchase our Excel package

    • Buy Now£349.98 + VAT

For more information, contact one of our course advisors

What is MOS Training?

Microsoft Office is a suite of products developed by Microsoft that includes Microsoft Word, Excel, Access, Publisher, PowerPoint, Outlook and SharePoint. Each programme serves a different purpose and is compatible with other programmes included in the package. The suite of programmes is compatible with both the Windows and Macintosh operating system and is the most common form of software used in the western world.

Take your understanding of Microsoft Office to the next level – excel in your understanding, knowledge and marketable skillset within one of the most in demand software suite in the working world.

Whether you are a low level data entry clerk or a high powered CEO our MOS training programme is essential for anyone hoping to survive in an office environment. The MOS builds from a foundation level and will develop all learners to becoming advanced Office users.

Microsoft offer varying levels of expertise with their powerful Office suite and learners can gain qualifications as a Microsoft Office Specialist, Microsoft Office Specialist Expert, or a Microsoft Office Specialist Master.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
MOS Breakdown

Click below to expand the areas and see more information:

Microsoft Office Specialist: Microsoft Office 2013

Office 2013 combines cloud and web technologies to extend the way you create and consume information and introduces a new cloud app model for you to build secure and flexible apps—all discoverable from the familiar Office interface.

  • MOS: Microsoft Office Word 2013 - Exam: 418
  • MOS: Microsoft Office Excel 2013 - Exam: 420
  • MOS: Microsoft Office PowerPoint 2013 - Exam: 422
  • MOS: Microsoft Office Outlook 2013 - Exam: 423
  • MOS: Microsoft Office Access 2013 - Exam: 424
  • MOS: Microsoft SharePoint 2013 - Exam: 419
  • MOS: Microsoft Office OneNote 2013 (Introductory module available) - Exam: 421

For more information, contact one of our course advisors

Microsoft Office Specialist: Microsoft Office 2010
  • MOS: Word 2010 - Exam: 418
  • MOS: Excel 2010 - Exam: 420
  • MOS: PowerPoint 2010 - Exam: 422
  • MOS: Outlook 2010 - Exam: 423
  • MOS: Access 2010 - Exam: 424
  • MOS: SharePoint 2010 - Exam: 419
  • MOS: OneNote 2010 - Exam: 421

For more information, contact one of our course advisors

Job Role

Having MOS training on your CV will unlock a large number of career opportunities within office environments, with those holding a MOS certification earning an average of £29,000 (Source: IT Jobs Watch March 2015.)

The roles that you will be qualified for are as follows:

  • Office Administrator
  • Business Administrator
  • Personal Assistant
  • Receptionist
  • Office Clerk

For more information, contact one of our course advisors

What is MOS Expert Training?

Microsoft Office is a suite of products developed by Microsoft that includes Microsoft Word, Excel, Access, Publisher, PowerPoint, Outlook and SharePoint. Each programme serves a different purpose and is compatible with other programmes included in the package. The suite of programmes is compatible with both the Windows and Macintosh operating system and is the most common form of software used in the western world.

Take your understanding of Microsoft Office to the next level – excel in your understanding, knowledge and marketable skillset within one of the most in demand software suite in the working world.

Whether you are a low level data entry clerk or a high powered CEO our MOS training programme is essential for anyone hoping to survive in an office environment. The MOS builds from a foundation level and will develop all learners to becoming advanced Office users.

Microsoft offer varying levels of expertise with their powerful Office suite and learners can gain qualifications as a Microsoft Office Specialist, Microsoft Office Specialist Expert, or a Microsoft Office Specialist Master.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
MOS Extra Breakdown

Click below to expand the areas and see more information:

Microsoft Excel 2013
  • Introduction to Microsoft Excel
  • Working with Worksheets and Workbooks
  • Formatting Options in Excel
  • Navigation through Workbooks
  • Tables, Sparklines and Conditional Formatting
  • Using Formulas in Excel 2013
  • Using Charts in Excel 2013
  • Insert and Manage Objects in Excel 2013
  • Modifying the Page Setup. Printing Workbooks and Recording Macros
  • Pivot Tables and VLookup

For more information, contact one of our course advisors

Microsoft Word 2013
  • How to create Documents
  • How to Customise Word 2013
  • How to format documents in Word 2013
  • How to format documents and modify the page setup
  • Using Tables in Word
  • Formatting Documents in Word 2013
  • Working with images, macros and themes

For more information, contact one of our course advisors

Microsoft Access 2013
  • Create and Manage a Database
  • Built Tables
  • Create Queries
  • Working with Forms
  • Working with Reports

For more information, contact one of our course advisors

Microsoft PowerPoint 2013
  • Create & Manage Presentations
  • Built Tables
  • Create Queries
  • Working with Forms
  • Working with Reports

For more information, contact one of our course advisors

Microsoft Outlook 2013
  • Introduction to Microsoft Outlook 2013
  • Formatting Messages
  • Managing Messages
  • Formatting Messages, Managing Attachments, and Configuring Automatic Replies
  • Scheduling & Managing Appointments
  • Creating Meetings & Managing Availability
  • Tasks, Notes, Journal, and Contacts
  • Contact Groups, Multiple Accounts, and Printing

For more information, contact one of our course advisors

Microsoft SharePoint 2013
  • Introducing SharePoint
  • Lists, Libraries and Alerts
  • Mobile Sites and Document Management
  • Versioning and Workflows
  • Documents, Document Sets and Announcements
  • Manage SharePoint Sites
  • Content in SharePoint
  • Content & Access in SharePoint
  • Participate In User Communities

For more information, contact one of our course advisors

Microsoft OneNote 2013
  • Introduction to OneNote
  • Getting To Know OneNote
  • Inserting Content To OneNote
  • Sharing Notebooks
  • Top Tips For OneNote

For more information, contact one of our course advisors

What is MOS Expert Training?

Microsoft Office is a suite of products developed by Microsoft that includes Microsoft Word, Excel, Access, Publisher, PowerPoint, Outlook and SharePoint. Each programme serves a different purpose and is compatible with other programmes included in the package. The suite of programmes is compatible with both the Windows and Macintosh operating system and is the most common form of software used in the western world.

Take your understanding of Microsoft Office to the next level – excel in your understanding, knowledge and marketable skillset within one of the most in demand software suite in the working world.

Whether you are a low level data entry clerk or a high powered CEO our MOS training programme is essential for anyone hoping to survive in an office environment. The MOS builds from a foundation level and will develop all learners to becoming advanced Office users.

Microsoft offer varying levels of expertise with their powerful Office suite and learners can gain qualifications as a Microsoft Office Specialist, Microsoft Office Specialist Expert, or a Microsoft Office Specialist Master.

Training Solution Breakdown:

  • Intuitive and rewarding online training resources
  • Official Microsoft Exams
  • Comprehensive Freephone or email support
  • 24/7 access to training materials
  • Study anytime, anywhere in a world for a flexible learning experience
  • Full mock examinations to fully prepare you for any final exam
  • 12 months (one year) unrestricted access
  • Access to online or classroom training options
  • Progress reviews & comprehensive assessments to ensure efficient understanding of course content
  • Career advice and CV support once training has been completed
MOS Expert Breakdown

Click below to expand the areas and see more information:

Microsoft Office 2013 Expert Certification

Office 2013 combines cloud and web technologies to extend the way you create and consume information, and introduces a new cloud app model for you to build secure and flexible apps—all discoverable from the familiar Office interface.
To earn a Microsoft Office 2013 Expert certification, you must pass both of the MOS Expert required exams listed:

  • MOS: Microsoft Office Word Expert (2013) - Exam: 425 & 426
  • MOS: Microsoft Office Excel Expert (2013) - Exam: 427 & 428

For more information, contact one of our course advisors

Microsoft Office 2010 Expert Certification

To earn the Microsoft Office 2010 Expert certification, you must pass one of the following MOS Expert exams:

  • MOS: Microsoft Office Word Expert (2013) - Exam: 887
  • MOS: Microsoft Office Excel Expert (2013) - Exam: 888

For more information, contact one of our course advisors

Job Role

Having MOS training on your CV will unlock a large number of career opportunities within office environments, with those holding a MOS certification earning an average of £29,000 (Source: IT Jobs Watch March 2015)

The roles that you will be qualified for are as follows:

  • Office Administrator
  • Business Administrator
  • Personal Assistant
  • Receptionist
  • Office Clerk

For more information, contact one of our course advisors

© 2017 titanium.training Privacy Terms

MENU