|
Excel Intermediate
April
22 – April 24, 2008
Tuesday/Thursday
5:30
– 8:30 p.m.
$95
+ $10 registration fee
Books
available at YCCC Bookstore (approx. $20)
Students
will learn how to work with large worksheets, use 3-D formulas, customize
Excel's toolbars and menus, apply special cell formatting, sort and filter
lists, create combination charts and trendlines, use Excel's auditing features,
and work with templates.
|
Working
with large worksheets
Topic A: Viewing options
Topic B: Hiding, displaying, and outlining data
Topic C: Printing large worksheets
Using multiple worksheets and workbooks
Topic A: Using multiple worksheets
Topic B: Linking worksheets by using 3-D formulas
Topic C: Consolidating data
Topic D: Linking workbooks
Topic E: Managing workbooks
Customizing Excel
Topic A: Using the Options dialog box
Topic B: Customizing toolbars and menus
Advanced formatting
Topic A: Borders and shading
Topic B: Using special number formats
Topic C: Working with dates
Topic D: Working with styles
Topic E: Other advanced formatting
|
List management
Topic A: Examining lists
Topic B: Sorting and filtering lists
Topic C: Advanced filtering
Advanced charting
Topic A: Chart formatting options
Topic B: Using combination charts
Topic C: Using graphic elements
Documenting and auditing
Topic A: Auditing features
Topic B: Comments and text boxes
Topic C: Protection
Topic D: Workgroup collaboration
Using templates
Topic A: Built-in templates
Topic B: Creating and managing templates
|
|