York County Community College
York County Community College
About YCCC Academic Programs Admissions Continuing Education Campus Services Continuing Education Online Courses
York County Community College York County Community College
York County Community College
Continuing Education
& Business Services
Home
College For Kids - Summer 2008
Course Brochures
Courses
EMS
Events
Financial Assistance
Funding for Business
Health Professions
Leadership & Management
Newsletter
Online Training
York County Community College York County Community College

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

 

Home Email Login Site Map Search Contact Us Campus Directory