Management Development Center Banner

How to Reach Us

FHSU Management Development Center
Fort Hays State University
600 Park Street
McCartney Hall 224
Phone: 785-628-4124
Email: slwilliam@fhsu.edu
Contact Us

Management Development Center on Facebook Management Development Center on Linkedin Management Development Center on Twitter

Intermediate Excel: Data Analysis

Overview

This three and a half hour training will provide participants with hands-on Excel training.  Participants will be exposed to numerous time savings features such as:  pivot tables, vlookup, and what-if-analysis including goal seek and scenario manager.  They will learn how to apply these functions to your real-world problems to increase productivity and improve efficiency by analyze large quantities of data and produce user friendly output.  These skills can allow participants to increase productivity and improve efficiency by streamlining the workflow. This workshop is perfect for those who want to build on the skills they learned in the MDC’s Intermediate Excel course or for the Excel user familiar with the topics being covered.

Learning Outcomes

  • Organize worksheet and table data using multiple techniques
  • Create and use defined names in a workbook
  • Use a range of lookup and reference functions
  • Understand and create simple PivotTables and Pivot Charts
  • Summarize information quickly using Pivot Tables
  • Utilize advanced features to create and manage PivotTables
  • Create and work with scenarios and the Scenario Manager
  • Solve problems using Goal Seek and Data Tables
  • Utilize the lookup functions to quickly find and display cell content
  • Use solver to solve more complex and intricate problems
  • Import/export data using Excel

Facilitator

This workshop is facilitated by Dr. Emily Breit

Back to top