Western Kentucky University

CWD: Courses: Computer Training

Courses for:

Computer Training

Print this page

Advanced Excel 2010

Session Format:

4 Hours Total


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


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 2010)

Training Consortium of South Central Kentucky

 Last Modified 7/22/13