search our courses:
Quick Navigation
Microsoft Office 2010 Upgrade Course
Download PDF version of Microsoft Office 2010 Upgrade course outline
Overview
This course is aimed and delegates with a good overall knowledge of Microsoft Office 2003 (or previous versions). Delegates will discover what’s new in Office 2010 (Word, Excel and PowerPoint) as well as finding out where Microsoft moved everything!!!
Audience
Anyone upgrading to Microsoft Office 2010 core products.
Course Objectives
At the end of this course, delegates will be able to:
- Understand and use the new layout
- Be able to locate features you used in previous versions
Prerequisites
Delegates should be familiar with previous versions of Microsoft Office.
Course Contents (1 day)
- Office 2010 in General
- Where did it go?
- Compatibility issues
- The User Interface
- The File Tab
- The Ribbon
- Using The Quick Access Toolbar
- Using Help
- Using Live Preview & Galleries
- Customising the Status Bar
- Viewing Options & zoom
- File formats and Compatibility
- Enhanced Themes & SmartArt
- Customising the Ribbon
- Output to Adobe .PDF format
- Excel 2010
- Excel 2007 Screen & capacity - new features
- Setting Options
- Managing Rules
- Name Manager (Range names of old)
- Working with data:
- Formulae improvements & autocalc
- Using tables
- Improved sorting and filtering
- Enhancements to PivotTables
- Formatting spreadsheets:
- Live previews of formatting
- Changing Built-In Cell Styles
- Themes
- Using Data Bars, Colour Scales & icons
- Conditional formatting
- Using the enhanced drawing tools:
- Changes to creating Charts
- Sparklines
- Printing & page layout views
- Add-ins – Solver and extra Formulas
- Word 2010
- Formatting documents:
- Applying quick styles to
paragraphs and tables - Bullets & Numbers
- Quick Parts
- Creating cover pages
- Changes to headers and footers
- Applying quick styles to
- Using new content features:
- Creating cover pages
- Using building blocks
- The Preview Pane
- Inserting Screenshots
- Using images and artistic effects
- Office Backstage
- Formatting documents:
- PowerPoint 2010
- Creating a new presentation
- Organise into Sections
- Changes to the Slide Master
- Text formatting options
- Working with images
- Inserting pictures
- Screen capture
- Background removal
- Building charts
- Using the drawing tools
- Improved Animations and Transitions
- Running a slide show
- Convert to Video
- Video editing