upgrading to excel 2007
Upgrading to Excel 2007 is designed for people who are upgrading to
Microsoft Office 2007 and need to understand the changes and new
features in Excel 2007.
The skills and knowledge covered in this course will allow you to become
quickly proficient in the changes and new features introduced in
Microsoft Excel 2007.
This course assumes prior knowledge of Microsoft Excel 2000, 2002 or 2003.
The course duration is a half day 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 Excel 2007
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
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
