NEWCASTLE COMPUTER TRAINING

18 Wood St, Newcastle, NSW, 2302                     Ph 0249 62 4040

For more information visit the Newcastle Computer Training home page.


Microsoft Office 2007

Odd And Even Headers And Footers

Working With Formulas

The Office Button Using The Office Button

Adding Page Numbers Saving A Header Or Footer To

Expanding The Formula Bar And Name Box

Access Keys

The Gallery

The Formulas Tab

Using Access Keys The Ribbon Using The Quick Access Toolbar Understanding Help

Printing Using The Spell Checker Working With Illustrations

Using The Formulas Tab Using Names In Formulas Using AutoComplete To Create Formulas

Using Help

The Illustrations Group

New Statistical Formulas

Understanding Live Preview

Inserting A Picture

Using The Name Manager

Using Live Preview

Changing The Picture Styles

Using The Watch Window

Customising The Status Bar Understanding View Options Using Full Screen Reading View

Using ClipArt SmartArt Inserting SmartArt

Working With Tables Creating A Table

Zooming

The SmartArt Text Pane

Inserting Or Deleting Rows

What Happened To Microsoft Word 2007

Changing The SmartArt Style Changing The Colour Of SmartArt Styles

Modifying A Table Sorting Data In A Table Filtering

What’s New In Word 2007 The Word 2007 Screen Creating New Documents Word 2007 File Formats

Changing The SmartArt Layout Adding A New Shape To A SmartArt Graphic The SmartArt Tools Format Tab

Creating Charts In Excel 2007 Creating A New Chart Changing The Chart Layout

Using The Compatibility Checker Word 2007 Options The Word 2007 Ribbon

Resizing And Moving SmartArt Microsoft Excel 2007

Formatting Chart Elements Moving A Chart To A New Location

More On The Word 2007 Ribbon

New Features In Excel 2007

Saving A Chart Template

Using The Ribbon Using The Mini-Toolbar The Quick Styles Gallery Changing Style Sets Changing The Colours Theme Changing The Fonts Theme Themes Working With Themes Creating New Themes Adding A Cover Page Inserting A Blank Page Page Colour And Borders Building Blocks Using Tables In Word 2007

More New Features In Excel 2007 The Excel 2007 Screen The Excel 2007 Ribbon More On The Excel 2007 Ribbon Creating New Workbooks Excel 2007 File Formats Using The Compatibility Checker Excel 2007 Options Changing The View Formatting In Excel 2007 Using The Home Tab Commands To Format Data Merging Cells Themes

Using PivotTables Creating A PivotTable Report Adding Fields To A PivotTable Applying A Filter To A PivotTable Changing The PivotTable Value Settings PivotTable Design Options Creating A PivotChart From A Report Microsoft PowerPoint 2007 New Features In PowerPoint 2007 More New Features In PowerPoint 2007

Inserting A Quick Table Using Table Styles Changing The Table Layout Inserting A Table Drawing Tables Proofing And Printing

Cell Styles Modifying Built-In Cell Styles Saving A Workbook As A Template Conditional Formatting Highlight Cell Rules Using Data Bars

The PowerPoint 2007 Screen The PowerPoint 2007 Ribbon More On The PowerPoint 2007 Ribbon Creating New Presentations PowerPoint 2007 File Formats PowerPoint 2007 Options

Changing The Page Setup

Using Colour Scales And Icon

Inserting Section Breaks

Sets

Using Headers And Footers

Managing Rules

Working With PowerPoint 2007

Creating a New Calendar Entry Task Integration on the Calendar Internet Calendars

Changing The View Changing The Presentation Theme Backgrounds Inserting New Slides Formatting Text Slide Masters Inserting A Slide Layout Saving A PowerPoint Template Illustrations And Tables

Creating a Calendar Snapshot Internet Calendar Subscriptions Working with Multiple Calendars Scheduling Meetings Working with Contacts Electronic Business Cards Creating an Electronic Business Card Sending and Receiving Business Cards

Using SmartArt Graphics Creating A Table Inserting A Chart Modifying A Chart Creating A Photo Album

Managing Electronic Business Cards Concluding Remarks

Animation And Slide Shows

Setting Up Slide Shows Narration

Setting Slide Transitions Applying Custom Animation

Microsoft Outlook 2007

New Features in Outlook 2007

More New Features in Outlook

2007

Opening an Outlook Data File The Outlook 2007 Screen

The Navigation Pane The To-Do Bar

Using Instant Search Expanding the Search Recent Searches and Searching the Desktop Search Options Searching Other Outlook Items RSS Feeds

Working with Mail

Mail Messages Creating New Messages Previewing Attachments Colour Categories Assigning a Colour Category Setting the Quick Click Category Flagging Messages Managing Follow-Ups in the To-Do Bar

Setting a Follow-Up Flag for Recipients

Working with the Calendar

Calendar Views