Winthrop University Home Page
Menu Header

Continuing and Professional Education

Advanced Excel - Managing and Analyzing Data


The Microsoft Excel course will help participants learn advanced features of Excel. The course will help participants understand and interpret the reports and graphs they generate.

Download the course flyer (pdf - 379 KB)

Course Objectives

  • Create descriptive summaries of data
  • Generate separate linked worksheets for individuals or months
  • Generate graphs that will automatically update
  • Use filters effectively
  • Develop pivot tables to summarize data
  • Create formulas to give you subcomponents of cells, join two cells contents, and other useful formulas and functions (if, count if, find…)
  • Use conditional formatting to highlight data that is extremes
  • Develop lookup - vertical and horizontal
  • Present findings from data orally and in written form
  • And more…

Target Audience

This workshop is designed for working professionals in a wide variety of disciplines and contexts, including business management, marketing, human resources, finance and banking, project management, law, healthcare management, engineering, etc.

Dates and Time (12 Hours of Instruction) 

June: Mon 6/11, Wed 6/13, Thu 6/14, 8 :30am to 12:30pm
July: Tue 7/10, Thu 7/12, 9 am to 4pm (6 hours of instruction and 1 hour for lunch)


On-campus, face-to-face


MS-Excel: $375; MS-Excel; with Badge option: $425;

MS-Word and MS-Excel Bundle: $650; with Badge option: $750


All instruction materials will be provided during class.

Instructor Bios

Edith DilleDr. Edith Dillé is Assistant Professor of Quantitative Methods at Winthrop University. She holds a Ph.D. from the University of South Carolina.







Terry GuidryTerri Guidry is Assistant Professor of Management Information Systems at Winthrop University. She holds a MBA from Winthrop University and completed additional graduate work in Computer Science at the University of West Georgia.





Register and Pay

© Winthrop University · 701 Oakland Avenue · Rock Hill, SC 29733, USA · 803/323-2211