Microsoft Office 2010 – (MOS Specialist) – Exam & Certification

Description

• Professionals who need to learn how to be more productive with all five applications that make up Office 2010.
• Employees who want to deepen their knowledge of the Microsoft Office 2010 suite of applications.
• Workers and individuals who want to earn the world-famous Microsoft Office Specialist qualification.
• Employees who need to earn an industry-recognised qualification that demonstrates their advanced skills in Microsoft Office.
• Individuals who would like to build up their skills for work or home.

• Building and using templates and the Styles function to streamline document creation.
• Creating, modifying and sorting tables and columns.
• Using page headers and footers.
• Inserting graphics, symbols and charts.
• Using the Track Changes tools to audit changes made during editing.
• Using Mail Merge tools to create a set of individualised documents (such as addressed letters) in a single file, and repeating the process to print labels and envelopes.
• Utilising academic tools to implement referencing, footnotes and indexes.
• Protecting documents from unauthorised access with encryption and passwords.
• Working with multiple document formats, including PDF files.
• Organising long documents using outline view and inbuilt heading tools.
• Creating forms to collect data.
• Programming advanced functions with macros and XML.

• Create and using a Sparkline to analyse data trends.
• Filtering data to focus only on the information that matters.
• Autosizing columns to fit data and improve visibility.
• Editing and auditing formulae to ensure they continue to generate the required calculations correctly.
• Freezing panes to help better navigate large spreadsheets.
• Using Excel spreadsheet data to create charts.
• Moving and copying cells between sheets.
• Using the VLOOKUP function to locate key data quickly.
• Using Paste Special (Transpose Values) to automate data copying.
• Working with XML Data for use in other applications.
• Mark the Workbook as Final and Read Only to prevent further editing.
• Deleting duplicate records to maintain data integrity.

• How to read, write, edit and send emails.
• How to use address lists to choose message recipients, and mail folders to file emails.
• How to personalise messages with a signature, adding attachments and printing mail.
• Creating, using, sorting and categorising contacts in the Outlook address book.
• Working with rules and junk mail folders to streamline and simplify message management.
• Sending automatic replies, like out of office notices, or requesting read receipts to further simplify messaging.
• Working with the calendar to plan and arrange appointments, and use the address book to inform invitees and confirm attendance.
• Using Notes and Tasks to stay on top of other non-mail related jobs.
• Using the Outlook Journal to track activities and workload.
• Using data import and export functions to back up important information or transfer data between computers.
• How to use personal and public files to share messages and information with other Outlook users.

• Working with text boxes, and formatting text to improve slide appearance.
• Using shapes, object snapping and WordArt Styles to add visual variety.
• Moving and copying slides, or creating slide templates to speed up the creation process.
• Using tables to display data – including tables from other applications like Excel.
• Adding formatted charts to display data visually.
• Using video clips and animated pictures to create additional visual interest.
• Proofing and autocorrection tools to prevent spelling mistakes being left in the final presentation.
• Using themes, format editing and sections to create a consistent “look” for a presentation.
• Applying slide transitions, animation effects and object actions to further improve appearance of the slideshow as a whole.
• Building a slide show and editing the timing to fit with a script and time constraints of the presentation.
• Adding speaker’s notes and comments to the presentation to assist with delivery.

• Understanding table creation and design.
• Finding, editing, sorting and filtering data to highlight key information.
• Building table relationships and enforcing referential integrity to keep data “clean”.
• A basic introduction to functions and using the formula creator.
• Using aggregate functions and totals to simplify calculations.
• Building forms using the forms wizard to simplify data collection and display.
• Using form controls to create a true application interface for the database.
• Building reports, and using calculations and graphics to improve the appearance of data.
• Building macros and assigning actions to form buttons, increasing the functionality of database applications.
• Importing and exporting data.
• Using the SQL language to manipulate data in the database directly.

• The skills and experience required to be more efficient when using Office 2010 to create documents, capture and manipulate numerical data, manage communications, build presentations and analyse datasets.
• Full preparation for the bundled Microsoft Office Specialist (MOS) exam.
• A marked boost in productivity, allowing Office 2010 users to spend more time on other tasks that generate profit for their employer.
• An in-demand skill set that will help learners perform better at work.
• An in-depth understanding of Office 2010 that can be shared with colleagues to help them be more productive too.

• Microsoft Access 2010 Online Training
• MS Excel 2010 Online Training
• MS PowerPoint 2010 Online Training
• MS Word 2010 Online Training
• MS Outlook 2010 Online Training