| Training & Development - Technical Training Curriculum
[Back to course listing]
Microsoft
Excel: Charting and Linking
This 3-hour class focuses on how to link worksheets to other worksheets or workbooks. You will learn how to add and remove documents in multiple workbooks. You will get chance to audit a worksheet. You will work with charts in more depth.
Presenter(s): Frank Widman, Senior Technical Training Consultant
Prerequisite: Excel Basics or equivalent experience. Excel 2 and 3 are not prerequisite for this class.
Enrollment: Use our Online
Registration Form,
or call 459-5565.
Additional Information: This class is intended for users on either PC or Mac. The software, class, materials and user interface are interchangeable in both labs.
Related Courses:
| Schedule |
| Date |
Time |
Fee |
Location |
|
February 29, 2012
May 22, 2012
|
9am - 12pm
|
$15 |
Kerr Hall Room 8
|
Course Outline
- Linking Worksheets
- Link information from one part of a worksheet to another part of the same worksheet
- Link multiple worksheets
- Use links
- Manage links
- Delete links
- Working with Workbooks and Groups
- Add other worksheets to a workbook
- Change the order of worksheets
- Group worksheets
- Format multiple worksheets simultaneously
- Consolidate date from multiple worksheets
- Auditing a Worksheet
- Trace precedents
- Trace dependents
- Remove auditing marks
- Show information for a cell
- Working with Charts
- Create a chart on a chartsheet
- Use the Chart toolbar
- Change the chart type
- Add legends, labels, gridlines, arrows and unattached text
- Select and format parts of charts
- Adjust the value scale
|
