Microsoft Excel 2007 Intermediate Level

Computer Training Courseware Materials for Office 2007

Training Course Outline.

MANIPULATING DATA, & NAMED RANGES

Paste Special
Transposing data
Importing text and delimiting by space, comma or tab
What does naming a cell range mean?
Rules for naming cells and ranges
Naming cell range(s) in a worksheet
Named ranges within formulas
Navigating through workbooks using named ranges
Creating named ranges automatically based on cell values
Deleting named cells/ranges
Creating subtotals
Removing subtotals

TEMPLATES

Using templates
Creating templates
Opening and editing templates

FORMATTING & DISPLAY TECHNIQUES

Formatting tables
Formatting tables using table styles
Formatting cell ranges using conditional formatting
Creating custom number formats
Freezing the top row
Freezing the first column
Freezing the top row and the first column at the same time
Hiding and un-hiding rows
Hiding and un-hiding columns
Hiding and un-hiding worksheets

SORTING AND QUERYING DATA

Sorting internal Excel databases
Custom sort options
Using AutoFilter to query data
Multiple queries
Removing filters
Top 10 AutoFilter
Filtering unique records
Advanced Filter

LINKING & CONSOLIDATING DATA

Linking individual cells within a worksheet
Linking charts to data within a worksheet
Linking a cell range on one worksheet to another worksheet (within the same workbook)
Linking data on one worksheet to a chart in another worksheet (within the same workbook)
Linking data from one workbook to another
Linking a chart from one workbook to another
Copying data from Excel into a Word document
Linking data from Excel into a Word document
Copying a chart from Excel into a Word document
Linking a chart from Excel into a Word document
Consolidating data over several worksheets or worksheet pages

CHARTS FORMATTING TECHNIQUES

Changing the angle of pie chart slices
Formatting the chart axis fonts
Formatting the chart axis scales
Formatting the chart axis text orientation
Creating and positioning a chart title
Re-positioning a chart legend
Re-positioning chart data labels
Exploding the segments within a pie chart
Deleting a data series within a chart
Adding a data series to a chart
Modifying the chart type for a defined data series
Widening the gap between columns / bars within a 2-D chart
Inserting an image into a 2D chart (as a background)
Inserting an image into a 2D chart (to format a column or bar of data)

PROTECTION AND SECURITY

Specifying a password for opening a workbook
Using the “read-only recommended” option
Removing a password from an Excel workbook
Protecting a worksheet or worksheet elements
Removing workbook protection
Allowing selective editing of a protected worksheet

Other Microsoft Office 2007 Courseware materials

Customisable Courseware
No Annual Renewal Fees
Unlimited Number of Users
Unlimited Reprinting Rights
PLUS Intranet Versions

Please select your region
UK/Ireland | USA/Canada | Australia/International

   Computer Training Courseware for IT Teaching Professionals
    Quality courseware materials for tutor-led computer training:
    For schools, colleges, IT trainers, corporate training departments, & computer training companies.