Excel 2007 Intermediate

Core Topics

Manipulating Data, & Named Ranges

• Paste Special

• Transposing rows and columns

• Importing text and text delimiters

• Named ranges in cells

• Using names ranges in formulae

• Deleting named cells/ranges

• Creating & removing subtotals

Templates

• Creating templates

• Opening and editing templates

Formatting & Display Techniques

• Formatting tables

• AutoFormat options

• Conditional formatting

• Creating custom formats

• Freezing cells and rows

• Hide and unhide rows and columns

• Hide and unhide worksheets

Sorting & Querying Data

• Sorting data

• Filtering and using Autofilters

• Filtering unique records

• Advanced Filter

Linking & Consolidating Data

• Linking cells

• Linking charts to data

• Linking between worksheets

• Linking between workbooks

• Linking data across applications

• Linking data to charts across applications

Charts Formatting Techniques

• Changing the angle of pie chart slices

• Formatting chart axes fonts & scales

• Chart titles, legends and data labels

• Adding & deleting a data series

• Advanced formatting – inserting graphics

Protection & 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

Follow up Courses

Excel 2007 Advanced