Office 2010 - Office 2010 - Excel & PowerPoint new features

OFF-10-02

Duration

Half day

Who should attend?

People who have a good basic knowledge of previous versions of Microsoft Excel and PowerPoint and are upgrading to Microsoft Office 2010

Pre-requisites

A good knowledge of Office 2003

Objectives

This session covers the new features/key differences in Excel 2010 and PowerPoint 2010

Course Content

Excel 2010 new features

Decreased size for files; Sort levels; Formulae, formula AutoComplete, formula nesting; Headers & footers; Review ribbon; Page breaks; Freeze panes; Cell styles; Autofilter; Enhancements to charts, tables & pivots

Sparklines; Conditional formatting data bars and icons; Filter search box; Pivot table slices

PowerPoint 2010 new features

Corporate templates; Rio Tinto themes, colours and fonts; Custom layouts; SmartArt; Tables and charts; Mark as final; Review ribbon; Presenter view

Sections; Side by side presentations; Merge and compare; Video: embed, convert presentation to video; Picture editing