PS Training Ltd

Printer-friendly document

Course Booking and enquiries: 01352 810443
enquiries@pstraining.co.uk

Prerequisites:
Existing users of Microsoft Office XP or 2003, this course covers the new features available in Microsoft Office 2010.

Duration:
A Half Day course

General Microsoft Office 2010 New Features

• The new File Menu
• Customising the Quick Access Toolbar
• Customising the Ribbon (creating tabs, groups and commands)
• Contextual tabs (Task specific tabs)
• Dialog Box Launchers
• Shortcut Keys
• The Zoom Slider
• The Mini Toolbar
• Print Preview and Printing
• Saving and Compatibility mode
• Saving a file in pdf format
• Closing files
• Opening an existing file
• Paste with Live Preview
• Inserting Screenshots
• Zoom control & document views

Microsoft Excel 2010

• Creating a new workbook
• Creating Worksheets
• Inserting Basic Functions using the Function Library
• Explanation of Function tips
• Resizing the Formula Bar/Name Definition box
• Using Auto complete to create Formulas
• Conditional Formatting
• Removing duplicate values
• Improved Sorting and Filtering
• Using Sparklines

Microsoft Word 2010

• Creating a new document
• The Document Navigation Pane
• Formatting (Basic, Paragraph)
• Page Numbering
• Tables and Table Styles
• Page Setup
• Working with Templates
• Headers and footers

Microsoft PowerPoint 2010

• Creating a new presentation
• Organise your slides into logical sections
• Apply artistic textures to your pictures
• Remove the Background from a picture
• Crop pictures with more precision
• Creating a Photo Album