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