Lane Business Center


Lane Business Development Center
 
 
Business Development & Customized Employee Training  

 
 

1445 Willamette Street • Eugene, Oregon • (541) 463-5255

 
   
 
To confirm that this course is being offered this term, check our current courses listing.
 
 
Business Solutions with Excel Series

Learn advanced functions and formulas of MS Excel in this three-part series. Simplify your work, perform what-if scenarios, display complex data in pivot tables, and improve the integrity of your data. Learn how to use Solver and Goal Seek to fi nd optimum solutions, use lists like mini-databases, create userfriendly input tools, and simplify work with macros. Sign up for individual modules, or register for the series and save!

Module 1: Basics Get started with Excel! Learn how to create, modify, print, and format worksheets; work with basic formulas and functions; enhance worksheets using backgrounds, graphics and diagrams; use templates, styles, and AutoFormats; and use Find and Replace.

Module 2: Formulas and Functions Focus on the advanced features of Excel that help businesses work smarter. The emphasis is on working in multiple worksheets and workbooks, using advanced functions, using advanced formatting and printing features, fi ltering data, working with charts, and naming cells, formulas, and ranges. Topics include data protection, integration with other applications, and the Web.

Module 3: Data Lists and Pivot Tables Course content includes data validation techniques; data fi ltering and sorting; pivot tables and charts; use of Excel’s auditing and what-if analysis tools.
 
 

When you are ready to register... registration instructions / registration form

Please have the Course Registration Number (CRN) ready. To confirm that this course is being offered this term, check our current courses listing.

 
 
Close this window