Skip to main content
Western Kentucky University
EMERGENCY ALERT SYSTEM:

WKU WEATHER ALERT:

Classes beginning at 4pm today on the WKU Bowling Green campus are canceled. ALL Thursday and Friday classes on all campuses are also canceled. Online classes will proceed as scheduled. WKU offices will be closed on Thursday, with essential personnel reporting.

WKU Owensboro closed at noon today (Wed., 3/4).

WKU Glasgow evening classes that begin at 5 pm today will be canceled and the WKU Glasgow campus will close at 7 pm.

WKU Elizabethtown-Fort Knox campus will close today at 3 pm and will remain closed Thurs., Fri, and Sat., March 5-7.

Should inclement weather make travel hazardous, residence halls will remain open until Saturday. Follow WKU Housing & Residence Life for updates.

The high school regional basketball tournament games scheduled for tonight have been canceled. Games will be rescheduled for Friday/Saturday. Follow WKU News for the latest updates. #WKUAlert

CWD: Courses: Computer Training

Print this page

Advanced Excel 2007

Session Format:

4 Hours Total (One 4-Hour Session)

Introduction

This is an extension of the Intermediate Excel class and will cover advanced features and student requests. Course content includes various functions, math features, and macros.

Objectives

The participants will be involved in: (1) creating action queries, (2) creating macros, (3) linking to and grouping worksheets to creating a workspace in excel, (4) working with pivot tables and charts, (5) working with goal seeking, and (6) using more advanced formulas.

Content Outline

  • Using date functions
  • Statistical functions
  • Creating databases
  • Sorting and querying
  • Vertical and horizontal lookups
  • String functions
  • Using databases
  • Print Management techniques
  • Other advanced topics

Who Should Attend

This seminar is intended for supervisors, managers, and mid-level managers who create spreadsheets on a regular basis.

(Prerequisite: Intermediate Excel 2007)

Note: documents in Portable Document Format (PDF) require Adobe Acrobat Reader 5.0 or higher to view,
download Adobe Acrobat Reader.

Note: documents in Excel format (XLS) require Microsoft Viewer,
download excel.

Note: documents in Word format (DOC) require Microsoft Viewer,
download word.

Note: documents in Powerpoint format (PPT) require Microsoft Viewer,
download powerpoint.

Note: documents in Quicktime Movie format [MOV] require Apple Quicktime,
download quicktime.

 
 Last Modified 9/25/14