Welcome to Swansea University - Library and Information Services

Free Training Resources for Office 2007

One of the first steps to take when using new/upgraded software is to look at free resources/materials available.   Listed below is a sample of useful free resources.  Visit the IT Resources tab in Blackboard for a fuller list
   

Online Microsoft Resources for all versions of MS Office

Microsoft provide many free on-line resources including: Online help, Tutorials & Demos to help users upgrade their skills.   The Help and How-to section on the left hand side of the page offers an extenstive range of facilities including:  Help, Training courses, Demos, Quizzes and Hints & Tips.  The training courses consist of lessons which cover specific topics/activity areas, last between 15 – 50 minutes and are self paced.  Within the training course content there is a Quick Reference Card which is particularly useful as it can be printed and used for future reference.  These materials are available for Office 2000, 2002, 2003 and 2007.  To access the Microsoft Office online resources/materials please click on the relevant software application link below:

PowerPoint    Excel    Word       Access    Outlook
 

Help is at hand

Microsoft has developed a Help tab (an add in) which can be downloaded from their website containing many features such as: Search, Find commands from Office 2003, Tips and Online training.  

Where have all the menu commands in Office 2003 gone?

Wondering where the menu commands in Office 2003 applications have moved to?  Microsoft have produced a series of interactive command reference guides which may save you time looking for commands which have moved location and/or no longer exist :

Access 2007

PowerPoint 2007 
Word 2007
Excel 2007

Prefer a less interactive approach? Microsoft have produced a series of command mapping reference guides:

Access 2007 Ribbon Map Powerpoint 2007 Ribbon Map Word 2007 Ribbon Map Excel 2007 Ribbon Map

    

New to MS Office 2007 - need some help getting started?

There are many visual changes between Office XP/2003 and Office 2007; most notable is the Office Fluent user interface which replaces menus, toolbars and most of the task panes that were used in the earlier versions with a Ribbon.

Whats New? A quick look

  • Help is an additional tab for staff & students using Office 2007 on campus, replacing the Get Started tab. Please follow uninstall instruction if  you have already installed Get Started tab prior to installing the Help tab.
  • Help is no longer on the main toolbar but is located in an icon in the top right hand corner of the window, although the F1 key still works.
  • The Office button - the top left corner of the window replaces the File Menu from earlier versions and contains the file operations such as; save,  print, print preview and page options.  The example below uses the Word application

    Word 2007 ribbon 

    

Beware! some issues

Don't forget not everyone has Office 2007! 

  • Compatability
     By default Office 2007 saves files in a new format that previous versions may not be able to open.  If you are unsure that person to whom you are sending/sharing a file has Office 2007 then it would better to save the files in a format that can be opened by previous versions of the software.   Within Office 2007 you can save files in  97-2003 format.  Files opened or saved in previous versions are described as being in Compatibility Mode.   If you have used features that are not supported in earlier versions of Office, the Compatibility Checker will open automatically when you try to save.
  • Don’t have Office 2007 at home?
    Install the Compatibility Pack along side of Microsoft Office XP, or Office 2003, you will be able open, edit, save, and create files using the Open XML Formats new to the Microsoft Office 2007 system.  Visit the Microsoft wesite for further information Compatability Pack.

Microsoft were offering a full copy of Microsoft Office 2007 Ultimate Edition for £38.95 which was available to end of June 2010 for university students & staff with an .ac.uk email address.  Although this offer has expired it is might be worth a visit the Microsoft site to find the best prices on offer for their products for example Software4Students.co.uk have Microsoft Office Professional Plus 2007 on offer for £49.

  

 

 

   Award for Customer Service Excellence

Valid XHTML 1.0 Transitional