• Home
• Course Catalogue
• Certifications
• Onsite Training
• Scheduled Training
• E-Learning
• Managed Services
• Consulting
• Company
• Special Offers
• News
• Links
• Enquiry And Feedback Form

Training Course Outline

IT Vendor Courses   User Microsoft Office Training Courses

Excel 2002 Level 3

This course has been retired. Please view currently available User Microsoft Office Training Courses.

View course dates

Course Duration: 1 Day

Course Code: DEXXPA

Course Description:

On this one day course, students will customize their workbooks, work with multiple data sources, collaborate with other users, enhance their spreadsheets using charts and graphic objects.

Relevant Certifications:

MOS: Microsoft Office XP Track

This course includes the following modules:

Topics Covered

• Apply conditional formatting, add data validation criteria, customize menus and toolbars, create, edit, and run macros. The student will also view data using the outline.
• Create a workspace, consolidate data, and view the consolidated data and link cells.
• Protect their worksheet, protect their workbook, add and remove file passwords, share their workbooks, Set revision tracking, merge workbooks, and track changes.
• Chart non-adjacent data, modify embedded charts, and modify chart items, and add a trend line to their chart.
• Create, change the order of, group, move and copy, and format graphic objects. They will also insert and modify clipart.

 

To make an enquiry for this course to be run ONSITE at your location, click here or call Sales on +44 (0) 20 7620 0033.

Perpetual Solutions are a global provider of onsite training solutions throughout London, UK and the rest of the world. For scheduled training our UK partner network provides an unrivalled choice of courses.

Save as PDF

Print this course