Excel 2007 Intermediate
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
Excel 2007 Intermediate

Duration
1 day

Description
Designed for existing users. If required courses may be tailored. Please call to discuss content.

Pre-requisites
Attendance of the Introduction course or equivalent knowledge

Objectives
The aim of this course is to have the participant `up and running' immediately following a one day intermediate programme based upon their existing skills and future needs. At the end of the course the participant should be able to create a good selection of spreadsheets and graphs. This course will assist users to prepare for the Excel 2007 Core Microsoft Office User

Course Contents
Specialist Exam.
Refresher of the Basics
Page Setup Options
Margins
Headers and Footers
Printing Titles
Sheet Options
Scaling
Page Break Preview
Setting Print Areas
Sheet Background
Working with Large Spreadsheets
Freezing screen titles
Splitting windows
Ranges
Creating and naming ranges
Clearing and formatting ranges
Copying and moving ranges
Graphs and Charts
Charts
Creating, formatting and editing a chart
Printing Charts
List Data
Creating a List
Sorting a list
Finding, extracting and deleting records
AutoFilter
AutoComplete
Formatting Tables with Filters (Format Tables)
Drawing/Shapes
Creating and modifying lines, objects and 3D shapes
Worksheet and File Linking
Creating simple links
Multiple sheet formulae
Watch Window
Internet/Intranet Document Creation
Saving as HTML
Save as PDF
 
Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...  
My Location
Results for location are highlighted in the table below. Click here to remove highlight
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
Tools
 
Key Details
Duration1 day
 
£155
per delegate
 
 
Bookings Helpline: 01933 233884 (Monday to Thursday - 8:00am to 5:30pm and Friday 8:00am to 5:00pm).