Skip to main content
Western Kentucky University


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: New

Print this page

Intermediate Excel 2010


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. 


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 

  • Charting: Creating and Modifying a Chart
    • Sparklines: New in Excel 2010
  • Formulas: Using the Pointing Method and understanding the hierarchy of calculations in Excel.
    • Explaining Conditional Operators
    • Relative versus Absolute Formulas
  • Working with Lists: The Do's and Don'ts of Creating Lists
    • Working with the Format Painter
  • Sorting
    • Single level and Multi Level Sorts
  • Filters
  • Subtotals
  • More Functions: Count, Count If, Sum If
  • Linking and Grouping
    • Linking worksheets with Paste Special
    • Consolidating Worksheets the easy way
  • Conditional Format and Cell Styles
  • Adding Comments and Shapes to a Worksheet
  • Naming Cell References


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.

SIMPSON Co. Consortium Training


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