Excel 2007 Intermediate
Short course
In London
Description
-
Type
Short course
-
Location
London
-
Duration
1 Day
The aim of this course is to provide delegates with further practical experience of Microsoft Excel 2007. By the end of the course delegates will be able use further functions, manage lists and use charts and drawing tools. Suitable for: This course is designed for existing users of Excel who want to learn new skills and apply them effectively.
Facilities
Location
Start date
Start date
About this course
Delegates should have a working knowledge of Excel 2007, gained through the attendance of an Excel 2007 one day introduction course or through experience in the work place.
Reviews
Course programme
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
Excel 2007 Intermediate