Microsoft Excel 2007 Intermediate

Microsoft Excel 2007 Intermediate

One Day Course

Assumed Knowledge: 
A working knowledge of Excel gained from prior attendance on a Jarrold Training Microsoft Excel Introduction course or from a user environment.

Course Outline:
Revision
·       New Features and Product overview
 
·       File Formats and Working in Compatibility mode
 
·       Quick Access Toolbar and Excel Options
 
·       Revision Exercise
 
Functions
·       Date function
 
·       Time function
 
·       Round function
 
·       IF function
 
·       Integer function
 
Cell Addressing
·       Absolute cell addresses
 
·       Relative cell addresses
 
Conditional Formatting
·       Applying conditional formats to text
 
·       Format as a table
 
·       Custom Cell Styles
 
Database Features
·       Using a spreadsheet as a database
 
·       Sorting data
 
·       Basic subtotals
 
·       Filtering data with AutoFilter
 
·       Custom AutoFilter
 
·       Define a range as a table
 
·       Find Feature
 
Working with Multiple Sheets
·       Selecting sheets
 
·       Inserting & deleting sheets
 
·       Copying sheets
 
·       Copy and paste between sheets
 
·       Naming sheets
 
·       3D calculations
 
·       Group edit facility
 
Working with Multiple Workbooks
·       Opening multiple workbooks
 
·       Arranging windows
 
·       Linking workbooks
 
·       Using Hyperlinks to link worksheets and workbooks
 
Additional Features
·       Inserting comments
 
Charting
·       Revision of basic charts
 
·       Chart types
 
·       Sizing and moving a chart
 
·       Editing a chart
 
·       Changing chart data
 
·       Formatting chart elements
 
·       Drawing features
 
·       Drawing features
 
·       Printing a chart