Excel 2000 Power User
Send A Message
Description and objective: This hands-on course is designed to further enhance the skill of experienced Excel 2000 users. Delegates will be introduced to the techniques associated with analysis and manipulation of data in spreadsheets, including pivot tables and database functions, recording macros and creating workgroup templates
Skills required prior to the course
To fully benefit from this course, attendees are expected to be confident users of Excel 2000 and be familiar with the topics covered in the Excel 2000 Foundation and Intermediate courses
What you will learn
On completion of the course, delegates will be able to:
· Analyse worksheet data using pivot tables
· Analyse worksheet data using Scenario Manager, Goal Seek and Solver
· Create templates for individual and group use
· Record macros
· Apply the various protection settings to shared workbooks
· Customise the Excel workspace
Who should attend
Experienced users of Excel 2000. In particular, delegates should be confident with building multiple worksheet and workbook formulas, have a sound understanding of how Excel functions are written, use Range names in formulas and work with Excel lists
Course size
Maximum 6 delegates
Topics
Working with Databases
Working with the Data Form
Using AutoFilter
Working with Advanced Filters
Importing and Exporting Data
Using Conditional and Custom Formats
Using Templates
Using Worksheet Protection
Sharing Workbooks
Working with Data Series
Using Scenarios and Goal Seeking
Using Data Tables
Using Auditing Tools
Solving Problems
Using the Report Manager
Using Macros
Recording Macros
Editing Macros
Using Custom Toolbars and Buttons
Creating a Macro Button
Working with the Data Map
Working with Views
For further details of topics covered in this outline please refer to our web site at:
www.laidlaw-constable.co.uk
Contact Laidlaw and Constable Ltd
| Phone | 0207 436 4411 When calling be sure to mention Training Pages
| Fax | 020 7436 8533 |
|
Send a Message
Back to Top