MICROSOFT OFFICE 2013 WITH OFFICIAL EXAM

Special offer for anyone who is looking to take Microsoft Office training. Microsoft Excel, Word, Outlook and PowerPoint training, all in the 2013 version.

The Word 2013 section of the course will teach students all the basics of document creation and editing before moving on to advanced topics that include:

• 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.

The Excel 2013 course walks students through the process of creating basic spreadsheets and manipulating numerical data before looking at a range of advanced techniques including:

• 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.

Moving on to Outlook 2013 and corporate communications, students will learn:

• 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.

The PowerPoint section of the Microsoft Office 2013 Online Training course also begins with a number of basic concepts before launching into more advanced concepts for presentation design and delivery including:

• 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.

Anyone who is looking to perfect their skills in these popular Microsoft Office applications.

There are no prerequisites.