- microsoft office
- Telstra
- convergence and telecommunications
- CIW
- courseware development
- contract trainers
upgrading to word and excel 2007
Upgrading to Word and Excel 2007 is designed for people who are
upgrading to Microsoft Office 2007 and need to understand the changes
and new features in Word and Excel.
The skills and knowledge covered in this course will allow you to become
quickly proficient in the changes and new features introduced in
Microsoft Word and Excel 2007.
This course may also be attended as a half day session if you require only Word or Excel upgrading knowledge. Contact us for more information.
This course assumes prior knowledge of Microsoft Word and Excel 2000, 2002 or 2003.
The course duration is 1 day.
The office button
Using the office button
Access keys
Using access keys
The ribbon
Using the quick access toolbar
Understanding help
Using help
Understanding live preview
Using live preview
Customising the status bar
Understanding view options
Using full screen reading view
Zooming
Microsoft Word 2007
What’s new in Word 2007
The Word 2007 screen
Creating new documents
Word 2007 file formats
Using the compatibility checker
Word 2007 options
The Word 2007 ribbon
More on the Word 2007 ribbon
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
Inserting a quick table
Using table styles
Changing the table layout
Inserting a table
Drawing tables
Proofing and printing
Changing the page setup
Inserting section breaks
Using headers and footers
Odd and even headers and footers
Adding page numbers
Saving a header or footer to the gallery
Printing
Using the spell checker
Working with illustrations
The illustrations group
Inserting a picture
Changing the picture styles
Using clipart
SmartArt
Inserting SmartArt
The SmartArt text pane
Changing the SmartArt style
Changing the colour of SmartArt styles
Changing the SmartArt layout
Adding a new shape to a
SmartArt graphic
The SmartArt tools format tab
Resizing and moving SmartArt
New features in Excel 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
Cell styles
Modifying built-in cell styles
Saving a workbook as a template
Conditional formatting
Highlight cell rules
Using data bars
Using colour scales and icon sets
Managing rules
Working with formulas
Expanding the formula bar and
Name box
The formulas tab
Using the formulas tab
Using names in formulas
Using autocomplete to create formulas
New statistical formulas
Using the name manager
Using the watch window
Working with tables
Creating a table
Inserting or deleting rows
Modifying a table
Sorting data in a table
Filtering
Creating charts in Excel 2007
Creating a new chart
Changing the chart layout
Formatting chart elements
Moving a chart to a new location
Saving a chart template
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 PivotTable from a report
