Microsoft Excel 2007 Intermediate
Sponsored links
The Intermediate level of Excel is designed to build on existing skill in creating, editing and using formulae and functions in spreadsheets. To be conversant with tools such as Goal Seeker and Database.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
Review of basic skills:
Worksheets
Writing formula using the mouse
Right mouse button menus
Using the Function Wizard:
IF functions, Date functions
Absolute cell references
Multiple page spreadsheets
Charts:
Creating bar/line charts from the worksheet
Chart ranges, legends, titles
Chart enhancements with text, colour, shapes
Advanced charting techniques
Database:
Creating a database
Filtering records
Sorting information
Subtotals
Range Navigator:
Naming ranges
Using Range Navigator
Auditing Toolbar
Printing:
Basic skills - ranges, headers, footers, page breaks
Printing charts separately and with data
Printing Titles
Page orientation and compression
This Training Course is taught in classrooms in the following locations:
Guildford
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
