Western Kentucky University

CWD: Courses: New

Courses for:

Computer Training

Print this page

Intermediate Excel 2010

Session Format:

4 Hours Total

Introduction

Prerequisite: Experience entering data into Microsoft Excel 2010, familiarity with Windows and basic computer skills

This course will introduce Excel users to charting features and database management in Microsoft Excel 2010. Participants will design worksheets that meet Excel criteria for database functions such as sorting and filtering. Database design criteria, Subtotals, PivotTables and PivotCharts will be covered in depth. 

Objectives

The participant will learn: (1) how to link sheets and files together (2) how to use the conditional functions (3) how to use essential list management

Content Outline 

  • Differences in the ribbon and the toolbar
  • Using date functions
  • Vertical/horizontal lookups
  • Statistical functions
  • String functions
  • Creating databases
  • Using databases
  • Sorting and querying
  • Print management techniques

Who Should Attend  

This seminar is intended for supervisors, managers, and mid-level managers who create spreadsheets on a regular basis and have mastered Introduction to Excel 2010.

Training Consortium of South Central Kentucky

 

 Last Modified 7/22/13