OFFICE UPGRADE 2010

GETTING STARTED

Microsoft 2010 - The User Interface

• Starting Word 2010

The Ribbon

• The Home Tab
• Customisable Ribbon Tabs
• Benefits of the Ribbon
• Dialog Box Launchers
• Screen Tips
• Using the Ribbon
• Opening and Closing Backstage view

The Options Dialog Box

• The Options Dialog Box
• Customising the Ribbon
• Removing a Group

The Mini Toolbar

Live Preview

Paste Preview

• The Mini Toolbar
• Using the Galleries and Live Preview
• Using Paste Preview

Print Options

• Print Preview

Saving Files

• Inter Conversion of Access Databases in Different Formats
• Easy Identification of Macro-Enabled Files
• The Compatibility Checker Feature
• The PDF and XPS File Formats

MICROSOFT WORD 2010

Microsoft Word 2010 Interface

The Navigation Pane

• The Navigation Pane
• The Find Tool
• Advanced Find

Text Improvements

• Text Styles
• The Themes Command
• New Text Effects
• Font Styles and Typography
• Changing Font Formats
• Creating a Quick Style
• Applying the New Style

SmartArt Graphics

• Inserting WordArt
• Adding SmartArt
• Applying a Theme

Screenshots

• The Remove Background Tool
• Crop and Compress Options
• Inserting a Screenshot
• The Screenshot Tool
• The Crop Tool
• The Compress Tool

Compare Reviewed Documents

• The Tri-Pane Review Panel
• Comparing Documents

MICROSOFT EXCEL 2010

Microsoft Excel 2010 Interface

Working With Tables

• Excel Template Enhancements
• Creating a Table
• Filter Data in a Table
• Adding a Filter to an Existing Filter
• Removing the Filter

The Enhanced Formula Bar

• New Function Categories
• The Formula AutoComplete Feature
• Applying a Range Name
• Renaming Ranges
• Creating a Calculation

Enhanced Conditional Formatting Options

• Conditional Formatting Types
• Previewing Conditional Formatting
• Applying Conditional Formatting across worksheets
• Use Conditional Formats to Highlight Trends

Charts

• Chart Data
• Chart Templates
• Enhanced Charting Tools
• Creating a Chart
• Modifying Chart Axes Labels
• Changing the Chart Type
• Changing the Chart Style
• Updating the Chart Title
• Saving the Chart as a Template

Sparklines

• Types of Sparklines
• Markers
• Creating a Sparkline

PivotTables and PivotCharts

• PowerPivot
• Calculation in PivotTables
• Enhanced PivotCharts
• Slicers
• Creating a PivotTable and PivotChart
• Filtering the PivotTable Data
• Formatting the PivotChart
• Inserting a Slicer into the PivotTable

MICROSOFT POWERPOINT 2010

Microsoft PowerPoint 2010 Interface

Themes and Styles

• Themes
• Create a Custom Theme Colour and Font
• Creating a Custom Colour Scheme

Picture Effects

• Applying Picture Styles and Effects
• Apply a Picture Style
• Apply a Picture Effect
• Create a Photo Album

Animation and Transition Effects

Transitions

• Apply a Text Animation
• Previewing Animations
• The Animation Painter
• Apply and Preview Transitions

Videos

• The Video Options Ribbon Group
• Adding Videos to Presentations
• Editing a Video
• Preview and Trim the Video

Sections in a Presentation

• Creating Sections in a Presentation
• Reordering Sections

MICROSOFT OUTLOOK 2010

Microsoft Outlook 2010 Interface

• Creating a Basic Message
• Replying to a Message

Quick Steps

• Flagging Mail Messages
• Displaying the Follow-Up folder
• Creating Priority Folders and Quick Steps

The Conversation View

• The Ignore Command
• Organise email by Conversations

Instant Search Feature

• Searching in Outlook
• Advanced Find

Sharing Calendar Information

• The To-Do Bar
• The Schedule View
• Schedule a Meeting
• Send a Calendar via E-mail

Sharing Contact Information

• Creating the Contact Information
• Formatting the Appearance of a Business Card
• Creating a Personal Signature
• Sending a Business Card