Microsoft Office 2010 Online Courses

Click the links below for more information about each course.

Access 2010
Excel 2010
Outlook 2010
PowerPoint 2010
Word 2010

Book a course using the online booking form.

The Office 2007 & 2010 Online courses are accessible via MyUni. Once enrolled, the course will appear in the "MyUni Courses" section of your MyUni home page.

Costs and Access

The courses are free for staff and students of the University. The licensing for online courses is being funded by Technology Services. Our licensing restricts us to 1,000 concurrent users. To enable as many people as possible to use the online courses, you will be restricted to enrolling in a maximum of 2 courses and each enrolment will last for 3 weeks after which time you can then enrol in another course. If you were unable to complete a course during the 3 weeks you can re-enrol after this period.

Please contact the Training Team if you have any questions about the tutorials or if you have any special training needs.

Online Course	Level 1	Level 2	Level 3
Access 2010	Getting started with Access databases Building the structure of a database Managing data in a table Querying a database Designing forms Generating reports	Controlling data entry Joining tables Creating flexible queries Improving forms Customising reports Sharing Data Across Applications	Structuring existing data Writing advanced queries Simplifying tasks with macros Creating effective reports Maintaining an Access database
Excel 2010	Getting started with Excel Performing calculations in an Excel worksheet Modifying a worksheet Modifying the appearance of a worksheet Managing an Excel workbook Printing Excel workbooks	Calculating data with advanced formulas Organising worksheet and table data Presenting data using charts Analysing data using PivotTables, slicers, and PivotCharts Inserting graphic objects Customising and enhancing the Excel environment	Streamlining workflow Collaborating with other users Auditing worksheets Analysing data Working with multiple workbooks Importing and exporting data Integrating Excel data with the web Structuring workbooks in XML
Outlook 2010	Getting started with Outlook Composing messages Organising messages Managing contacts Scheduling appointments Managing meetings in Outlook Managing tasks and notes	Customising message options Organizing and locating messages Setting calendar options Tracking activities using the journal Managing tasks Sharing folder information Customizing the Outlook environment	Personalizing your email Organising Outlook items Managing Outlook data files Managing contacts and contact information Saving and archiving email Creating a custom Outlook form Working offline and remotely
PowerPoint 2010	Getting started with PowerPoint Creating a basic presentation Formatting text on slides Adding graphical objects to a presentation Working with tables Working with charts Preparing to deliver a presentation	Customising the PowerPoint environment Customizing a design template Adding SmartArt graphics to a presentation Adding special effects to a presentation Customising a slide show Collaborating on a presentation Securing and distributing a presentation	Not applicable
Word 2010	Getting started with Word 2010 Editing text in a Word document Modifying the appearance of text in a Word document Inserting special characters and graphical objects Organizing data in tables Proofing a Word document Controlling the appearance of pages in a Word document Printing Word documents	Managing lists Customising tables and charts Creating customised formats with styles and themes Modifying pictures Creating customised graphic elements Inserting content using Quick Parts Controlling text flow Using templates to automate document creation Automating the mail merge Using macros to automate tasks	Using Word with other programs Collaborating on documents Managing document versions Adding reference marks and notes Simplifying the use of long documents Securing a document Creating forms