Microsoft Excel Intermediate

Microsoft Excel 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
·       Product overview
·       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
Database Features
·       Using a spreadsheet as a database
·       Sorting data
·       Basic subtotals
·       Filtering data with AutoFilter
·       Custom AutoFilter
·       Data form
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
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
·       Printing a chart